Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Stamp (A2K)

    Good Morning,
    I know this should be simple, but for now, it's not. I've tried everything. The main table has a field of PrecertDate. The form has the same field. Both of which hold the SHORTDATE format. In the AfterUpdate event of MaidNum I have code to automatically put the PrecertDate (which is the current Date) with the following: Me.PrecertDate=Now(). All works except the date includes the TIME. I only want the DATE. What on earth am I missing. Haven't played in Access in a while and my memory is failing. Have searched and searched to no avail.

    Thanks.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Stamp (A2K)

    Use the Date() function instead of Now(). Now() always includes the time component.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Stamp (A2K)

    Charlotte,

    Thanks for the suggestion.....I've tried that also. However, when I do that, the field txtDate doesn't update.....I'm stumped. If I put NOW() it updates w/Date and Time.....if I put DATE() it won't update anything.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Stamp (A2K)

    In your original post, you referred to Precertdate. Where does txtDate come in? If Date() isn't working, you have a larger problem.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Stamp (A2K)

    Thanks Charlotte....
    Yes original post was PrecertDate....since my post, in an attempt to try anything, something, I changed the field name to txtDate. Sorry .... txtDate was on the brain.

    So ... I have big problems! Should I consider re-installing Access?
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Date Stamp (A2K)

    You may simply have a reference or dll problem. Check your references to see if any of them are broken or missing. Date() happens to be one of the functions that acts as an early warning of that problem. If your references don't show any breakage, try reregistering the DAO dll using regsvr32.exe. There are still the standard techniques of creating a new database and importing all the objects from the one with problems and of trying Detect and Repair from the Help menu before you consider giving up and reinstalling.
    Charlotte

Posting Permissions

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