Hi,
Ok then ... Using the analogy of the paper calendar that hangs in the
kitchen, the one that everyone scribbles their up-coming events on... is
that what you're talking about? If so, I don't know of any way to enter the
data directly into an Access "calendar type form" ... especially not
multiple entries.
I was quite serious about suggesting the use of a PIM.
The "monthy view" of the Outlook calendar displays a frame for each day.
Several events (5) will fit into the frame directly. Let's say that I typed
in "Don's Birthday" into one of the 5 event containers. Double-clicking on
that displays a window that has a large memo area that could contain the
detailed plan for that event. The Outlook calendar has a few other "bonus"
features, such as reminders and recurring events.If all of this this really
is not sufficient, then perhaps someone who knows more about integration
between Outlook and Access than I do could suggest something that may
satisfy your requirements???
Barring that, or if you insist on using Access only ... I do think that you
might be able to do something "workable" using 2 related tables and a
mainform/subform approach..
"tblAppointmentDates"
DateID - AutoNumber - PK
ApptDate - Date - Default Value = Date(), perhaps?
.... other fields
"tblAppointmentDetails"
ApptID -AutoNumber - PK
DateID - Long Integer - FK
ApptDate - Date
ApptMemo - Memo
.... other fields
Define a One-to-Many relationship between the 2 tables
Create the main form "frmAppointmentDates" (based on tblAppointmentDates)
Add the Calendar Control, and paste in my code posted previously.(You'll
have to modify the field names to match.)
Add a datasheet-style subform "sbfApptDetails" (based on
tblAppointmentDetails)
LinkMaster : DateID; ApptDate
LinkChild: DateID; ApptDate
It's best (IMHO) that you use datasheet-style for the subform, because you
want to be able to display as many Appointment records as possible.
You could create another single-record form also based on
tblAppointmentDetails "dlgAppointmentDetails" which would allow the user to
view all of the data in greater detail ... the memo field in particular.
This form could be "called" from the datasheet-style subform using
LinkCriteria, by say ... double-clicking in the ApptID field, like this:
**************************************
Private Sub ApptID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "dlgAppointmentDetails"
stLinkCriteria = "[ApptID]=" & Me![ApptID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
**************************************
When you get this done, you should be able to click on a date on the
calendar to set the date on the main form. You will then be able to enter
and/or view existing appointment details in the subform. The
LinkMaster/LinkChild links will force the entry for ApptDate automatically,
in new records, as soon as data is entered in any other field.
The user could then "preview" the appointment in "sbfApptDetails", double
click on the desired "ApptID", and finally view all of the details in
"dlgAppointmentDetails". A few more steps, granted, than the average PIM,
but as I said before ... "workable"???
Don
"Shyguy" <sh****@aol.com> wrote in message
news:ma********************************@4ax.com...
Hi,
No. Not a PIM. ;-) I am trying to write a database for a Non Profit
Group that performs at churches. The database keeps track of all the
information related to the group, and the churches. Some days can
have two performances and some only one. Actually, I have everything
pretty much worked out, but the user needs to see if anything is
scheduled for any day so as not to double book. We can print out a
schedule and check that when making new inputs, but I thought it would
be smoother if it could be done on a calendar type form.