473,320 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access Report Page Header problem

Hi all,

Does anyone know how I can have a Page Header, but have something
between that and the detail of the report???

ie..

Page Header

Once off piece of text (for the first page only)

Detail...

---NEXT PAGE--

Page Header

Detail...
Regards,

Scott

May 16 '06 #1
4 1781
Hi

I would suggest the following:

As a part of the pager header, put a text box control, the data source
for which is
=IIf([Page]=1,"Your one-off text","")

In this way, although the text box will be a part of every page header,
if it's not page 1, the text box will be empty and thus not visible.

Hope this helps!
Andrew

May 16 '06 #2
On 15 May 2006 23:20:42 -0700, sc*******@colonialfirststate.com.au
wrote:
Hi all,

Does anyone know how I can have a Page Header, but have something
between that and the detail of the report???

ie..

Page Header

Once off piece of text (for the first page only)

Detail...

---NEXT PAGE--

Page Header

Detail...

Regards,

Scott


Include the text in the page header.
Code the Page Header Format event:
[ControlWithTextName].Visible = Me.[Page] = 1
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
May 16 '06 #3
sc*******@colonialfirststate.com.au wrote in
news:11**********************@v46g2000cwv.googlegr oups.com:
Hi all,

Does anyone know how I can have a Page Header, but have
something between that and the detail of the report???

ie..

Page Header

Once off piece of text (for the first page only)

Detail...

---NEXT PAGE--

Page Header

Detail...
Regards,

Scott


Others have given working suggestions. Another way is to create
a group header. Set the group to a constant. It will only appear
once.

--
Bob Quintal

PA is y I've altered my email address.
May 16 '06 #4
Thanks for all your help everyone. Extremely helpful.

Cheers,

Scott

May 17 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
4
by: Richard Sherratt | last post by:
I've got a TextBox in a page header that I'm using to print a variable report header field that reflects the parameters selected for the report. I'm using a TextBox rather than a Label so that I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
4
by: Trevor Best | last post by:
I have a report that's fairly simple, page headers and footers, detail has a subreport in (can vary in length). The customer wanted a signature block for them, their client and 3rd party. This was...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
7
by: manning_news | last post by:
I've got a report that's not sorting correctly. I build a SQL statement and assign it to the recordsource in the Open event, sorting the data the way the user chooses. The user can choose up to 3...
3
by: touf | last post by:
hi, 1- I've a report (Crystal reports) created from a vb Form (crystalReportsViewer) How can I send it via email , In crystal report there is the possibility to export, but I didn't find a way to...
1
by: siomay87 | last post by:
please help i have a problem in the ms access reporting, my report have: page header, detail, page footer and report footer In listing "detail section", the number of line is depend on the data...
2
by: Simon | last post by:
Dear reader, In case a report is a sub report the Report Header of the sub report is printed in the report but the Page Header of the sub report will not be printed. This is the same for...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.