[AccessD] Report Page Header

The condition where detail records may not exist on the last page of a
report occurs because I have included a sub report in the report footer
which may or may not fit in the available space left over after the details
have completed printing.


Mark
...yikes, seems like a run-on sentence, but also appears to be grammatically
correct? :)


-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Monday, April 19, 2004 5:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Report Page Header


Mark:

Do you mean no data for the whole report?  If so you can use the No Data
event and issue a DoCmd.CancelEvent command.  That will cancel the whole
report.  Mostly I then have to trap the error 2105 in the calling form.

But what condition would give you  on some detail records on some pages and
not others?

Rocky

----- Original Message ----- 
From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com>
To: "'[AccessD]'" <AccessD at databaseadvisors.com>
Sent: Monday, April 19, 2004 1:10 PM
Subject: [AccessD] Report Page Header


> First, a really stupid question...why is it that Access reports do not
have
> a "Detail Header" section?  It seems simple and to the point for a lot of
> what I do when grouping is not needed.
>
>
> Second, when printing a report, what is the syntax to check if there are
no
> detail records on the page and suppress the Page Header if there are none?
>
>
>
> Mark
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com