+- +-

User

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

Stats

Members
Total Members: 20
Latest: Cheeco
New This Month: 2
New This Week: 1
New Today: 0
Stats
Total Posts: 220
Total Topics: 81
Most Online Today: 3
Most Online Ever: 24
(January 05, 2020, 06:31:08 pm)
Users Online
Members: 0
Guests: 0
Total: 0

Author Topic: Employee System Example V4 Errors And Corrections  (Read 224 times)

Offline Michael

  • Administrator
  • Sr. Member
  • *****
  • Posts: 252
  • Karma: +0/-0
  • Location: Margate, Kent, UK
  • Referrals: 0
Re: Employee System Example V4 Errors And Corrections
« on: September 14, 2019, 04:57:32 pm »
Just had an error reported this was missed between updates

open frmRequests in design view then edit the row source SQL
You can replace it with the below which points the assigned manager to the hidden form holding the defaults.

Code: [Select]
SELECT tblHolidayRequests.RequestID, tblEmployees.EmployeeID, [FirstName] & " " & [LastName] AS Employee, tblHolidayRequests.StartDate, tblHolidayRequests.EndDate

, tblHolidayRequests.HolidayNotes, tblHolidayRequests.HolidayType, tblHolidayRequests.StartHalfDay,

 tblHolidayRequests.EndHalfDay, tblHolidayRequests.ManagerID, tblHolidayRequests.Approved,

tblHolidayRequests.AssessedDate, tblHolidayRequests.ManagerNote FROM tblEmployees INNER JOIN

 tblHolidayRequests ON tblEmployees.EmployeeID = tblHolidayRequests.EmployeeID WHERE

(((tblHolidayRequests.ManagerID)=[Forms]![frmDetectIdleTime]![txtUser]) AND

((tblHolidayRequests.Approved) Is Null)) ORDER BY tblHolidayRequests.StartDate DESC

, tblHolidayRequests.Approved DESC;


Or just replace the manager ID Criteria with this [Forms]![frmDetectIdleTime]![txtUser] this will point it in the correct place.


plus also noticed the subform was not updating after adding a request so add the following to  frmMain

Replace CmdRequest Code with
Code: [Select]
    DoCmd.OpenForm "frmHolidayRequests", , , , , acDialog
    Me.ZfrmRequests.Form.Requery

« Last Edit: October 04, 2019, 09:59:08 pm by Michael »
Informative Informative x 1 View List

 

+-Recent Topics

Download Chart Tracker Elite 2020 by Michael
Today at 07:54:48 pm

User manual by Michael
January 22, 2020, 06:25:11 pm

UK Singles/Albums Charts 17 Jan 2020 To 23 Jan 2020 Analysis by Michael
January 18, 2020, 10:25:08 am

Project Status by Michael
January 17, 2020, 06:34:43 pm

First Chart (Test) by Michael
January 11, 2020, 09:27:19 pm

UK Singles/Albums Charts 10 Jan 2020 To 16 Jan 2020 Analysis by Michael
January 10, 2020, 07:35:57 pm

Concept of design by Michael
January 05, 2020, 01:08:18 pm

UK Singles/Albums Charts 03 Jan 2020 To 09 Jan 2020 Analysis by Michael
January 03, 2020, 11:56:45 pm

Members Deleted by Michael
January 02, 2020, 03:57:21 pm

Employee System Example V4 Errors And Corrections by Michael
December 29, 2019, 09:33:04 am