 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2008Add a New Printer
I have used things from these posts to bring up the default Printer Dialog box so that a user can choose a printer for the report. I also have built my own. However, occasionally (more than I care to admit) I have users without a printer installed but the PDF or the MS XPS DOCUMENT WRITER and the MS OFFICE DOCUMENT IMAGE WRITER. On the standard dialog box there is no FIND PRINTER like other Office products. So I built my own figuring I could add the Add Printer like what is in "Add a printer" under printers and faxes. So I get to the ADD PRINTER.PDS file that brings up the part where you add a printer. However, when I try to call it from within Access as a shell, I get Invalid procedure call or argument. Does anyone know how to call Add A Printer from within Access VBA? tia Vanya >I have used things from these posts to bring up the default Printer Dialog > box so that a user can choose a printer for the report. I also have built [quoted text clipped - 21 lines] > > Vanya Shell "rundll32.exe printui.dll, PrintUIEntry /il" will bring up the Add Printer Wizard. Stuart, Thank you, works great! Two more questions... 1. When I bring this up, it opens up behind the access window, any ideas on how to bring it up in front? 2. Do you know how to bring up the FIND PRINTER dialog box? Thanks, Vanya > >I have used things from these posts to bring up the default Printer Dialog > > box so that a user can choose a printer for the report. I also have built [quoted text clipped - 25 lines] > > will bring up the Add Printer Wizard. > Stuart, > [quoted text clipped - 9 lines] > > Vanya <SNIP> I'm afraid it's no to both questions. Perhaps someone else can jump in? If you change the command to Shell "rundll32.exe printui.dll, PrintUIEntry /il", vbNormalFocus it will set focus to the add printer wizard. > > Stuart, > > [quoted text clipped - 12 lines] > > I'm afraid it's no to both questions. Perhaps someone else can jump in? > If you change the command to > > Shell "rundll32.exe printui.dll, PrintUIEntry /il", vbNormalFocus > it will set focus to the add printer wizard. Already tested that. Doesn't do it for me... Win XP Pro SP2 here. How about you? Stuart, I have XP Pro with SP3. Running Access 2003. > > If you change the command to > > [quoted text clipped - 4 lines] > > Win XP Pro SP2 here. How about you? > Stuart, > > I have XP Pro with SP3. Running Access 2003. Well in that case the only difference between us is SP3. Perhaps someone else with SP2 could try it and confirm/deny my result in this thread... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.