Need some help with error trapping dates

[Guest]

I wrote a database in which help desk agents use to input exceptions to their
daily work schedule. What I'm trying to do is prevent users from entering
exceptions that are back dated or future dated. They can only enter
exceptions for the current day. The database resides on a network drive. Is
there anyway in VBA you can write code to extract the current date of the PC
the actual database resides on? I design/maintain the database from another
PC so I don't have actual access to that computer the database resides on.
Or how else could I prevent users from changing the date on their PCs to a
date in the past or a date in the future and inputting exceptions that are
valid? Any help appreciated, thanks.

 

[John Nurick]

Hi Pareez,

There's code here http://vbnet.mvps.org/code/network/netremotetod.htm
that uses Windows API calls to get the time from another machine on the
network. That may do what you need. Despite the name of the site, it's
classic VB code that should work in VBA without much modification.

 

[Guest]

Thanks a lot, it works perfectly and will definitely prevent back
dated/future dated exceptions from being entered unless someone changes the
date on the server thanks again