Specific printer for report won't hold config

[Dennis]

I have a report that's really a visitor badge (Access 2002). It's set to
print to a Dymo330 label printer (specific printer selected. The printer is
hooked up and on-line.) The label type is something like 90916 Video Top.
However, when I pull the report up in design view and go to Page Setup, it's
set to 30252 (or something like that). I change it to the correct label type,
save the report, and close it. When I reopen the report, it's back to 30252.
Nothing I do seems to allow it to save the proper label type. I've created a
new blank database and copied the objects from the old one, compiled it,
everything. Nothing seems to work. This is a MUST-WORK application that
suddenly doesn't anymore.

The only recent change was that the linked tables were changed from a
SQL2000 database server to a SQL2005 database server. No other changes were
made. I'm hoping that someone can assist with this, as it's driving mt crazy.
(I'm posting this in another newsgroup as well, because I've got to get a
resolution ASAP. My apologies in advance.)

TIA

 

[Peter Hibbs]

See if this site helps :-

http://support.microsoft.com/kb/240826/en-us

HTH

Peter Hibbs.

 

[Mike Painter]

I have a report that's really a visitor badge (Access 2002). It's set
to print to a Dymo330 label printer (specific printer selected. The
printer is hooked up and on-line.) The label type is something like
90916 Video Top. However, when I pull the report up in design view
and go to Page Setup, it's set to 30252 (or something like that). I
change it to the correct label type, save the report, and close it.
When I reopen the report, it's back to 30252. Nothing I do seems to
allow it to save the proper label type. I've created a new blank
database and copied the objects from the old one, compiled it,
everything. Nothing seems to work. This is a MUST-WORK application
that suddenly doesn't anymore.

What happens when you just print the report?
I used to see this happen when a report was opened in design mode but don't
remember it ever reverting when just printing.
You might also try a custom design.

 

[Paul Shapiro]

This is not an answer to the question you asked, but if you can't solve it
directly, I have a class module I've written for a client using Dymo
printers. Among other features, it will print a label on a requested
template. It also supports previewing the label before printing, without
using an Access report. If you want a copy, email me after making the
un-spam correction to my email address.

 

[Michael J. Strickland]

I have a report that's really a visitor badge (Access 2002). It's set
to
print to a Dymo330 label printer (specific printer selected. The
printer is
hooked up and on-line.) The label type is something like 90916 Video
Top.
However, when I pull the report up in design view and go to Page
Setup, it's
set to 30252 (or something like that). I change it to the correct
label type,
save the report, and close it. When I reopen the report, it's back to
30252.
Nothing I do seems to allow it to save the proper label type. I've
created a
new blank database and copied the objects from the old one, compiled
it,
everything. Nothing seems to work. This is a MUST-WORK application
that
suddenly doesn't anymore.

The only recent change was that the linked tables were changed from a
SQL2000 database server to a SQL2005 database server. No other changes
were
made. I'm hoping that someone can assist with this, as it's driving mt
crazy.
(I'm posting this in another newsgroup as well, because I've got to
get a
resolution ASAP. My apologies in advance.)

TIA

This is a known bug with Access 2007. You need this hotfix from
Microsoft:

http://support.microsoft.com/kb/950488



--