If you are using Access 2002 or newer there is a workaround that I now
use to solve the many problems I have encountered over the years with
Dymo drivers. You can use this solution for most page setup settings
and it also works with MDEs. When you know what the margins, print
orientation, paper size, and other settings should be for your labels,
you can save this data to a table in your MDE. Using the new Printer
object, you can apply the settings to your report at runtime each time
the report is opened. In essence, your code opens the report in
preview mode then changes settings of the report's printer object. If
you are printing rather than previewing the report, open in preview
mode but hidden. Take a look the Printer object in Help for more
information.
Rick Collard
www.msc-lims.com
On 15 Apr 2004 01:21:08 -0700,
da*****@pacbell.net (Number2) wrote:
The Dymo label printers are great, however Access will not allow Page
and Printer Setup saving in MDE Runtime. There is NO work around that
I can find in over one year of searching. The only fix lies with Bill
Gates and crew. They need to enable Page and Printer Setup Saving in
MDE Runtime.