Auto Date Input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i auotmatically have the date input on new records when they are
created. If i use a form to input data into the table, but there is a field
in the same table with the date/Time format selected.
 
PC nerd,

Set the Default Value of the field to Date(). This can be done in the
design view of the table, or via the default vlaue property of the
control on your form.
 
I want the date automaticall input, without me having to anything.
even thoguh i have set the field to a date/time.
 
PC nerd,

Yes, I understand your requirement. Did you try the approach I
suggested by setting the Default Value of the field?
 
Another option is in the forms's before insert event. ( me.fieldname =
date() )
 
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

Updating tables when you input new data 0
Add one year in second combobox in vba 0
Data Copying 1
Properties - Format, Input Mask, Validation Rule 5
printing report with date 3
duplicate value error message - new issue 1
Input form that autocreates a new month 2
MM/DD date format no year 5

Back
Top