Hi Mike,
In it's simplest form, it's not too tough:
1.) Create an unbound form called "frmAppointments"
2.) Add an ActiveX calendar control named "MyCal", and a subform called
"sbfAppointments" which is bound to "tblAppointments"
3.) Set the LinkMaster to "MyCal " and the LinkChild to "ApptDate"
4.) Add some code to set the date to today's date when the form loads.
5.) Tools / Startup ... Display Form: "frmAppointments"
Option Compare Database
Option Explicit
Private Sub Form_Load()
Me.MyCal = Date
End Sub
Private Sub MyCal_AfterUpdate()
Me.sbfAppointments.Requery
End Sub
Now as soon as you open your database, all appointments for today are
displayed in the subform.
New appointments can also be added for the date selected, using the same
subform.
IF the subform was a lttle too small to "get all the details", you could do
something like double-click on the "ApptID" field in the subform and have a
new full-sized form called "frmAppointmentDetails" open to the same record.
(Just an idea.)
--
HTH,
Don
=============================
Use
My*****@Telus.Net for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)
I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.
Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop
================================
"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m17.aol.com...
Mike,
Thank you for your reply. I'm trying to use the Calendar control to create
a date book in access to schedule future events, with dates only. I'm trying
to find some tips or code on how to do this.
I know the calendar control is just for date input, so how do I create a
form, on the fly to store date events or do I check to see if that date is
already there, so I don't have more than one date floating around for events?
Michael
