Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Field (2000)

    Is there a way to type just the day, and the current month and year automatically get filled in?
    I am using the short date format.
    Thanks

  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 Field (2000)

    How would Access be able to tell what you wanted? You might be better off using a calendar control of some kind to allow them to click a date.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Nov 2002
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Field (2000)

    Microsoft Money and Quicken have this feature. I thought that perhaps there was a way to do it in Access as well
    Thanks

  4. #4
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Field (2000)

    Ctrl + :
    will insert today's date
    Ctrl + ;
    Inserts the current time
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

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

    Re: Date Field (2000)

    If that behavior exists in those apps, it was *built* into their interface. If you want to do the same thing in Access, you have to build it as well. Keep in mind that Money and Quicken are bookkeeping programs, so their functionality is focused in a particular direction. Access allows you to build pretty much any kind of database application you need, so it can't make the same assumptions that Quicken and Money can. Plus, it doesn't use the same kinds of controls. There are shortcuts, like the ones posted in this thread that can be used to enter the current date, but if you want to enter a specific date using only the day, it would be far more complicated.
    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
  •