Default use Specific Printer and Label Size

[Ian]

I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.

This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it selects different label sizes. I am distributing an
MDE (split front back end), when we enter the page set up and manually
select the correct label size, then close and open the report again it
has changed back to the wrong label size. I cant find a way to make it
stay on the correct size.

Any help would be appreciated.

If this is off subject the I apologise, I am not sure if this is an
Access or print driver problem.

[ARC]

What is the "99012 Large Address"? Is this a report name, or label type?

By the way, how did you create the report? Using the label wizard, or custom
sized? I have customers that want support for the dymo label printer, and I
would love to have a copy of that report, if possible.

Andy
"Ian" <ia********@ntlworld.comwrote in message
news:ll****************@newsfe5-win.ntli.net...

>I am trying to get MS Access 2000 to print names and addresses onto a Dymo
400 label printer, I have set the Access Report to automatically select the
correct printer, then select the label size of “99012 Large Address”.

This works fine but when I move my database to another PC (with identical
Dymo printer and drivers) the report defaults to the correct printer but
does not select the label “99012 Large Address”. On different PC’s it
selects different label sizes. I am distributing an MDE (split front back
end), when we enter the page set up and manually select the correct label
size, then close and open the report again it has changed back to the
wrong label size. I cant find a way to make it stay on the correct size.

Any help would be appreciated.

If this is off subject the I apologise, I am not sure if this is an Access
or print driver problem.

[Ian]

When the Printer of Dymo 400 is selected there are a number of Paper
Sizes that can be selected from the drop down list, one of the paper
sizes is “99012 Large Address”, so it refers to the size of the paper.

I created the report manually, just set it to the printer, paper size,
set it to Landscape and put the relevant margins in, fits like a glove
until it forgets the paper size which it does every time I close it. You
are most welcome to a copy of the report if I can ever get it to work.

ARC wrote:

What is the "99012 Large Address"? Is this a report name, or label type?

By the way, how did you create the report? Using the label wizard, or
custom sized? I have customers that want support for the dymo label
printer, and I would love to have a copy of that report, if possible.

Andy
"Ian" <ia********@ntlworld.comwrote in message
news:ll****************@newsfe5-win.ntli.net...

>I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.

This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it selects different label sizes. I am distributing an
MDE (split front back end), when we enter the page set up and manually
select the correct label size, then close and open the report again it
has changed back to the wrong label size. I cant find a way to make it
stay on the correct size.

Any help would be appreciated.

If this is off subject the I apologise, I am not sure if this is an
Access or print driver problem.

[Tony Toews [MVP]]

Ian <ia********@ntlworld.comwrote:

>I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.

This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it selects different label sizes. I am distributing an
MDE (split front back end), when we enter the page set up and manually
select the correct label size, then close and open the report again it
has changed back to the wrong label size. I cant find a way to make it
stay on the correct size.

You might need to create the appropriate paper size on the printer. Just guessing
but it only takes a few minutes to setup.

Setting up custom paper sizes is totally different in the Win NT 4/2000/Win XP
environment compared to Win 95/98/ME.

Go into the list of Printers under the Settings button from the Start menu. You may
need to do this on the print server. Then click on File >Server Properties Then
you can create a new form with the sizes you want on it as well as a name.

Then you can follow the below steps inside Access to choose the just created Paper
Size. Go into the design of the report, Click 'File',Page Setup', Click the 'Page'
tab., Select 'Specific Printer',, Pick the printer you are using., Click 'Properties'
then the 'Paper' tab., In 'Paper Size' select 'Custom'. and choose your just created
Paper Size.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Jim Devenish]

I answered this about an hour or so ago but my reply is not appearing
so I must have failed to hit the Send button! So here goes again:

Open you report in Design mode.
Select Page Setup
On the Page tab, alongside Use Specific Printer, press the Printer
button
Select your printer and then press the Properties button
On the Layout tab, press the Advanced button
Against Paper/Output Paper size select your label 99012 Large Address
OK your way out of the windows

It is this value that appears to be remembered.

You will need to do this on every PC where the problem occurs. But
you will only need to do it once.

Good luck

Jim

[Jim Devenish]

Ian

I have had this problem.

Open you report in Design mode. Select Page Setup. On the Page tab,
alongside Use Specific Printer, press the Printer button. Having
selected your printer, press Properties. On the Layout tabe, press
the Advanced button near the bottom right. Against Paper/Ouput, Paper
size, select you 99012 Large Address label. OK your way out of the
various popup windows.

You will need to do this on every PC where there is a problem. You
should need to do this only once on each PC.

Good luck

Jim

[Ian]

I have done the following as suggested:
Open you report in Design mode. Select Page Setup. On the Page tab,
alongside Use Specific Printer, press the Printer button. Having
selected your printer, press Properties. On the Layout tabe, press
the Advanced button near the bottom right. Against Paper/Ouput, Paper
size, select you 99012 Large Address label.

Using Access 2000 with an MDB this works fine and Remembers the page
size and settings next time I open the report, however when I convert
this database to an MDE it Forgets the changes as soon as I close the
report so each time I open it I have to make the setting changes again.

For the usual reasons I don’t want to distribute an MDE.

I have not yet tried Tony’s suggestion about setting up a custom
paper sizes but I will.


Ian wrote:

I am trying to get MS Access 2000 to print names and addresses onto a
Dymo 400 label printer, I have set the Access Report to automatically
select the correct printer, then select the label size of “99012 Large
Address”.

This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it selects different label sizes. I am distributing an
MDE (split front back end), when we enter the page set up and manually
select the correct label size, then close and open the report again it
has changed back to the wrong label size. I cant find a way to make it
stay on the correct size.

Any help would be appreciated.

If this is off subject the I apologise, I am not sure if this is an
Access or print driver problem.