Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop Down Calendars (Access 2000)

    I have created a form which collects parameters to pass on to query. A couple of these are Start Date and End Date so the query only displays records which fall between those dates. It's working fine, but requires the user to type in the date - and if it's last year, they have to type the entire date e.g 1/10/04 (1st October for non English readers!)
    While this is not a big deal, it would be nice to offer a drop down calendar, like Outlook does when setting a recurring appointment.
    Is this possible in Access, please? I can't find anything in the help. There's one posting here which mentions 'DT picker' but I don't know what that is.
    Thanks
    Silverback
    Silverback

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop Down Calendars (Access 2000)

    Have a look at Forms: Mini Calendar at The Access Web
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop Down Calendars (Access 2000)

    Many thanks for replying to my posting. Actually, I have problems with that particular download - it fails to run on my PC and I haven't got to the bottom of why.
    However, I have obtained two very smart alternative calendars from Arvin Meyer, who is another of the experts at the Access Web.

    So thanks again for the lead.
    Silverback
    Silverback

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Drop Down Calendars (Access 2000)

    If you open the database holding the shift key, it will prevent to run the autoexec macro. Why this auotexec macro exist is a mistery for me.
    Francois

Posting Permissions

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