re: hidden date entry into database

a bit easier : use the default property of your date column in access. Set that value to Now()



--
Steurm
www.steurm.net/steurm

 

As Steurm points out, adding a date/time field to the database whose default value is set to now() is simpler, but remember that the field is only set to now() when a record is first inserted.

If you update a record that has already been added and ish to update the date/time field, you have to do so explicitly.

 

Hello everyone,

I have a webform which allows a user to fill out personal information for our mailing list. I use web controls to hold these entries as parameters and these are then added to an Access database.

Here is my question.

I would like to record the time and date for each entry "under the hood". How can I automatically add the time and date the user is filling out the webform to my database?

Thanks

Clint