Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: Guidance on the Calendar Control

    Can someone please show some code to show me how to get started on this? I haven't the slightest idea where to start. HELP!!!!!!!!!!

    I am trying to (based on the date) show all invoices that are due that day.

  2. #2
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Here's a small example for you.

    Here are basically the steps:

    1. Create the 'calendar form' (usually unbound, but not necessarily)
    2. Put in code to set 2 text boxes to start and end dates (see example db)...only 2 small line of code needed for this.
    3. Create a query for that uses the dates as criteria (see example)
    4. Use that query as the record source for reports/forms.

    Hope this get's you started.
    Attached Files Attached Files

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    is there any way of pulling information up just by clicking on the date?

  4. #4
    Join Date
    Dec 2004
    Posts
    277
    Nevermind... thanks for all the help i've gotten it

  5. #5
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Great, I was trying to fire off some events on clicking the calendar with no luck.
    If you got that to work, I'd be curious as to how.

    Thanks.

    Chris

  6. #6
    Join Date
    Dec 2004
    Posts
    277
    Private Sub Calendar6_Click()
    Me.Text49 = Me.Calendar6.Value
    DoCmd.OpenQuery "qryCalendarTest"
    End Sub

    the value of the calendar is the day that is pressed. You can create queries based on the value of it, enter information in text box for date....

    this is definitely coming in handy for what I am working with

  7. #7
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Thanks...good luck.

Posting Permissions

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