re: hidden date entry into database

[steurm]

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



--
Steurm
www.steurm.net/steurm

[Scott]

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.

[clint]

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

[bruce]

You can create a column in your db schema with date as the data type.

use this Date.Now to get the current date.


[b]quote:Originally posted by clint

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
</blockquote id="quote"></font id="quote">

B.

DiscountASP.NET
http://www.DiscountASP.NET