Date and Time code

[zeidhaddad]

i'm looking for a vba code where i can click the command button to add the exact date and time Now() smthn like this ? any idea ?

 

[stumac]

if you have a control for the date and time on the same form to add the date and time you should be able to set it on the On click event

Private Sub [COLOR=#ff0000]MyButton[/COLOR]_Click()
Me[COLOR=#ff0000].MyField[/COLOR] = Now
End Sub

changing the names of the controls to your control names.

You can user the format function to format the now function as required.

 

[zeidhaddad]

Great! Thank you for your reply. what a smart way to elaborate :D