Calendar in Access?

[julene67]

I work for a small pest control company and our database is currently on a
program called Act. The program is outdated and I would like to move our
entire database to Access 2007. However, with Act, we are able to print out a
monthly schedule for our technicians with who needs to be serviced.

Does anyone know if Access has any way of putting some of the information
from the database into a monthly calendar formula? Or is there a way to
incorporate the information needed into the calendar in Outlook? Any advice
will be greatly appreciated!

 

[James A. Fortune]

I work for a small pest control company and our database is currently on a
program called Act. The program is outdated and I would like to move our
entire database to Access 2007. However, with Act, we are able to print out a
monthly schedule for our technicians with who needs to be serviced.

Does anyone know if Access has any way of putting some of the information
from the database into a monthly calendar formula? Or is there a way to
incorporate the information needed into the calendar in Outlook? Any advice
will be greatly appreciated!

See:

http://groups.google.com/group/comp.databases.ms-access/msg/1b176f58cab46186

That might fit your needs. I haven't looked at it in a while. I
probably need to update the holiday functions. It prints a calender out
to a pdf file, one month per page. Up to five lines per date can be
specified and long lines shrink to fit. Access is also capable of
interacting with the calendar in Outlook but I don't remember the
details of how to do that. That should be easy to Google in this NG or
in comp.databases.ms-access.

James A. Fortune
(e-mail address removed)

 

[Larry Linson]

Does anyone know if Access has any way of putting
some of the information from the database into a monthly
calendar formula? Or is there a way to incorporate the
information needed into the calendar in Outlook?

There are a number of Access calendar examples available:

MVP Albert Kallal's site has instructions at
http://www.kallal.ca/ridestutorialp/setdriver.htm

MVP Tony Toews' site has examples at
http://www.granite.ab.ca/access/calendars.htm

MVP Duane Hookum has a number of examples at
http://www.access.hookom.net/Samples.htm.

You may find some other useful links, though they aren't specifically to
calendar information, in the Resources list at
http://sp.ntpcug.org/accesssig/default.aspx. That is the SharePoint Site I
maintain for my North Texas PC User Group's Microsoft Access Special
Interest Group.

Larry Linson
Microsoft Office Access MVP

 

[Tony Toews [MVP]]

Does anyone know if Access has any way of putting some of the information
from the database into a monthly calendar formula? Or is there a way to
incorporate the information needed into the calendar in Outlook? Any advice
will be greatly appreciated!

To add to Larry's posting - Duane Hookum has an awesome and simple
calendar in a report. See the Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[julene67]

Thank you to all of your for your great ideas!

To add to Larry's posting - Duane Hookum has an awesome and simple
calendar in a report. See the Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[ryanalibrando]

Thank you to all of your for your great ideas!  







- Show quoted text -

Hello,

I'm also looking to print a calendar from an access database, and it
looks like the example at Duane Hookum's site is perfect, however, I
can't seem to figure out how to create the "WeekOf" field in the
rptAppointWeekly. It's shown as a text box field in the report, but I
can't find it in a query, table, or in the VB code. It seems like the
whole report is sorted by this field, so I'm in essence stuck here.
Has anyone looked at the example enough to possibly help me figure out
how to get that field in my report?

Thank you,
Ryan

 

[Tony Toews [MVP]]

I'm also looking to print a calendar from an access database, and it
looks like the example at Duane Hookum's site is perfect, however, I
can't seem to figure out how to create the "WeekOf" field in the
rptAppointWeekly. It's shown as a text box field in the report, but I
can't find it in a query, table, or in the VB code. It seems like the
whole report is sorted by this field, so I'm in essence stuck here.
Has anyone looked at the example enough to possibly help me figure out
how to get that field in my report?

I would suggest starting a new thread in the reports newsgroup/forum
with a better subject such as "Problem with Duane Hookum's report.'
You'll probably get an answer from Duane.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/