Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Rochester, Kent, United Kingdom
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calendar Controll (Access 97)

    I'm trying to add a calendar controll to a form. What I want it to do is when I click on the calendar the form displays donations for that date. I have a query to show donation for a specific date. I just need to tie the two together....

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

    Re: Calendar Controll (Access 97)

    Calendar controls aren't like normal Access controls. They are ActiveX controls, so think of them as separate forms. What you'll need to do is put code into the events associated with the calendar control itself to insert its value into an unbound textbox on your form. Then reference that textbox in the criteria of your query. Does that help?
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2002
    Location
    Rochester, Kent, United Kingdom
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar Controll (Access 97)

    Thanks Charlotte.... I'll have a play

  4. #4
    Gold Lounger Rebel's Avatar
    Join Date
    Jul 2001
    Location
    Canada
    Posts
    3,024
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Controll (Access 97)

    Charlotte's method will certainly work. Another method is to select the date on the Calendar Control, leave the calendar form open (or set the form's visible property to false if it is a pop up form), and add the following date criteria in the query which displays the information on the donations form - " =[Forms]![FormName]![Calendar].[Value] " (without the quotes of course). This assumes that you have named the ActiveX Calendar Control as "Calendar". Then when you close the "donations" form, also close the "calendar" form.
    John
    A Child's Mind, Once Stretched by Imagination...
    Never Regains Its Original Dimensions

Posting Permissions

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