How can I make use of calendar function in a scheduling DB

[Clay]

Hello everyone,

I am in the process of building a database in Access 2000
which I plan to use to store info about our client's and
their sites. I also want to use this database to schedule
onetime and recurring maintenance activities for each
client or site and have a history of these activities
stored within the DB. Is there a way to use a calendar
like the one in Outlook to select recurring or onetime
activities based on the day, month, etc for each site? If
so, what is the best way to accomplished this?

Any help or suggestions that you might have would be
greatly appreciated.

Thanks,
Clay

 

[Jim/Chris]

Here is a url with some databases used for scheduling.
Maybe one will give you some ideas.
http://office.microsoft.com/search/...resource+schedule&CTT=6&Origin=EC010331121033

Jim

 

[Clay]

Thanks Jim! I'll take a look at this.

-----Original Message-----
Here is a url with some databases used for scheduling.
Maybe one will give you some ideas.
http://office.microsoft.com/search/results.aspx? Scope=TC&Query=resource+schedule&CTT=6&Origin=EC01033112103
3
.

 

[Tony Toews]

I am in the process of building a database in Access 2000
which I plan to use to store info about our client's and
their sites. I also want to use this database to schedule
onetime and recurring maintenance activities for each
client or site and have a history of these activities
stored within the DB. Is there a way to use a calendar
like the one in Outlook to select recurring or onetime
activities based on the day, month, etc for each site? If
so, what is the best way to accomplished this?

Below is my standard blurb on calendars. However this doesn't answer
the question about recurring activities based on day, month, etc. I
don't know of any such specific calendars. You may need to code this
yourself.

Tony

See the Calendar Tips page at my website.

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

Some alternatives are:
MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL.
There are several downloadable calendar forms at the Links page
at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Henro]

Been looking for a page like this a long time!

Thnx!

Henro

 

[Guest]

-----Original Message-----


Below is my standard blurb on calendars. However this doesn't answer
the question about recurring activities based on day, month, etc. I
don't know of any such specific calendars. You may need to code this
yourself.

Tony

See the Calendar Tips page at my website.

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

Some alternatives are:
MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL.
There are several downloadable calendar forms at the Links page
at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
.

Thanks Tony! I'll give this a try.

Clay

 

[Tony Toews]

Been looking for a page like this a long time!

Thnx!

You're quite welcome.

Hmm, yeah, I should add Microsoft Access, at least, to the title of
the page so it will show up better on the search engines.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm