Date Set

  • Thread starter Thread starter Johnson
  • Start date Start date
J

Johnson

Will someone tell me how to use a macro in Access 2000 to set the date in a
form field when the macro is run. Thanks in advance.
 
Use the SetValue action. To provide more info, you'll need to tell us more
details.
 
I would like to have a checkbox on a form that when checked the current date
and time is inserted into a field on the form.
Thanks
 
Put the macro on the AfterUpdate event of the checkbox control.

The macro's actions would be this:

Action: SetValue
Item: [NameOfTextboxControlOnForm].Value
Expression: IIf([NameOfCheckboxControlOnForm].Value=True,Now(),Null)
 
Beautiful, thanks for the help.
Ken Snell said:
Put the macro on the AfterUpdate event of the checkbox control.

The macro's actions would be this:

Action: SetValue
Item: [NameOfTextboxControlOnForm].Value
Expression: IIf([NameOfCheckboxControlOnForm].Value=True,Now(),Null)


--

Ken Snell
<MS ACCESS MVP>

Johnson said:
I would like to have a checkbox on a form that when checked the current
date and time is inserted into a field on the form.
Thanks
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Macro to set Reminder on a Contact tomorro 9:00 4
Access MS Access VB 0
Date fields - Combo Box and Text box 3
Access Automatically Send a notification email once a record is added 0
Pivot table macro filter data between yesterday and today (date+time) 0
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
#Type! error on form 6
Forcing a date entry format of dd/mm/yyyy 1

Back
Top