ms+access+course/ - PRINTING REPORTS

The UK's most regular instructor-led training courses.
Training information: ms+access+course/ · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

PRINTING REPORTS

Stephen has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Stephen [4 posts] (2008 Jan 23 Wed, 16:26) Reply

How do you adjust the starting point on subsiquent pages (page 2....) on a report.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: PRINTING REPORTS

by - trainer Carlos gold contributer [473 posts] (2008 Jan 28 Mon, 13:38) Edited on 2008 Jan 28 Mon, 13:39 Reply

Hi Stephen

I asked some colleagues and found there is no way to make the Page header on the second page different from the first.

If its very important, there are packages on the market dedicated to producing more proffesional looking reports.

Although we do't support it Crystal Reports is the market leader.

Hope this helps.

Carlos

RE: PRINTING REPORTS

by - delegate Stephen [4 posts] (2008 Jan 28 Mon, 14:14) Reply

Hi Carlos,

I did suggest altering the Margins in Print setup and it seems to work.

All the best
Steve

· Why a Microsoft Access Course Could Change the Way You Do Business
· Microsoft Access: Unleash the True Potential Today
· Three Myths About Microsoft Access
· Tips for designing databases in Microsoft Access
· Microsoft Access Beginners' Training: Getting to Grips with Databases

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips