Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2002
    Location
    Hutchinson, Kansas, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date() vs. Now() (Access97)

    I have a database in place with a half dozen different users in remote locations. They all use Access97. In a number of forms =Date() is used to provide today's date as the default value. At two of the sites, this worked fine initially. However, at some point something changed. Instead of seeing today's date when the form opened, there was an error message in the date field. #number or something like that. As soon as you click into that field the proper date come up, but it was very distracting to the users. At the other sites it still works fine. The only work around I've been able to come up with is to use =Now() instead. It works fine. But that requires the extra step for changing the format on all uses of that entry to ShortDate to get rid of the time. Anyone ever see this happen? Got any thoughts as to why? Thanks, Dave.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date() vs. Now() (Access97)

    The first thing to check in such circumstances is invalid references.

    Open any module (it may be an empty new one).
    Select Tools/References...
    Uncheck all references (if any) saying MISSING.
    Click OK.

    If the problem goes away, fine. Otherwise, post back.

  3. #3
    Lounger
    Join Date
    Dec 2002
    Location
    Hutchinson, Kansas, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date() vs. Now() (Access97)

    Thanks for the prompt reply. I will be a few days before I'm able to access this remote site and try the solution. I do wonder, however, since we are only going after date, would a missing reference do this? Also, since as soon as you click the field, then the date correctly displays. That's probably the one thing that throws me the most. Add to that the fact that it did work in the first several months of usage.

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

    Re: Date() vs. Now() (Access97)

    You may have a corrupt form at this remote site. Try creating a new form and copy all the controls to the new form except the control in question and see what happens. Databases can corrupt.
    Could someone have fiddled with it?
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Lounger
    Join Date
    Dec 2002
    Location
    Hutchinson, Kansas, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date() vs. Now() (Access97)

    Databases being used at remote sites by novices. What ever in the world makes you think someone might have fiddled with it. lol.

    Thanks for the reply.

Posting Permissions

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