gigifarrow
asked on
Making a clock in access
I have a clock that I'm working with. I found the code on this website:
http://office.microsoft.com/en-us/access-help/add-clock-control-functionality-to-a-form-in-access-HP001121061.aspx?CTT=5&origin=HA001054662
It tells you step by step what to do. However, there is one part of the code that I wasn't sure about and it is the following step:
Paste the following line of code into the subroutine in the Visual Basic Editor code window to call the user-defined function ClockLoadDate, which will update the clock controls. Replace ActualArrivalTime with the name of the control that is bound to the underlying date/time field.
ClockLoadDate Nz(ActualArrivalTime, "")
For "ActualArivalTime" Im not sure what underlying date/time field should be which text box do I replace "ActualArivalTime" with.
Below is the form.
Copy-of-Inventory-db.accdb
http://office.microsoft.com/en-us/access-help/add-clock-control-functionality-to-a-form-in-access-HP001121061.aspx?CTT=5&origin=HA001054662
It tells you step by step what to do. However, there is one part of the code that I wasn't sure about and it is the following step:
Paste the following line of code into the subroutine in the Visual Basic Editor code window to call the user-defined function ClockLoadDate, which will update the clock controls. Replace ActualArrivalTime with the name of the control that is bound to the underlying date/time field.
ClockLoadDate Nz(ActualArrivalTime, "")
For "ActualArivalTime" Im not sure what underlying date/time field should be which text box do I replace "ActualArivalTime" with.
Below is the form.
Copy-of-Inventory-db.accdb
peter57r
ActualArrivalTime is the name of the textbox to the left of the h/m/s controls in the example.
ASKER
My clock is still not working. I keep getting a error,"Can't find End Sub". I look at the bottom and there is a End Sub.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.