Automatic date insersion...

[Bootfit]

I've got a form that writes to a database for news articles.

Is it possible to set up Access so it automatilcally inserts the date of when the article was added to the database??? Ideally in the dd/mm/yyyy format.

This might be basic stuff to the more advanced user but its all new to me

 

[Ron_dK]

One way of doing this might be :
Create a textbox on your form and put in the control source =Date()
Set the format to short date.
The display of dd/mm/yyyy depends on your windows settings.

Hth

 

[gonkowonko.com]

just make the default value on that column equal to either date() or Now()

when new records are inserted by default unless changed it will populate the field with todays date/time

 

[Bootfit]

just make the default value on that column equal to either date() or Now()

...how do i make a column have a default value?

...i can change its data type to Date/Time - is this what you mean or am i missing something???

 

[ghudson]

just make the default value on that column equal to either date() or Now()

when new records are inserted by default unless changed it will populate the field with todays date/time

Access does not have columns like a spreadsheet. Access tables have fields and records. Notice the design view of the table lists "Field Name". Set the default value of the field in question for your table to =Now()