A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing Reports Access 2002 Pleas Advise



 
 
Thread Tools Display Modes
  #11  
Old October 5th, 2005, 12:17 AM
Dermot
external usenet poster
 
Posts: n/a
Default

Hi Tina,
I have had a break (Whole Day!) and have resolved my problem only 10 mins
ago....well with your first advice about dimensions.
The follow is a summary of previous postings...
Initially 3 reports were showing as 6 in print preview every alternate being
blank. Your Correct Solution
By setting paper A5 properties of width = 14.9cm and height to 21.0cm and
ensuring the report dimensions were within these measurements using the
rulers resolved the problem.

What I Forgot I'd Done Earlier
A Search for Surname "Brown" should have produced only 3 reports because I
only had 3 Brown records.
The fact that I was now showing 4 reports ( 3 + one blank) in print preview
was because I had overlooked having set my printer to "Duplex" Printing
because I wanted to print on both sides of the A5 sheet, hence the blank.
Swithing off Duplex then gave me 3 reports in print preview.

Your tips about "Report Section Back Colours" and "Control Borders" are well
recieved and appreciated, good idea thanks, I'll note this down.

Best Wishes
Dermot

"tina" wrote:

okay, i'll keep an eye on this thread for awhile. after sleeping on it,
here's something i've never tried - but it might help you out: in report
design view, click on each section of your report (including the ones that
you think are "closed up"), and change the BackColor, each section to a
different color. then look at the report in PrintPreview. hopefully the
"extra" page will show the color of the section that's "bleeding over". that
may at least give you a starting point of where to look for the problem.
another trick (i sometimes use this one) is to select all the controls on
the report (Ctrl+A) and change the BorderStyle from Transparent to Solid.
then look at the report in PrintPreview; again, you may see the outline of
the "problem" control on the extra page(s).

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks for yet another reply.
It's good of you to offer to look at it for me, but it's very basic. I

think
you have explained all well to me and that I have probably overlooked
something that you have already described. I will read over this topic

from
beginning to end and think a while more before landing you the task of
sorting it out for me.
I will let you know my error when I find out.
Thanks
Dermot

"tina" wrote:

well, i've never designed a report to print to A5 paper, but i wouldn't
think there'd be anything "special" about it. "x" size is "x" size,

after
all; you have to work within the space available on whatever paper media
you're printing to, whether it be 8.5 x 11 paper, an envelope, a sheet

of
stick-on labels, etc.

i can't think of anything else to suggest, Dermot. if your db is A97 or
newer, you can send me a copy (sans proprietary data) if you want, and

i'll
see if i can figure out how to fix the report - and then tell you how i

did
it. i'm not sure it will work, since you're outside the US - differences

in
our Access software, maybe? but i'm willing to give it a shot. if you

want
to go this route, post your email address, "disguised" to foil the

spammers,
and tell me how to "de-code" it; and i'll email you.

hth


"Dermot" wrote in message
...
Thanks again Tina,
I checked the "Object Combo Box" for a page break object but there is

none
listed.
As you said , I would have had to insert it manually (thanks for the

tip
didn't know this), so the page break isn't my problem now.

I have 4 reports showing, 3 + one blank......is there anything else I
should
consider or has everything that could cause it been covered?

What puzzles me is that the report looks fine, it's dimensions seem to

be
less than the paper (A5) dimensions, if I print one it looks the way I
want
it.....

Should I start the report from scratch?
What procedure would you followwhen desighing a if you wanted a

report to
print to A5?
Best wishes
Dermot
"tina" wrote:

when you put a page break in a report section, and leave space

"under"
the
page break, you can wind up with a blank page inserted between the
records
pages. AFAIK, you have to insert a page break manually; i don't

think
the
report wizard does it, but it's possible.

in your report design view, on the Formatting toolbar, take a look

at
the
Object droplist (should be on the extreme left side, showing as a

combo
box). click the arrow to drop the list and scroll through, looking

for a
control name that begins with "PageBreak".

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks again.
I have looked at everything you mentioned in your previous post

now.
A5 Paper is W=14.9cm H=21.0cm (in the UK).
I found what you meant about the margins and set them all to 0, I

now
find
I
have 4 reports showing 3 and a blank page when I go to print them.

The width property of my report in design view is 10.21cm, which I
would
have thought was well withing the paper dimensions and the Height

is
within
it's limits looking at the report design view rulers.

I have the side edge and bottom edge up tight against the controls

in
the
report and have the header and footer up against the detail

section as
I
am
not using them.....only using the detailsed section......could

this be
a
problem?

You mention page breaks before...can you explain in a little more
detail
the
relavance and how I check for them in a report?

Any other suggestions to help me resolve my problem would be
appreciated.



"tina" wrote:

well, a report is pretty much about physical space. your paper

is x
inches
or cm wide and y inches or cm long. a single page in report

design
view
cannot be wider than "x minus the total of the left and right
margins".
and
it cannot be longer than "y minus the total of the top and

bottom
margins" -
though, as i said before, finding height issues can be harder
because
you
only see one records' worth of controls in the Detail section

while
in
design view.

you mentioned looking at the Columns tab of the Page Setup

dialog.
is
the
Number of Columns set to 1, and Row Spacing set to 0 (zero)? or,

if
this
is
actually a multi-column report, don't forget that you have to
include
the
"Column Spacing times (the number of columns minus 1)" in your
calculation
of the report width.

as for the paper size, look at Page tab in the Page Setup

dialog.
you
should
be able to set your Paper Size to A5, from the droplist. if you

know
the
dimensions of A5 paper, then make sure your height/width
calculations
(see
previous paragraph) do not add up to more space than the
height/width of
A5
paper.

hth


"Dermot" wrote in message
...
Hi tina,
Thanks for the reply.
I have looked at your suggestions but still haven't resolved

my
problem.
File | Page setup | Column Tab |W= 12.998cm H=13.497cm

In report design view under the report properties all tab, I

can
only
find
a width property (12.998), there doesn't seem to ne a length
property!

Margins are......Top= 25.41, Bottom= 25.41, Left = 25.43,

Right=
25.41

I have dragged the report as small as I can height and width

to
accommodate
the controls I have on it, still no joy....3 record show as 6
every
alternate
being blank.

Is ther a way to design the report specifically for A5 paper.
I am not too sure I actually understand the relationship of

the
report
displayed on the screen and that printed......I thought it

didn't
matter
as
long as I selcted A% from the print setup screen.

Any further advise would be greatly appreciated.



"tina" wrote:

in the report's design view, check the width and length of

the
report
and
compare that with the margin settings under File | Page

Setup.
for
instance,
if the width of your report in design view is 7 inches, and

page
setup
shows
left and right margins of 1 inch each, you'll get one half

inch
slopping
over to a second page. if that half inch happens to be

blank,
you
won't
see
anything on the second page. the same issue may apply to the
top/bottom
margins - but that can be harder to determine if you have
several
detail
records on one page, because design view only shows the

width of
one
record.

also, if you're using a page break in a section, make sure

there
is
no
space
between the page break and the bottom of the section.

hth


"Dermot" wrote in message
...
I have created a..
Table of contacts tblcontacts.
Surname query qrySurname.
A report base on rptQuerySurname.
A macro to print a Selection mcrSelection.
When I search for a surname say "Brown" the report returns

say
3
records.
When I run the print macro the preview display 6 records,

each

  #12  
Old October 5th, 2005, 03:55 AM
tina
external usenet poster
 
Posts: n/a
Default

hurray, you got it fixed!

The fact that I was now showing 4 reports ( 3 + one blank) in print

preview
was because I had overlooked having set my printer to "Duplex" Printing
because I wanted to print on both sides of the A5 sheet, hence the blank.
Swithing off Duplex then gave me 3 reports in print preview.


well, i bet i'd have missed that, if i had reviewed your report design. so i
learned something today, too - thanks!


"Dermot" wrote in message
...
Hi Tina,
I have had a break (Whole Day!) and have resolved my problem only 10 mins
ago....well with your first advice about dimensions.
The follow is a summary of previous postings...
Initially 3 reports were showing as 6 in print preview every alternate

being
blank. Your Correct Solution
By setting paper A5 properties of width = 14.9cm and height to 21.0cm and
ensuring the report dimensions were within these measurements using the
rulers resolved the problem.

What I Forgot I'd Done Earlier
A Search for Surname "Brown" should have produced only 3 reports because I
only had 3 Brown records.
The fact that I was now showing 4 reports ( 3 + one blank) in print

preview
was because I had overlooked having set my printer to "Duplex" Printing
because I wanted to print on both sides of the A5 sheet, hence the blank.
Swithing off Duplex then gave me 3 reports in print preview.

Your tips about "Report Section Back Colours" and "Control Borders" are

well
recieved and appreciated, good idea thanks, I'll note this down.

Best Wishes
Dermot

"tina" wrote:

okay, i'll keep an eye on this thread for awhile. after sleeping on it,
here's something i've never tried - but it might help you out: in

report
design view, click on each section of your report (including the ones

that
you think are "closed up"), and change the BackColor, each section to a
different color. then look at the report in PrintPreview. hopefully the
"extra" page will show the color of the section that's "bleeding over".

that
may at least give you a starting point of where to look for the problem.
another trick (i sometimes use this one) is to select all the controls

on
the report (Ctrl+A) and change the BorderStyle from Transparent to

Solid.
then look at the report in PrintPreview; again, you may see the outline

of
the "problem" control on the extra page(s).

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks for yet another reply.
It's good of you to offer to look at it for me, but it's very basic. I

think
you have explained all well to me and that I have probably overlooked
something that you have already described. I will read over this topic

from
beginning to end and think a while more before landing you the task of
sorting it out for me.
I will let you know my error when I find out.
Thanks
Dermot

"tina" wrote:

well, i've never designed a report to print to A5 paper, but i

wouldn't
think there'd be anything "special" about it. "x" size is "x" size,

after
all; you have to work within the space available on whatever paper

media
you're printing to, whether it be 8.5 x 11 paper, an envelope, a

sheet
of
stick-on labels, etc.

i can't think of anything else to suggest, Dermot. if your db is A97

or
newer, you can send me a copy (sans proprietary data) if you want,

and
i'll
see if i can figure out how to fix the report - and then tell you

how i
did
it. i'm not sure it will work, since you're outside the US -

differences
in
our Access software, maybe? but i'm willing to give it a shot. if

you
want
to go this route, post your email address, "disguised" to foil the

spammers,
and tell me how to "de-code" it; and i'll email you.

hth


"Dermot" wrote in message
...
Thanks again Tina,
I checked the "Object Combo Box" for a page break object but there

is
none
listed.
As you said , I would have had to insert it manually (thanks for

the
tip
didn't know this), so the page break isn't my problem now.

I have 4 reports showing, 3 + one blank......is there anything

else I
should
consider or has everything that could cause it been covered?

What puzzles me is that the report looks fine, it's dimensions

seem to
be
less than the paper (A5) dimensions, if I print one it looks the

way I
want
it.....

Should I start the report from scratch?
What procedure would you followwhen desighing a if you wanted a

report to
print to A5?
Best wishes
Dermot
"tina" wrote:

when you put a page break in a report section, and leave space

"under"
the
page break, you can wind up with a blank page inserted between

the
records
pages. AFAIK, you have to insert a page break manually; i don't

think
the
report wizard does it, but it's possible.

in your report design view, on the Formatting toolbar, take a

look
at
the
Object droplist (should be on the extreme left side, showing as

a
combo
box). click the arrow to drop the list and scroll through,

looking
for a
control name that begins with "PageBreak".

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks again.
I have looked at everything you mentioned in your previous

post
now.
A5 Paper is W=14.9cm H=21.0cm (in the UK).
I found what you meant about the margins and set them all to

0, I
now
find
I
have 4 reports showing 3 and a blank page when I go to print

them.

The width property of my report in design view is 10.21cm,

which I
would
have thought was well withing the paper dimensions and the

Height
is
within
it's limits looking at the report design view rulers.

I have the side edge and bottom edge up tight against the

controls
in
the
report and have the header and footer up against the detail

section as
I
am
not using them.....only using the detailsed section......could

this be
a
problem?

You mention page breaks before...can you explain in a little

more
detail
the
relavance and how I check for them in a report?

Any other suggestions to help me resolve my problem would be
appreciated.



"tina" wrote:

well, a report is pretty much about physical space. your

paper
is x
inches
or cm wide and y inches or cm long. a single page in report

design
view
cannot be wider than "x minus the total of the left and

right
margins".
and
it cannot be longer than "y minus the total of the top and

bottom
margins" -
though, as i said before, finding height issues can be

harder
because
you
only see one records' worth of controls in the Detail

section
while
in
design view.

you mentioned looking at the Columns tab of the Page Setup

dialog.
is
the
Number of Columns set to 1, and Row Spacing set to 0 (zero)?

or,
if
this
is
actually a multi-column report, don't forget that you have

to
include
the
"Column Spacing times (the number of columns minus 1)" in

your
calculation
of the report width.

as for the paper size, look at Page tab in the Page Setup

dialog.
you
should
be able to set your Paper Size to A5, from the droplist. if

you
know
the
dimensions of A5 paper, then make sure your height/width
calculations
(see
previous paragraph) do not add up to more space than the
height/width of
A5
paper.

hth


"Dermot" wrote in message
...
Hi tina,
Thanks for the reply.
I have looked at your suggestions but still haven't

resolved
my
problem.
File | Page setup | Column Tab |W= 12.998cm H=13.497cm

In report design view under the report properties all tab,

I
can
only
find
a width property (12.998), there doesn't seem to ne a

length
property!

Margins are......Top= 25.41, Bottom= 25.41, Left = 25.43,

Right=
25.41

I have dragged the report as small as I can height and

width
to
accommodate
the controls I have on it, still no joy....3 record show

as 6
every
alternate
being blank.

Is ther a way to design the report specifically for A5

paper.
I am not too sure I actually understand the relationship

of
the
report
displayed on the screen and that printed......I thought it

didn't
matter
as
long as I selcted A% from the print setup screen.

Any further advise would be greatly appreciated.



"tina" wrote:

in the report's design view, check the width and length

of
the
report
and
compare that with the margin settings under File | Page

Setup.
for
instance,
if the width of your report in design view is 7 inches,

and
page
setup
shows
left and right margins of 1 inch each, you'll get one

half
inch
slopping
over to a second page. if that half inch happens to be

blank,
you
won't
see
anything on the second page. the same issue may apply to

the
top/bottom
margins - but that can be harder to determine if you

have
several
detail
records on one page, because design view only shows the

width of
one
record.

also, if you're using a page break in a section, make

sure
there
is
no
space
between the page break and the bottom of the section.

hth


"Dermot" wrote in

message

...
I have created a..
Table of contacts tblcontacts.
Surname query qrySurname.
A report base on rptQuerySurname.
A macro to print a Selection mcrSelection.
When I search for a surname say "Brown" the report

returns
say
3
records.
When I run the print macro the preview display 6

records,
each



  #13  
Old October 5th, 2005, 11:23 AM
Dermot
external usenet poster
 
Posts: n/a
Default

Get you on another posting sometime maybe.
Cheers
Dermot

"tina" wrote:

hurray, you got it fixed!

The fact that I was now showing 4 reports ( 3 + one blank) in print

preview
was because I had overlooked having set my printer to "Duplex" Printing
because I wanted to print on both sides of the A5 sheet, hence the blank.
Swithing off Duplex then gave me 3 reports in print preview.


well, i bet i'd have missed that, if i had reviewed your report design. so i
learned something today, too - thanks!


"Dermot" wrote in message
...
Hi Tina,
I have had a break (Whole Day!) and have resolved my problem only 10 mins
ago....well with your first advice about dimensions.
The follow is a summary of previous postings...
Initially 3 reports were showing as 6 in print preview every alternate

being
blank. Your Correct Solution
By setting paper A5 properties of width = 14.9cm and height to 21.0cm and
ensuring the report dimensions were within these measurements using the
rulers resolved the problem.

What I Forgot I'd Done Earlier
A Search for Surname "Brown" should have produced only 3 reports because I
only had 3 Brown records.
The fact that I was now showing 4 reports ( 3 + one blank) in print

preview
was because I had overlooked having set my printer to "Duplex" Printing
because I wanted to print on both sides of the A5 sheet, hence the blank.
Swithing off Duplex then gave me 3 reports in print preview.

Your tips about "Report Section Back Colours" and "Control Borders" are

well
recieved and appreciated, good idea thanks, I'll note this down.

Best Wishes
Dermot

"tina" wrote:

okay, i'll keep an eye on this thread for awhile. after sleeping on it,
here's something i've never tried - but it might help you out: in

report
design view, click on each section of your report (including the ones

that
you think are "closed up"), and change the BackColor, each section to a
different color. then look at the report in PrintPreview. hopefully the
"extra" page will show the color of the section that's "bleeding over".

that
may at least give you a starting point of where to look for the problem.
another trick (i sometimes use this one) is to select all the controls

on
the report (Ctrl+A) and change the BorderStyle from Transparent to

Solid.
then look at the report in PrintPreview; again, you may see the outline

of
the "problem" control on the extra page(s).

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks for yet another reply.
It's good of you to offer to look at it for me, but it's very basic. I
think
you have explained all well to me and that I have probably overlooked
something that you have already described. I will read over this topic
from
beginning to end and think a while more before landing you the task of
sorting it out for me.
I will let you know my error when I find out.
Thanks
Dermot

"tina" wrote:

well, i've never designed a report to print to A5 paper, but i

wouldn't
think there'd be anything "special" about it. "x" size is "x" size,
after
all; you have to work within the space available on whatever paper

media
you're printing to, whether it be 8.5 x 11 paper, an envelope, a

sheet
of
stick-on labels, etc.

i can't think of anything else to suggest, Dermot. if your db is A97

or
newer, you can send me a copy (sans proprietary data) if you want,

and
i'll
see if i can figure out how to fix the report - and then tell you

how i
did
it. i'm not sure it will work, since you're outside the US -

differences
in
our Access software, maybe? but i'm willing to give it a shot. if

you
want
to go this route, post your email address, "disguised" to foil the
spammers,
and tell me how to "de-code" it; and i'll email you.

hth


"Dermot" wrote in message
...
Thanks again Tina,
I checked the "Object Combo Box" for a page break object but there

is
none
listed.
As you said , I would have had to insert it manually (thanks for

the
tip
didn't know this), so the page break isn't my problem now.

I have 4 reports showing, 3 + one blank......is there anything

else I
should
consider or has everything that could cause it been covered?

What puzzles me is that the report looks fine, it's dimensions

seem to
be
less than the paper (A5) dimensions, if I print one it looks the

way I
want
it.....

Should I start the report from scratch?
What procedure would you followwhen desighing a if you wanted a
report to
print to A5?
Best wishes
Dermot
"tina" wrote:

when you put a page break in a report section, and leave space
"under"
the
page break, you can wind up with a blank page inserted between

the
records
pages. AFAIK, you have to insert a page break manually; i don't
think
the
report wizard does it, but it's possible.

in your report design view, on the Formatting toolbar, take a

look
at
the
Object droplist (should be on the extreme left side, showing as

a
combo
box). click the arrow to drop the list and scroll through,

looking
for a
control name that begins with "PageBreak".

hth


"Dermot" wrote in message
...
Hi Tina,
Thanks again.
I have looked at everything you mentioned in your previous

post
now.
A5 Paper is W=14.9cm H=21.0cm (in the UK).
I found what you meant about the margins and set them all to

0, I
now
find
I
have 4 reports showing 3 and a blank page when I go to print

them.

The width property of my report in design view is 10.21cm,

which I
would
have thought was well withing the paper dimensions and the

Height
is
within
it's limits looking at the report design view rulers.

I have the side edge and bottom edge up tight against the

controls
in
the
report and have the header and footer up against the detail
section as
I
am
not using them.....only using the detailsed section......could
this be
a
problem?

You mention page breaks before...can you explain in a little

more
detail
the
relavance and how I check for them in a report?

Any other suggestions to help me resolve my problem would be
appreciated.



"tina" wrote:

well, a report is pretty much about physical space. your

paper
is x
inches
or cm wide and y inches or cm long. a single page in report
design
view
cannot be wider than "x minus the total of the left and

right
margins".
and
it cannot be longer than "y minus the total of the top and
bottom
margins" -
though, as i said before, finding height issues can be

harder
because
you
only see one records' worth of controls in the Detail

section
while
in
design view.

you mentioned looking at the Columns tab of the Page Setup
dialog.
is
the
Number of Columns set to 1, and Row Spacing set to 0 (zero)?

or,
if
this
is
actually a multi-column report, don't forget that you have

to
include
the
"Column Spacing times (the number of columns minus 1)" in

your
calculation
of the report width.

as for the paper size, look at Page tab in the Page Setup
dialog.
you
should
be able to set your Paper Size to A5, from the droplist. if

you
know
the
dimensions of A5 paper, then make sure your height/width
calculations
(see
previous paragraph) do not add up to more space than the
height/width of
A5
paper.

hth


"Dermot" wrote in message
...
Hi tina,
Thanks for the reply.
I have looked at your suggestions but still haven't

resolved
my
problem.
File | Page setup | Column Tab |W= 12.998cm H=13.497cm

In report design view under the report properties all tab,

I
can
only
find
a width property (12.998), there doesn't seem to ne a

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000 reports not printing in Access 2003 Heinz Thorwald Setting Up & Running Reports 5 August 9th, 2005 05:00 PM
Access 2003 error in printing reports to .PDF pfdino Setting Up & Running Reports 2 June 28th, 2005 11:08 AM
share a database jwb General Discussion 11 April 4th, 2005 09:14 PM
Will Access 97 reports run in Access 2002? jspanky Setting Up & Running Reports 2 October 5th, 2004 01:27 PM
Linking Access 97 tables to Access 2002 tables michaelwoodard Database Design 2 August 13th, 2004 02:43 AM


All times are GMT +1. The time now is 09:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.