Output Dates to a Calendar Style Report

[tbaguio]

Hi,

I currently run a database that has a "Meetings" table. I was wondering if anyone knew how to run a REPORT that would display these meetings in their respective dates. I need to show them in the traditional month by month calendar style to distribute to my users.

-----------------------
S M T W Th F Sa
-----------------------
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
-----------------------

Your help is greatly appreciated.

Theresa

"Sleep is the best meditation." - Dalai Lama

 

[SteveR77]

Here is one way to get what you are after.

1 - Create a report.

2 - Set the record source of the report to be the table or query that contains the dates you want to see on the calendar.

3. - Place a calendar control (Version 8) on your report and set it's control source to be the date field from the query or table.

4. - You may also want to place the field that holds the meeting details for the given date on the report as well.

5 - Preview the report. At this point you should have the calendar control showing all the meeting dates with a field displaying the associated details for the meeting in question.


HTH

Steve B-)

 

[tbaguio]

Thanks Steve for your feedback. I tested out your suggestion and unfortunately it does not give the solution I need (although I have a few other places I can use that idea!)

1) I need to be able to show a report that looks like a calendar that displays meeting information within the square of a specific date

2) If the meetings table has two separate records within the same month/day, each record would appear on the same calendar. eg. A meeting on March 1st would show in the March 1st square with relevent information like meeting location, and a meeting on March 2nd would show in the March 2nd square with its relevent information.

If you can figure this one out, I'm sure many other users would be thankful. I'm sure everyone has had a need for something similar.

Thanks again!

Theresa "Sleep is the best meditation." - Dalai Lama

 

[braindead2]

This will require quite a bit of tweaking but here goes
1 sort by date, header yes
2 place date field in the header section all the way to the left.
3 place the field that has the appointment in the detail section all the way to the left. Make the whole form so it is about 1.3 inch wide by 1.3 high
4. go to page setup
5. click on the page tab and make it landscape
6 now click on the column tab set the number of columns to 7
7. click on the layout so it goes across and then down
8 be sure the row spacing is set at 0
play with these settings till you get the look you want
you may also have to create a table that has all of the dates in it so all the dates will be included in the report.
Good Luck

 

[DougP]

See if this is what you are after.

http://www.barcodeone.com/nurse/nursescheduleprogram.htm

It required a lot of work to do though. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[MichaelRed]

DougP,

I do believe that it is what many have asked for, unfortunatly, it doesn't appear to be in VBA form/table/code for general use.

Nice ad though.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[tbaguio]

DougP,

That's exactly the format we're looking for. If you are not opposed to sharing how you did it, I would be one very happy camper.

I do have a question though... I see that you are able to display a record per date in that format. Will you be able to show multiple records per date? eg. More than one nurse on April 3rd?

Thanks again! "Sleep is the best meditation." - Dalai Lama