Results 1 to 6 of 6
  1. #1
    Gary MacDonald is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    4

    Data Going Weird on Different Computer

    I have a database I want to install on another computer. I originally did it on my original computer and want to put it on another computer for others to use.



    The problem lies that when I move over the database to another computer, running the same software, operating system my date calculations go weird on me.

    Originally this is how things are setup

    [Delivery Date] + 5 - Set to Short Date/Time

    Rather than add 5 days as it normally does on the original computer I programmed this on, it adds +5 (and more) to the month. It also reformats the date to some weird format 19th month?!

    For the life of me, I don't know what is going on. Can anyone help me identify the problem?

    Gary

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    Hi,
    did you check the date format on another computer? normally you have to use the window control penal to set the date format globally for your pc...

  3. #3
    Gary MacDonald is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    4
    Let me check that. That might be the problem. I'll keep you posted. Thanks.

    Gary

  4. #4
    Gary MacDonald is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    4
    That's it! Thanks, how silly and simple was that? I've been racking my skull (with major hair loss) for a month over this!

    Gary

  5. #5
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    Quote Originally Posted by Gary MacDonald View Post
    That's it! Thanks, how silly and simple was that? I've been racking my skull (with major hair loss) for a month over this!

    Gary
    Glad that it worked for you, so you are ready to make this thread is solved by using the Thread Tool? and also click on the scale the top right corner of the thread

    Good Luck!

  6. #6
    Gary MacDonald is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2011
    Posts
    4
    Done, thanks again.

    Gary

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Weird Text on Report
    By j2curtis64 in forum Reports
    Replies: 1
    Last Post: 05-03-2011, 03:16 PM
  2. Weird Error
    By KevinMCB in forum Access
    Replies: 1
    Last Post: 02-16-2011, 02:23 PM
  3. Date Paramater prints weird
    By NOTLguy in forum Reports
    Replies: 9
    Last Post: 10-20-2010, 07:58 AM
  4. Weird Query results
    By UCBFireCenter in forum Queries
    Replies: 0
    Last Post: 10-06-2009, 03:38 PM
  5. I need help with weird stuff happening on a DB
    By makotoshishio in forum Access
    Replies: 9
    Last Post: 04-02-2009, 12:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums