print page number

C

cjgav

Hi
i have purchased a Brother ql570 label printer I need to print a label in my
db with this my problem is when I print my label it prints 2 blank labels as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print page 1 to
automate this process.
 
G

Graham Mandeno

It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth
 
C

cjgav

hi
Thanks for your help i've all ready checked this . but it still prints 2
labels !


Graham Mandeno said:
It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
Hi
i have purchased a Brother ql570 label printer I need to print a label in
my
db with this my problem is when I print my label it prints 2 blank labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print page 1 to
automate this process.
 
G

Graham Mandeno

Than is very peculiar!

Can you please try creating a new report with nothing on it except a label
with the caption "Test" at the top left of the Detail section. Remove any
headers and footers and size the detail section to just allow space for the
label. Then go to page setup and set all margins to zero.

Try printing this report to your label printer and see what happens.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
hi
Thanks for your help i've all ready checked this . but it still prints 2
labels !


Graham Mandeno said:
It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
Hi
i have purchased a Brother ql570 label printer I need to print a label
in
my
db with this my problem is when I print my label it prints 2 blank
labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print page 1
to
automate this process.
 
C

cjgav

Hi
Thank you for your help.
I can not set the margins to 0 . values keep resetting.

regards

Graham Mandeno said:
Than is very peculiar!

Can you please try creating a new report with nothing on it except a label
with the caption "Test" at the top left of the Detail section. Remove any
headers and footers and size the detail section to just allow space for the
label. Then go to page setup and set all margins to zero.

Try printing this report to your label printer and see what happens.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
hi
Thanks for your help i've all ready checked this . but it still prints 2
labels !


Graham Mandeno said:
It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi
i have purchased a Brother ql570 label printer I need to print a label
in
my
db with this my problem is when I print my label it prints 2 blank
labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print page 1
to
automate this process.
 
G

Graham Mandeno

What values do they reset to? They should be getting the non-printable area
metrics from the printer driver and setting them accordingly. That should
be OK, so long as there is still room on the label for your detail section.

Have you selected the label printer in Page Setup before setting the
margins?

--
Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
Hi
Thank you for your help.
I can not set the margins to 0 . values keep resetting.

regards

Graham Mandeno said:
Than is very peculiar!

Can you please try creating a new report with nothing on it except a
label
with the caption "Test" at the top left of the Detail section. Remove
any
headers and footers and size the detail section to just allow space for
the
label. Then go to page setup and set all margins to zero.

Try printing this report to your label printer and see what happens.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
hi
Thanks for your help i've all ready checked this . but it still prints
2
labels !


:

It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi
i have purchased a Brother ql570 label printer I need to print a
label
in
my
db with this my problem is when I print my label it prints 2 blank
labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print
page 1
to
automate this process.
 
C

cjgav

The margins set at T 1.48cm B1.48cm L1.52cm R1.52cm
THE LABE SIZE IS 3cm x 6.9cm the printer prints 2mm left 3mm top I have
selected the correct label

Graham Mandeno said:
What values do they reset to? They should be getting the non-printable area
metrics from the printer driver and setting them accordingly. That should
be OK, so long as there is still room on the label for your detail section.

Have you selected the label printer in Page Setup before setting the
margins?

--
Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
Hi
Thank you for your help.
I can not set the margins to 0 . values keep resetting.

regards

Graham Mandeno said:
Than is very peculiar!

Can you please try creating a new report with nothing on it except a
label
with the caption "Test" at the top left of the Detail section. Remove
any
headers and footers and size the detail section to just allow space for
the
label. Then go to page setup and set all margins to zero.

Try printing this report to your label printer and see what happens.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

hi
Thanks for your help i've all ready checked this . but it still prints
2
labels !


:

It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi
i have purchased a Brother ql570 label printer I need to print a
label
in
my
db with this my problem is when I print my label it prints 2 blank
labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print
page 1
to
automate this process.
 
G

Graham Mandeno

It sounds to me like there is a problem of communication between Access and
the printer driver, or the driver is incorrectly installed.

Access thinks it is being told the non-printable area top and bottom of the
page (label) is 1.48cm. If the height of the label is 3cm, that leaves only
4mm to print on!

To test this theory, try making your detail section less than 0.4cm high and
about 3.5cm wide. Put nothing on it but a rectangle the same size.
--

Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
The margins set at T 1.48cm B1.48cm L1.52cm R1.52cm
THE LABE SIZE IS 3cm x 6.9cm the printer prints 2mm left 3mm top I have
selected the correct label

Graham Mandeno said:
What values do they reset to? They should be getting the non-printable
area
metrics from the printer driver and setting them accordingly. That
should
be OK, so long as there is still room on the label for your detail
section.

Have you selected the label printer in Page Setup before setting the
margins?

--
Graham Mandeno [Access MVP]
Auckland, New Zealand

cjgav said:
Hi
Thank you for your help.
I can not set the margins to 0 . values keep resetting.

regards

:

Than is very peculiar!

Can you please try creating a new report with nothing on it except a
label
with the caption "Test" at the top left of the Detail section. Remove
any
headers and footers and size the detail section to just allow space
for
the
label. Then go to page setup and set all margins to zero.

Try printing this report to your label printer and see what happens.

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

hi
Thanks for your help i've all ready checked this . but it still
prints
2
labels !


:

It sounds like your report won't all fit onto one label.

Make sure that your report has no page header/footer and no report
header/footer.

Then make sure that:
Detail.Height+TopMargin+BottomMargin <= LabelHeight
and
Report.Width+LeftMargin+RightMargin <= LabelWidth

--
Good Luck :)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Hi
i have purchased a Brother ql570 label printer I need to print a
label
in
my
db with this my problem is when I print my label it prints 2
blank
labels
as
well I get get round this by printing page 1 only .
What I would like to know please is what is the vb cade to print
page 1
to
automate this process.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top