asked on
VBA code to activate timestamp button on Access 2007 form
The Form in question, has four task categories and four adjacent time entry fields, currently users type in current time as they complete each task...and they complain about having to type.
I would like to create a command button for each time stamp, this would make it much easier for users to enter time as each task is completed.
I have very little experience in VBA.
Thanks much
I would like to create a command button for each time stamp, this would make it much easier for users to enter time as each task is completed.
I have very little experience in VBA.
Thanks much
Microsoft AccessVisual Basic Classic
Last Comment
lucyLuna
ASKER
@Dhaest, Thank you for the link...my problem now is:
What code I need to add to the command button's "on click" event, which will input" time() " into a field?
Also...is it better, or possible to write a macro for this function, instead of VBA?
It is likely I missed the solution in your reply...please point it out...I am new at this.
Thanks much
What code I need to add to the command button's "on click" event, which will input" time() " into a field?
Also...is it better, or possible to write a macro for this function, instead of VBA?
It is likely I missed the solution in your reply...please point it out...I am new at this.
Thanks much
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you so much, Gugro, your solution worked perfect!
http://www.classanytime.com/mis333k/sjdatetime.html