Hey John,
Checking this out, but the weird thing is that I have VBA SQL for an audit table and his username consistently comes in with a future date. So I got corporate IT all involved and emailing the user and he is showing that his computer date is accurate as well as the database record he created.
Now what I do on that form is have the field unlocked and enabled, but the data field default is date(). The date he showed comes in as dd/mm/yyyy format instead of mm/dd/yyyy. I emailed him this morning to ask if he took the default or over-wrote it somehow. I doubt he over-wrote it because the VBA that uses now() grabs the future date and it is the same VBA that the users in various other places in the world use.
I'm confounded.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, January 23, 2015 8:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Now() from China
Liz-
Now() returns the date on the machine. Are you sure the user hasn't screwed up the date?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 23, 2015, at 3:44 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Pros, I have a database where my now() function in VBA in China is coming in as future dates – like 4 years in the future. Anyone know of anything like this? I googled it, but don't see that there is any problems.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar