TimeStamp not being captured consistently

G

gmaccess2

I have a split dB rolled out within my POB. Areas of the business have their
own forms to input data which is then captured in a main table on the backend.
One of the data fields I am capturing is a time stamp by using Date(). Out of
about 100 users, about 10-15% do not populate the backend table with the
timestamp. Their PC clocks are enabled and functioning correctly. Would
anyone know why it works for the majority and not for some? NOTE: I have not
tried NOW() guessing that the same thing would happen. Thanks in advance! GM
 
J

Jeff Boyce

You have a Date stamp if you are using Date(). If you need a date/time
stamp, use Now().

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
K

KARL DEWEY

How are you capturing is a time stamp? Is it a default of the table field,
default of filed in the form, or an event? The easiest would be a default of
the table field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top