However, if Citrix is involved it could be part of or all the cause. Years ago I used a utility to replace all spaces with underscores in an Access database because at the time Citrix didn't like the spaces.
To: "Paul Marashai" <Paul_Marashai@beaerospace.com>, "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Cc: "Sean Chen" <Sean_Chen@beaerospace.com>, "Joel Hunnicutt" <Joel_Hunnicutt@beaerospace.com>, "Matt Conger" <Matt_Conger@beaerospace.com>, "James Kurfees" <James_Kurfees@beaerospace.com>, "Jay Clarke" <jay_clarke@beaerospace.com>
Sent: Friday, January 23, 2015 12:45:58 PM
Subject: RE: [MS_AccessPros] Now() from China
Paul, brilliant! I bet this is it.
Jay?
From: Paul Marashai
Sent: Friday, January 23, 2015 10:45 AM
To: Liz Ravenwood; 'MS_Access_Professionals@yahoogroups.com'
Cc: Sean Chen; Joel Hunnicutt; Matt Conger; James Kurfees
Subject: RE: [MS_AccessPros] Now() from China
The translucent toolbar tells me this was on his local machine. He said he runs report in Citrix. So it is the Citrix clock or now() function in there to look at.
[cid:image002.png@01D03757.1555C790]
Thanks
Paul Marashai
Office + 480.403.0845
From: Liz Ravenwood
Sent: Friday, January 23, 2015 10:28 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Cc: Paul Marashai; Sean Chen; Joel Hunnicutt; Matt Conger; James Kurfees
Subject: RE: [MS_AccessPros] Now() from China
Interested point Jeff. I don't know. Sean?
However, Sean already showed what Excel yielded when he used the formula =now() and it gave the correct date.
From: MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, January 23, 2015 9:04 AM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Now() from China
Liz,
Is the computer in China a MAC? The MAC and the PC use different starting point dates that happens to be 4 years different. This is an issue in Excel. Maybe it spills over to Access.
Jeff
________________________________
From: "Liz Ravenwood liz_ravenwood@beaerospace.com<mailto:liz_ravenwood@beaerospace.com> [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
To: "MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>" <MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogroups.com>>
Cc: "Joel Hunnicutt" <Joel_Hunnicutt@beaerospace.com<mailto:Joel_Hunnicutt@beaerospace.com>>, "Matt Conger" <Matt_Conger@beaerospace.com<mailto:Matt_Conger@beaerospace.com>>, "James Kurfees" <James_Kurfees@beaerospace.com<mailto:James_Kurfees@beaerospace.com>>
Sent: Friday, January 23, 2015 10:54:50 AM
Subject: RE: [MS_AccessPros] Now() from China
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> [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, January 23, 2015 8:31 AM
To: MS_Access_Professionals@yahoogroups.com<mailto: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
http://www.viescas.com/
(Paris, France)
On Jan 23, 2015, at 3:44 PM, Liz Ravenwood liz_ravenwood@beaerospace.com<mailto:liz_ravenwood@beaerospace.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com<mailto: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 |
beaerospace.com<http://beaerospace.com>
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.
--
---
Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com
919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net<mailto:jpjones23@centurylink.net>
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.
[Non-text portions of this message have been removed]
--
Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com
919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net
Posted by: jpjones23@centurylink.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar