beckysrightaccess
New member
- Local time
- Today, 00:47
- Joined
- Apr 18, 2014
- Messages
- 1
Hey everyone, thank you for any assistance in advance. I am fairly new to Access and I have tried everything I can think of.
I have created a timeclock for my employees and I am going to have the front end installed on each of their computers. When they open up the program, only their form will show and only for the current date.
I am able to get only their id with an older date or the date with the wrong employee.
I have this macro set up to run upon load of the form so they don't have to do anything but click clock in, out or other punches.
Please help? Thank you!
"Date()=" & [ClockDate] & " AND 2553=" & [EmpLookID] & "'"
I have created a timeclock for my employees and I am going to have the front end installed on each of their computers. When they open up the program, only their form will show and only for the current date.
I am able to get only their id with an older date or the date with the wrong employee.
I have this macro set up to run upon load of the form so they don't have to do anything but click clock in, out or other punches.
Please help? Thank you!
"Date()=" & [ClockDate] & " AND 2553=" & [EmpLookID] & "'"