Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-23-2004, 11:06 AM   #1
stillkarenann
Guest
 
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
statsman
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
stillkarenann
Guest
 
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
stillkarenann
Guest
 
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
greaseman
Closer to seniority!
 
greaseman's Avatar
 
Join Date: Jan 2003
Location: Somewhere...out there...
Posts: 360
Thanks: 0
Thanked 0 Times in 0 Posts
greaseman
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
Reply

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
General
Tables
Queries
Forms
Reports
Macros
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