Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'The value you entered isn

    I have an Access 97 database that has been running flawlessly on an end-users machine for 2 years. This morning they called me tell me that whenever they enter a new record and enter a date they receive the message "The value you entered isn

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: 'The value you entered isn

    Check for any missing references.
    If you don't know where to go and check this, go into any code and select Tools/References.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'The value you entered isn

    Yep, I tried that and everything looks OK in my db. No broken references. That still would not explain the weird behavior in a newly created mdb file on the end users machine though right?

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: 'The value you entered isn

    Just a long shot here. How is the date format set up on the users machine in Windows? Any upgrades recently that could have changed it?

    I assume you compacted the database (if you can do that in 97??)
    Regards,

    Gary
    (It's been a while!)

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'The value you entered isn

    Thier short date style is mm/dd/yy in the windows regional settings. I had them try changing the short date settings to 4 digit year and it made no difference. The only other software they said they recently installed was "Pro System FX" and "Laser Librarian", both are tax software packages. I'm looking into if either of these programs use MS Jet and/or the DAO libraries and if perhaps an older dll was installed somewhere. I suppose I could have them uninstall Access and reinstall... but what a pain. Oh, and yes the database is compacted : )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •