Time Stamp Record Entry

[David]

Hi,

I have a question regarding an Access 2007 database we currently use.

We have records submitted to the database from InfoPath forms and one of the
database/form fields is 'application date', InfoPath allows the field to be
populated with the current date and time using the 'now' function. The issue
with this is that the 'now' function inserts the date with the time that the
form is opened and this is shown in the database, what I actually need is
for the time to be the time that the data is entered on to the database as
the form can be open for hours before it is finally submitted.

The reason we need this is becuase we act on the data in the order that it
is submitted so we need to know what time is was sumitted as well as the
date.

Does anyone know how I can actually do this or if it is possible?

Looking forward to your input

 

[Graham Mandeno]

Hi David

I'm not an expert on InfoPath, but I think this should work...

Set the DefaultValue of your timestamp field in the Access table to Now()
and do not supply that field from InfoPath. That way, the record will be
time-stamped with the date and time it was created in the table.

 

[David]

Hi thanks for your reply,

I will try that suggestion, I had a feeling after looking at the database
that I should have done it there instead of on the infopath form.

Hi David

I'm not an expert on InfoPath, but I think this should work...

Set the DefaultValue of your timestamp field in the Access table to Now()
and do not supply that field from InfoPath. That way, the record will be
time-stamped with the date and time it was created in the table.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi,

I have a question regarding an Access 2007 database we currently use.

We have records submitted to the database from InfoPath forms and one of
the database/form fields is 'application date', InfoPath allows the field
to be populated with the current date and time using the 'now' function.
The issue with this is that the 'now' function inserts the date with the
time that the form is opened and this is shown in the database, what I
actually need is for the time to be the time that the data is entered on
to the database as the form can be open for hours before it is finally
submitted.

The reason we need this is becuase we act on the data in the order that
it is submitted so we need to know what time is was sumitted as well as
the date.

Does anyone know how I can actually do this or if it is possible?

Looking forward to your input