Help with time tracking database

  • Thread starter Thread starter Guest
  • Start date Start date
lol, Sorry about that, I did replace the generic names with the ones I'm
using, I just plasted the code from your earlier post on that last post.
With the right names, it is giving me that error.

Do you have
 
I will be working on this all night, so if you can stay on and help me out
that will be great. I really need to get this to work so I will be very
appreciative if you can stay on and help me out.

Thanks
 
What type of data field is EmpID field? If it's text, you need to delimit
the value with ' characters:

varTimeDate = DMax("TimeStampField", "TableName", "EmpID= '" & _
Me.EmpID.Value & "' And TimeStampField<#" & _
Format(Me.TimeStampField.Value, "m\/d\/yyyy h\:nn\:ss") & "#")
 
ya it is a text data type, what do I need to change in this code then :
varValue = DLookup("ClockIn", "TimeClock", "TimeStamp=#" & _
Format(datTimeDate, "m\/d\/yyyy h\:nn\:ss") & "# And SSN= " & _
Me.SSN.Value)
 
varValue = DLookup("ClockIn", "TimeClock", "TimeStamp=#" & _
Format(datTimeDate, "m\/d\/yyyy h\:nn\:ss") & "# And SSN= '" & _
Me.SSN.Value & "'")
--

Ken Snell
<MS ACCESS MVP>

Chou said:
ya it is a text data type, what do I need to change in this code then :
varValue = DLookup("ClockIn", "TimeClock", "TimeStamp=#" & _
Format(datTimeDate, "m\/d\/yyyy h\:nn\:ss") & "# And SSN= " & _
Me.SSN.Value)
Click to expand...


< snipped >
 
Hi Ken,

How do you get the toggle button to pop back out. You told me to set it to
null, I've tried a few things but I can not get it right. Can you show me
how to do it.

So far I have put this command into the on click event so that the record
will submit.

DoCmd.GoToRecord , , acNewRec
 
As I noted earlier, you need to set the value of the option group control to
Null. The option group control is the control that houses the two toggle
buttons.

Here is some simple code:

Me.NameOfOptionGroupControl.Value = Null


Note that the default name for an option group control that ACCESS assigns
begins with Frame.
 
Back
Top