Link to home
Create AccountLog in
Avatar of lucyLuna
lucyLuna

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
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Avatar of lucyLuna
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
ASKER CERTIFIED SOLUTION
Avatar of Gugro
Gugro

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thank you so much, Gugro, your solution worked perfect!