X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Two Month Per Page Calendar; Vertical Display, Access 2016    
post Feb 13 2020, 09:20 AM

Posts: 1
Joined: 13-February 20

Hello There. Long time Access user here. I consider myself somewhat advanced. But I would like some guidance for creating a report for birthdays/anniversaries in a format that is NOT the typical one-month-per-page grid format. I would like two months per page, vertical, with the date going down the middle. I have attached a screen shot of my ultimate goal. Here's a simplified text version. Dashes are only for spacing.
January------------ February
Person1 (1999) 1
------------------ 2
------------------ 3 Person2 (1958)
Person3 (2012) 4
------------------ 5 Person4 (1940)
------------------ 6
and so on.
An example is found online here:

I am not worried about graphics or color; I can do that part.
I have searched this forum for other calendar help and they are all for the one month grid type calendar. frown.gif

Would I use two subreports? One for even months and one for odd? I'm not sure how to handle the months having different dates, like January having 31 days and February only having 28 or 29.

We have a very large extended family and I'd like to produce this to share with everyone. I'd like to be able to maintain it going into the future when new family members are added. I'll add a "show" check box so I can filter out certain family groups as needed. It's gonna be great! If I can ever figure out the report.....

Thanks in Advance. I am glad to have found this helpful forum.

Attached File(s)
Attached File  TwoPageCalendar.png ( 35.97K )Number of downloads: 4
Go to the top of the page
post Feb 13 2020, 10:53 AM

UA Admin
Posts: 36,747
Joined: 20-June 02
From: Newcastle, WA

Welcome to UtterAccess.

I suspect two subreports would be the least complex to implement.
This post has been edited by GroverParkGeorge: Feb 13 2020, 10:56 AM

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
post Feb 13 2020, 10:55 AM

UA Admin
Posts: 36,747
Joined: 20-June 02
From: Newcastle, WA

On a different note, having tried for years to do something similar for my family, I have to wish you good luck getting everyone to take it seriously. For some reason, people tend to follow their own path for such things. wink.gif

My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
Peter Hibbs
post Feb 14 2020, 04:44 AM

UtterAccess VIP
Posts: 1,766
Joined: 17-June 10
From: Dorset. UK.

Hi weeblesue,

How are you getting on with your project, have you done any more since your first post?

There a few different ways of doing this but it depends a bit on your table design. Do you already have a table with a list of birth dates and names and if so, what fields do you have in it?

What do you want to see on the report if there are, say, three (or more) birthdays on the same date? Do you want to expand the row to two rows for that date (Can Grow) or do you want to keep them on the same row and truncate the last date/s?

You are showing the year of the birth in your examples but I would suggest showing the age on that date instead as this takes up slightly less room is normally what people want to know.

What I would do is I would create a temporary table which is bound to the report and then just fill the table with the relevant names on the relevant dates using some code. I think this would be easy enough to do and would give you a bit more flexibility with the layout.

Anyway, let us know how you are getting on and if you still need any assistance.

Peter Hibbs.
Go to the top of the page
post Feb 14 2020, 12:36 PM

UA Moderator
Posts: 77,485
Joined: 19-June 07
From: SunnySandyEggo

Hi Sue. Welcome to UtterAccess! welcome2UA.gif

I hope you're getting along well with your project. I was just curious why you selected this particular layout. It seems like you're trying to compare two months side-by-side rather than just simply displaying what's happening in each month. Cheers!

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Yesterday, 10:22 PM

Posts: 123
Joined: 29-September 10
From: AZ

I would approach by:.

Put three listboxes on a form side by side.
Call them March, Dates, April for this example

Read your dates for the two months from Access into two separate string arrays dimensioned 1 to 31 (base 1)
Call the arrays arrMarch, arrApril.
If more than one person has the same birthday you will need to add a comma and then add the next person when filling the array at that index.

If no birthday for a given date, skip that array index.
Now read the arrays to the correct listbox and use .AddItem for the array string at that index.
If the array index is blank make .AddItem " ".

As you spin through the first array (or do both at the same time for speed) -- as each index is encountered -- use that index in the 2nd listbox .AddItem for your dates.
If you do NOT want a second listbox for dates, then you could you use a control array of shapes -- or -- better yet place a fillled rectangle with whatever color you want and then
center text (the date = the index) in that rectangle.

If you don't want to use listboxes, then just determine the client window height (scaleHeight) and width (scalewidth).
then loop the arrays in (First above) and as you loop also increment the CurrentY and then set and print the array values at the CurrentX for your three columns.
If a blank array value is encountered draw a line the width of the CurrentX designated month column. As with above, I'd use a color rectangle and place the date within.

encountered than draw a line.
This post has been edited by dw85745: Yesterday, 10:40 PM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    18th February 2020 - 01:06 AM