Avatar of anctech
anctech asked on

Select printer when printing Access 2003 Report

In Access 2003 I want to be able to have the option to select a different printer when printing reports.

Currently I have a Macro Button on a form that previews a report.  When I press the Preview Report Button that was created with the macro wizard, I the report opens on the screen and I have a custom print toolbar that has a print button.  The problem is that when I press the print button on the toolbar, the report goes directly to the default printer.   What I want is for the printer options box to appear so the user can select a differnt printer such as print to PDF.  

Any help or suggestions with this would be much appreciated.   I can provide more details if necessary.  Thank you.
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jeffrey Coachman

Clearer directions!

Open any Report in Preview
Click: Tools-->Customize (Just leave this dialog box open, and ignore it)
Then click the File menu
Locate the Print Icon
(Notice this print icon has 3 dots after it, THIS is the Print "Dialog box" Icon)
Hold down the Ctrl key AND the Alt key at the same time, and drag this icon to the toolbar.
(Don't worry, you are not moving it, you are moving a copy of it)

Clicking this Icon will now open the Print Dialog box (not print immediately)

Here is a screenshot of my screen right after I copied the icon onto my toolbar


CopyPrintDialogBoxIcon.bmp
ASKER
anctech

Thank you for your help.  This was exactly what I needed.  I am working on updating a database program I created several years ago so I may be posting more access 2003 questions in the near future.  Thank you again.
Jeffrey Coachman

;-)
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
yodasbrother

Was not what I was looking for
Jeffrey Coachman

yodasbrother:,

Then you should post a new question stating your specific concerns.
I am sure that you will get a swift response...

JeffCoachman