Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2005

Tip: Looking for answers? Try searching our database.

2nd page on Report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lamar - 02 Mar 2005 20:19 GMT
Get me started in the right direction.  In my report I have a page header
with certain information.  But on the 2 page I want to keep some page header
info but not other information.

Using VB can I somehow have certain information show on 1st page but not in
the following page in the page header section.

I can use the report header.  Thank you.
fredg - 02 Mar 2005 21:28 GMT
> Get me started in the right direction.  In my report I have a page header
> with certain information.  But on the 2 page I want to keep some page header
[quoted text clipped - 4 lines]
>
> I can use the report header.  Thank you.

Several ways to do this.
1) Place all your Page Header controls in the Page Header.
Code the Page Header Format event:
[ControlA].Visible = Me.[Page] >1
[ControlB].Visible = Me.[Page] = 1
etc.
or...
2) Place the controls you wish to display on the first page in the
Report Header. Place only the controls you want to show on the second
and later pages in the Page Header.
Set the Report's PageHeader property to "Not with Rpt Hdr".
It's on the Report property sheet's Format tab.
The Page header will not show on page 1, but will on succeeding pages.
Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Matt - 02 Mar 2005 22:53 GMT
I agree with fredg if you what more control over what the reports dose go
with solution 1 it is good practise to use code to edit such information as
you can do nice tricks like pulling other data out of the database to be
displayed as part of the headers.

> > Get me started in the right direction.  In my report I have a page header
> > with certain information.  But on the 2 page I want to keep some page header
[quoted text clipped - 18 lines]
> It's on the Report property sheet's Format tab.
> The Page header will not show on page 1, but will on succeeding pages.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.