1.  How do I have the title of my report repeated on every page besides 
the first page?

2.  Is it possible to add border lines on the report to separator 
different records?


Your help is my prayer!

Rick

1. It's called a page header.

2. Anything you place in the detail section will be repeated for each
record.  If you want anything more advanced than that then there are code
extracts on the web that you can download to help.  A quick search on google
for 'printlines' should return a link to some code at www.lebans.com.

Cheers,
Andrew 

-----Original Message-----
From: LoonieVIsa@h... [mailto:LoonieVIsa@h...]
Sent: Wednesday, 21 August 2002 4:54 PM
To: Access
Subject: [access] FORMAT OF REPORT


1.  How do I have the title of my report repeated on every page besides 
the first page?

2.  Is it possible to add border lines on the report to separator 
different records?


Your help is my prayer!

Rick

In addition to the previous comments:

1. To make the page header not show up on the first page, go to the report's properties. In 
the "Format" tab, go to "Page Header" and make it "Not with Rpt Hdr" (You'll need to make 
sure you have a report header for this - which is what I assume your front page will be on)

2. Code isn't necessary to add border lines on the report to separate different records. Just 
put a line at the top or the bottom of the Detail section. As the detail section is repeated for 
each record, so too, will the line.

and by the way Rick, I replied to that email you sent me, but it failed. Possibly because I 
attached your database to it with the necessary corrections. I'll upload it somewhere so you 
can get it. :)

Steven

I assume that you have the wizard create most of your reports.  Do the
following in Report Design mode.

1. Move the title information from the Report Header section to the 
Page
Header section.
2. Yes, Make the Detail section a little taller, so that there is room 
for a
line.  Then use the line draw icon to create a line under the text 
boxes.

With a little practice you can do both operations in less than half a
minute.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: LoonieVIsa@h... [mailto:LoonieVIsa@h...]
Sent: Wednesday, August 21, 2002 2:24 AM
To: Access
Subject: [access] FORMAT OF REPORT

1.  How do I have the title of my report repeated on every page besides
the first page?

2.  Is it possible to add border lines on the report to separator
different records?


Your help is my prayer!

Rick

Hi Loonie,

Q)  How do I have the title of my report repeated on every page besides the first page?

A)  Set report header items in the Page Header section instead of Report Header section.

====================================================================

Q)  Is it possible to add border lines on the report to separate different records?

A) Add border lines using line or rectangle tool to seperate individual records in Detail section.  Draw a line below you fields in
detail section if you want a line seperating records or a rectangle around all the fields in detail section if you want a boxed
look.

Hope that helps.


____________________________________________________

John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________

The doors we open and close each day decide the lives we live
____________________________________________________

CONFIDENTIALITY & PRIVILEGE NOTICE
The information contained in this email message is intended for the named addressee only.  If you are not the intended recipient you
must not copy, distribute, take any action reliant on, or disclose any details of the information in this email to any other person
or organisation.  If you have received this email in error please notify us immediately.

>>> LoonieVIsa@h... 21/08/2002 17:24:18 >>>
1.  How do I have the title of my report repeated on every page besides 
the first page?

2.  Is it possible to add border lines on the report to separator 
different records?


Your help is my prayer!

Rick