Using Access, I have created a form for employees to log in at the start of their day, log out for lunch, back in from lunch; and lastly, log out at the end of their day. What I want is to create a command that will automatically highlight the next button for them to click, based on their previous login (In, Out for lunch, return from lunch, End of day). Is this possible? Your guidance is much appreciated!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,395
- Office Version
- 2019
- 2007
- Platform
- Windows
I wasn't thinking so much in restrictions, just setting the default for the user and perhaps prevent missing entries.?
Upvote
0
Excel Facts
Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
welshgasman
Well-known Member
- Joined
- May 25, 2013
- Messages
- 1,395
- Office Version
- 2019
- 2007
- Platform
- Windows
The wizard will ask where you wish to store the value, so select the correct field.
Upvote
0
Similar threads
