Microsoft Access Calendar scheduling

[amber_brittain]

Okay, we are working on a DB for a friend of ours that owns a massage
business and we are trying to automate her. Right now the DB is almost
done but one thing that we want to add is a calendar and what we need
the calendar to do is when she clicks on a certain date it shows all
the appts. made for that day. That way when people call in she can
easily see what is already scheduled for that day. The friend that is
using this is not very computer savy so we have to make everything
easy, but as far as the programming goes we are doing that.

We are close to getting it but we are not quite there. Right now we
have it to where when you click on the calendar and hit enter it will
cause a macro to run that will pull a qry up that pulls all clients and
the dates, but what we need it to do is, when we click on a certain
date it will pull up a form that lists all the appts for that day.

Also, I found this great website that has a calendar feature that is
close to what we are looking for but we don't want to spend $80 on it,
so if anybody has any idea on how to get the following i would also
appreciate that. http://www.aislebyaisle.com/access/calendartool.htm

Sorry this seems to be rambling but I wanted to give as much info as
possible.

Thanks for any help in this matter.

 

[Albert D. Kallal]

Interesting, but many a restaurant and hair cut places actually use outlook.
It has a great calendar view, and also have a nice "daily" view.

As for building a calendar, you can actually build a nice one in an
afternoon. If you look at the screen shots here, this was my case.

http://www.kallal.ca/ridestutorialp/setdriver.htm

Further, the calendar is actually a sub-form, and thus I don't need to
modify the code for each new appcation I write.

Unfortunately, I don't have a download (yet) for that calendar I built.
However, it not hard, (each "square" for text in my case is actually another
sub-form).

However, if you don't want to spend an afternoon writing your own calendar,
there is a number of examples here:

http://www.granite.ab.ca/access/calendars.htm

Several of the above examples are outook type calendars, and are ready to be
used and modified by you.....