Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Colorado state
    Posts
    65

    Cool Unanswered: calendar control

    Hi I am trying to make my calendar more interactive. If I select a date and push a button, say "On this day in history" button, whatever I had put in the database would come up ie a particular birthday. How do I set this up?


    Thanks,
    Mike

  2. #2
    Join Date
    Jul 2003
    Posts
    81

    Thumbs up Calendar Information

    My idea is to create a form where you will enter your memos or alarms. Then use the calendar to open this form filtered by the date you have picked.

    I haven't tried it but I think it will work.

  3. #3
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Calendar control

    There are several approaches to this, One is to use global variables. Set up a module with a function and a sub:

    Private myDate as date

    Public sub set_ThisDate(dateIN as date)
    myDate =DateIn
    End sub

    Public Function get_ThisDate() as date
    get_ThisDate=myDate
    end function

    Call the function from the form with the calendar control.
    Next open the form report based on a query, in turn based on your table.
    On line in your query should run on hte lines of:

    Where TableDate=get_ThisDate()


  4. #4
    Join Date
    Feb 2004
    Location
    Colorado state
    Posts
    65
    Thanks I will give these a try.

    Mike

Posting Permissions

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