Specific printer for report won't hold config

  • Thread starter Thread starter Dennis
  • Start date Start date
D

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
 
Dennis said:
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.
Click to expand...

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.
 
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.
 
Dennis said:
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
Click to expand...


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

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



--
 
Back
Top