all I need now is a search form, with a date field and a calendar,
that I can enter the search date (the search parameter) into by
selecting the date from the calendar.
If you send me a private e-mail message, with a valid reply address, I can
send you a couple of sample databases that you might find helpful.
and show a list of appointments for each family member (in
seperate columns) for that day (which can be edited as required),...
This would likely require a non-normalized spreadsheet type design. With a
properly normalized database, you could display the results using a crosstab
query, however, a crosstab query is not editable. I suppose you can get away
with a non-normalized design for a small family appointment database.
Outlook is for a single user....
Perhaps this statement is true when Outlook is installed in a home office .
When used in a corporate environment, with Exchange server, Outlook can
certainly accomodate a group calendar.
Tom
QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
Hi Tom,
I am constructing a relatively simple Appointment book in MS
Access 2000, for my families use. It mostly done, all I need now is a search
form, with a date field and a calendar, that I can enter the search date (the
search parameter) into by selecting the date from the calendar. I have
constructed this form but do not know how to write toe code to do the
following.
The search will do one of 2 things -
1. it will open an existing form for the selected date (with the date as the
form heading) and show a list of appointments for each family member (in
seperaate columns) for that day (which can be edited as required), or
2. if the page with the selected date does not exist, then creatd it by
going to a new record/form and inserting the date.
MS Outlook does what I want except I want each form to show all of the
apppointments for each family member (5 columns of appointments) on one page.
Outlook is for a single user, so it is not what I need.
Hope this gives you some insite as to what I am after. Thanls for your reply.
Regards,
gr8852
__________________________________________
:
My advice is to stay away from the ActiveX based calendar. It is not always
so reliable. Try Allen Browne's calendar form instead:
http://allenbrowne.com/ser-51.html
Without knowing more about your database structure, we can't offer too much
on the second part of your question to search for a record with the selected
date.
If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
How can I use an ActiveX Calendar to enter a date into a Date Field on a
form, to search for a record with the selected date. If no record exists,
then create a new record, and enter the selected date into the Date field?
gr8852
