[AccessD] Detail in calendar

Debbie delam at zyterra.com
Fri Sep 10 10:24:57 CDT 2010


I have a report in access 2007 that has a calendar that works nicely.  
My issue is when the tasks that fill my calendar fill more than a  
page. I am left with info at the top of the page and no date since the  
dates themseves are detail records.

I am trying to put a date on the top of this page with one of two  
methods, but I am running into issues.

1.  Put dates in the page header and only reveal them when the detail  
exceeds the page length.
A: I have gotten pretty far with this one, but cannot seem to get the  
visible property to fire in the right spot. My code seems to be firing  
on the right pages, but not producing the correct results. Page 1  
always has the extra dates when it should never have them and  
subsequent pages never have the dates even when I tell it if me.page =  
one page after a long detail is detected. I can see that the code  
fires, but no extra date is visible.

2.  Make the top row of dates invisible and leave the page header  
dates visible all the time.
A:  I have not figured out how to find out if the date is printing on  
that first line.

Any ides on the stopping points for either of these ideas, or totally  
new solutions are appreciated.

Debbie

Sent from my iPhone



More information about the AccessD mailing list