Automatically inserting Date into Access

Using Dreamweaver MX and MS Access

[Stephen Tiller]

I would appreciate it if anybody can tell me how to automatically insert the date into a MS Access back end when somebody registers on my web-site. At the moment I manually check the database for new registrations and type in the date manually.

Steve

[ukgimp]

Do that in access itself so that when a new entry is inserted you have date added field that is set to now(), if now() does not work then it is date() :)

[davemarks]

or just use timestamp ;)

[oyster2]

See [office.microsoft.com...]

[Stephen Tiller]

Thanks everybody, much appreciated, tested and working okay plus good references.

Just for the record, as I know there are people unfamiliar to MS Access, and some that hate it (like my one of my boss's). The idiots guide to doing this is below:

Select the appropriate Field Name, set Datatype to Date/Time then click in the Default Value area to bring up the elipsis (...). Clicking on the elipsis brings up the expression buider, choose the functions ->built-in functions->Date/Time and choose now or date or appropriate.

Steve