Current Date

[Guest]

If I use the Date Function in VBA to put the date in table but the user
current system has the wrong date and time in the Control Panel - Date and
Time. I was just wandering is there a way to make sure about the date and
time outside of the current user's system?

Robert

 

[Rick Brandt]

If I use the Date Function in VBA to put the date in table but the
user current system has the wrong date and time in the Control Panel
- Date and Time. I was just wandering is there a way to make sure
about the date and time outside of the current user's system?

Robert

If you are using a server database back end like SQL Server then you can use
a passthrough query to get the time from the server. Otherwise you're
pretty much stuck with the user's time.

 

[Guest]

Can the user see the computer that you want time to be based off of?
If so, then create a database on that computer with a table to hold the
current date and time, and with a timer to update the time every second [or
how often you need to measure time by.]
Then, on each person's computer, link to the table storing your date and time.
Then, instead of using the Date() command, just access the value from that
table.

Another alternative would be to get one of those programs that automatically
synchronize a computer's clock with the national observatory. However, if
they have the wrong date and time, they probably still have the PC set on
Redmond time (Pacific Daylight Time), which is what computers come installed
with.