Access 2000

[Lorne]

In a nutshell; what I want to accomplish is:
- Add an Active X Calendar control to my database that will enable me
to access data for a particular date by clicking on the date block on
the calendar I select.
- Be able to link this feature to a number of tables/forms/reports.

Be kind, I am somewhat of a novice!

 

[Ragnar Midtskogen]

Just add the MSCalendar ActiveX control to your form. then you can retrieve
the date as follows
You will find it on the Toolbar in form design, click on the crossed hammer
symbol,(More Controls) you will need to move down the list of controls until
you find it

Private Sub MyCalendar_Click()

Dim dteMyDate As Date
dteMyDate = MyCalendar.Value
End Sub

Once you have it on your form you can use the View/Object Browser to look at
the properties and methods.
If you highlight a property or method then hit F1 you will open Access Help
on that item.
You can also search the Web with Google and find tons of info.

Ragnar