Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 08-23-2004, 11:06 AM   #1
Posts: n/a
Access 2000 Calendar Report

Hi all - I'm pretty impressed with the group you have here and was hoping you could assist with my headache.

I have a database that contains a listing of seminars and dates.

The user will input the month/year and it should generate a report in a standard calendar type format (Sample Here).

I'm really at a loss after having done days of searching for something similar. Any ideas would be much appreciated.

Last edited by stillkarenann; 08-23-2004 at 11:07 AM. Reason: Realized I was being rude without a greeting...
  Reply With Quote
Old 08-23-2004, 05:56 PM   #2
Newly Registered User
statsman's Avatar
Join Date: Aug 2004
Location: Toronto ON
Posts: 2,076
Thanks: 4
Thanked 5 Times in 5 Posts
statsman will become famous soon enough
Access 2000 Calendar Report

So...what would you like to do. Your description of the problem was vague.
Would you like to print a report that looks like a calendar? If so, you are setting yourself a real hard task. You would have to create report templates that look like calendars but you would require a template for every possible combination (months starting on every day of the week, combined with months with 30, 31, 28 or 29 days).
Please give me more info to work with.
statsman is offline   Reply With Quote
Old 08-24-2004, 07:57 PM   #3
Posts: n/a
Maybe this will clarify (or not)....

I found a calendar at weAscend - http://www.weascend.com/Downloads.htm and mussed around to almost get what I needed... The particular file is CalendarLV.zip.

If you open it up and click on "Appointment Calendar (Who)". That pretty much what I'm looking for - the problem here is when you hit print preview. I've managed to get my sample to have decent sizing but I can get the day contents to print - empty field are bad chars and populated fields show "0".

With this in mind, would the opinion be that I mess around and try to get this one working or could there be another road.

There has *got* to be a better way... Cause this stinks.

Last edited by stillkarenann; 08-24-2004 at 07:58 PM. Reason: The filename would help....
  Reply With Quote
Old 08-29-2004, 12:39 PM   #4
Posts: n/a
Update: for anyone that finds this thread.

I spent over a week trying to figure this out and gather materials online. I tried making Reports, Forms and Pages. Also tried using the Outlook Calendar feature but it was pretty lackluster.

The conclusion: It was simply WAAAY more work than it is worth to create a printable/exportable monthly calendar formatted report, form or page in Access 2000.

Creating 42 ActiveX objects and pulling the content from the database was just crazy to tweak.

The client I was working with found it acceptable to, instead, create it in an Excel file using this Microsoft help file - XL2000: How to create a Monthly Calendar - and custom calls to the Access 2000 database.

Last edited by stillkarenann; 08-29-2004 at 12:41 PM. Reason: stupid typos
  Reply With Quote
Old 08-31-2004, 05:18 AM   #5
Closer to seniority!
greaseman's Avatar
Join Date: Jan 2003
Location: Somewhere...out there...
Posts: 360
Thanks: 0
Thanked 0 Times in 0 Posts
Don't know if this will help.......

Pat Hartman created a calendar style report, which is "fueld by several crosstab queries. If you do a search on this forum, using "calendar report" as your search criteria, it might be something you can use. I've played around with it a bit, and it's pretty good. In my case, I need to see more than one item per day which is what I'm working on.

In any case, give it a shot, and good luck!

"Wherever you go, there you are!"
greaseman is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

All times are GMT -8. The time now is 07:54 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World