Creating a Calendar

[CompGeek78]

Hey all. I am fairly proficient in Access, but I need some thoughts or
ideas from other people on ways that I could create a calendar out of
an Access database. If you have ever used MS Project, I'm looking to
create something similar to the calendar reports that you can create
there.

It will be used to print out a calendar schedule for a training
center. I already have the tables and queries structured, I just can't
figure out a way to get it to take the start and end dates for a class
and display that in a calendar format.

If you have any ideas, have done this before or know of any good
online examples, please feel free to share.

 

[Klein-4]

Hey all. I am fairly proficient in Access, but I need some thoughts or
ideas from other people on ways that I could create a calendar out of
an Access database. If you have ever used MS Project, I'm looking to
create something similar to the calendar reports that you can create
there.

It will be used to print out a calendar schedule for a training
center. I already have the tables and queries structured, I just can't
figure out a way to get it to take the start and end dates for a class
and display that in a calendar format.

If you have any ideas, have done this before or know of any good
online examples, please feel free to share.

Have you tried using the Calendar control...?

http://office.microsoft.com/en-us/access/HP011210601033.aspx
http://www.fontstuff.com/access/acctut09.htm

Ross La Haye

 

[CompGeek78]

Have you tried using the Calendar control...?

http://office.microsoft.com/en-us/a...xhttp://www.fontstuff.com/access/acctut09.htm

Ross La Haye

Yes, I've used it a dozen times and it doesn't even come close to what
I'm trying to do. The calendar control is used for choosing dates. I
don't need that, I want to print out our scedule on a calendar.

 

[Klein-4]

Yes, I've used it a dozen times and it doesn't even come close to what
I'm trying to do. The calendar control is used for choosing dates. I
don't need that, I want to print out our scedule on a calendar.- Hide quoted text -

- Show quoted text -

Take a look here -- http://www.access.hookom.net/Samples.htm. There
are a few databases with calendar-formatted reports that may be of
help.

Ross La Haye