DD's Employee Example

Employee Example Gallery


Employee Example V5

Employee Example V4

Employee Example V3

DD's Stats

Total Members: 160
Latest: drakopp
New This Month: 10
New This Week: 3
New Today: 1
Total Posts: 888
Total Topics: 452
Most Online Today: 1
Most Online Ever: 52
(May 02, 2020, 05:24:19 pm)
Users Online
Members: 0
Guests: 1
Total: 1

Recommended Posts

DD Approved Members group Added by DD Admin
05-06-2020, 12:48:35

Posting Additions or alterations rules by DD Admin
27-02-2020, 10:33:01

A Trip Down Memory Lane by DD Admin
24-08-2019, 14:17:16

Todays Birthdays

DD's Top Posters

DD Admin
Posts: 923
Posts: 70
Posts: 12
Posts: 8
Posts: 8
Posts: 5
Posts: 5

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

0 Members and 0 Guests are viewing this topic.

Offline DD Admin

  • Administrator
  • Hero Member
  • *****
  • Posts: 923
  • Karma: +5/-0
  • Gender: Male
  • Db Dreams Owner
  • Location: Margate, UK
  • Referrals: 16
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

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


Related Topics

  Subject / Started by Replies Last post
0 Replies
Last post February 22, 2019, 07:29:00 pm
by DD Admin
10 Replies
Last post September 01, 2019, 11:14:46 pm
by DD Admin
0 Replies
Last post October 14, 2019, 09:47:50 am
by DD Admin
2 Replies
Last post April 08, 2020, 07:58:55 pm
by DD Admin
0 Replies
Last post November 16, 2020, 06:55:45 am
by DD Admin

DD's Social Media

DD's Programs

Development Schedule

DD's Freeware


DJ 2020

Chart Tracker Elite

Works Manager

Contact Manager

Simple Home Accounts

Book Library

Picture Library

Project Manager (accde)

Developer Tools

Project Manager (accdb)

Style Manager

Code Library

Open Code Templates

Master Template

Task Management

Charitable Contributions

Bug Tracker Template

Time And Billing Template

Real Estate Template

Household Inventory V1

Open Code Examples

DD's Northwind V1

Employee Example V5

Grid Demo Example V1

Employee Example V4

Small Examples

Recent Topics

Apollo Project Status by DD Admin
January 20, 2021, 05:42:43 pm

Please welcome drakopp to DD by DD Admin
January 20, 2021, 03:06:42 pm

UK Singles/Albums Charts 08 Jan 2021 to 14 Jan 2021 Analysis by borobutch
January 20, 2021, 02:58:50 pm

Apollo Manual: Other Items by DD Admin
January 19, 2021, 09:46:46 am

Please welcome aaronsql2019@ to DD by DD Admin
January 18, 2021, 09:09:47 pm

Apollo Manual: Recordings by DD Admin
January 18, 2021, 01:40:58 pm

Apollo Manual: Preferences by DD Admin
January 18, 2021, 11:36:26 am

Database Dreams is not affiliated with Microsoft