adding current date into Access using DW form

[Thinking Man]

I've looked all over this forum finding similar solutions but not exactly what
I'm looking for.

Relatively simple. My Access 2002 database has a timestamp column using the
timestamp data type. My form has a hidden field which I wish to use to enter
the current date and time when a person submits data via the web form into the
database.

I can see the record set will produce the date and time, but the date and time
does not actually go into the timestamp column.

My hidden field in the form is called timestamp. I've tried using Date() -
i've tried using {NOW} but for some reason it fails.

The timestamp field has a value of
<%= DoDateTime((rstblOnline.Fields.Item("timestamp").V alue), 0, -1) %>

Can anybody help me with this one?

Jerry

[Mark Richards]

First, be careful with naming conventions - timestamp. It might be reserved
somewhere.

Second, the hidden field should be readily available when the form posts as
the fieldname and accessible via javascript or (more familar to me) php.

I haven't worked with moving data over between the html session and a
particular format, like Excel, but once you see the field contents in, say, a
simple test javascript function (load it into alert()), then you can move on
from there.

[JEREMY]

Change the database not your code.
in access design view set the data type to "date/time".
At the bottom under the "general" tab find the line that says default value
and enter Now()
Now every time a record is added the date and time will automatically be
added to that column
Jeremy

"Mark Richards" <mark.richards@massmicro.com> wrote in message
news:drdqdg$p1j$1@forums.macromedia.com...

> First, be careful with naming conventions - timestamp. It might be
> reserved
> somewhere.
>
> Second, the hidden field should be readily available when the form posts
> as
> the fieldname and accessible via javascript or (more familar to me) php.
>
> I haven't worked with moving data over between the html session and a
> particular format, like Excel, but once you see the field contents in,
> say, a
> simple test javascript function (load it into alert()), then you can move
> on
> from there.
>
>