Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates instead of Numbers (Access 97)

    This is a stumper for us. On another list one of the members is using Access 97 and has a field that is intended for numbers. But whenever he enters data it tries to change the number into a date. He says that he has checked all of the formating, data type, he is not entering data into a form that is somehow changing the data. He has downloaded and installed SR-2 for Access 97. Still no positive results.

    It seems to me that a few years back I was having something similar and someone here told me to check some .dll files or something.

    Any ideas.

    TIA

    Bret

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Dates instead of Numbers (Access 97)

    There are several things that could be causing that sort of behavior. One is as you suggest, some sort of corruption of his Access installation. Another is corruption of his Access database - a compact and repair should catch that. Another is a format being applied to the table - dates are essentailly Double fields with special formatting. If none of these possibilities apply, then they could try attaching a cut-down version of their database and let someone else look at it.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates instead of Numbers (Access 97)

    Thanks Wendell,

    Compact and repair is one that I don't often think about and I should. I'll pass this along.

    Thanks again,

    Bret

Posting Permissions

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