cvansickle
New member
- Local time
- Today, 04:52
- Joined
- Feb 13, 2019
- Messages
- 6
Hello all, and again thanks in advance..
So I have a simple time clock database that I created for a department at work.
They user pulls down his name from a combo box and then enters a 4 digit password. Then he has two buttons
Clock IN & Clock OUT
When he/she hits the Clock IN button (using VBA Code) it grabs the date and and time. I also have a textfield call [datename] that captures a unique code
([datename] = [Today] & [Sorter_Name])
The when he/she hits the Clock out button, I would like it to find the first record based on the [namedate] field and add the clock out time.
the code I am using is
DoCmd.FindRecord "2/13/2019John Doe", , True, , True
This code work perfectly.. However, I want it to look into the textfield for the string.
DoCmd.FindRecord [namedate], , True, , True or
DoCmd.FindRecord me.namedate, , True, , True
But none of those work..
Any ideas what I am doing wrong? Can this be done??
Chad
So I have a simple time clock database that I created for a department at work.
They user pulls down his name from a combo box and then enters a 4 digit password. Then he has two buttons
Clock IN & Clock OUT
When he/she hits the Clock IN button (using VBA Code) it grabs the date and and time. I also have a textfield call [datename] that captures a unique code
([datename] = [Today] & [Sorter_Name])
The when he/she hits the Clock out button, I would like it to find the first record based on the [namedate] field and add the clock out time.
the code I am using is
DoCmd.FindRecord "2/13/2019John Doe", , True, , True
This code work perfectly.. However, I want it to look into the textfield for the string.
DoCmd.FindRecord [namedate], , True, , True or
DoCmd.FindRecord me.namedate, , True, , True
But none of those work..
Any ideas what I am doing wrong? Can this be done??
Chad