UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Printing, Access 2016    
 
   
cperr017
post Jun 1 2020, 09:03 AM
Post#1



Posts: 11
Joined: 27-July 16



After opening a report, I use the command DoCmd.RunCommand acCmdPrint. This allows the user to select which printer to use prior to printing. However, using this command stops the code from executing and so if the user keeps the dialog box open and doesn't select anything, then it will not run the timer procedure that I have to check the status of the backend for performing maintenance. I need to incorporate a print dialog box that works like the command but doesn't stop the code from running. Is there a project that has a printer selection form that is like that command but doesn't stop the code? Thank you.
Go to the top of the page
 
theDBguy
post Jun 1 2020, 09:17 AM
Post#2


UA Moderator
Posts: 78,506
Joined: 19-June 07
From: SunnySandyEggo


Hi. Welcome to UtterAccess!

welcome2UA.gif

Yes, I think there's a demo for that in the Code Archive. Let me check...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
ADezii
post Jun 1 2020, 12:45 PM
Post#3



Posts: 3,090
Joined: 4-February 07
From: USA, Florida, Delray Beach


What about doing everything in a single step?
  1. Populate a Combo Box with a listing of all available Printers (see Image w/ Combo dropped).
  2. In the AfterUpdate() Event of the Combo Box, set the Default Printer to the chosen Printer.
  3. Print the Report directly using the OpenReport() Method.
  4. Reset the Printer to the Original Default.

Attached File(s)
Attached File  cbo.jpg ( 27.99K )Number of downloads: 1
 
Go to the top of the page
 
pere_de_chipstic...
post Jun 1 2020, 05:31 PM
Post#4


UtterAccess Editor
Posts: 10,669
Joined: 8-November 07
From: South coast, England


This code archive post may be what you are looking for.
hth

--------------------
Warm regards
Bernie
Go to the top of the page
 
cperr017
post Jun 2 2020, 08:57 AM
Post#5



Posts: 11
Joined: 27-July 16



Yes that is exactly what I was looking for. Thank you!
Go to the top of the page
 
pere_de_chipstic...
post Jun 2 2020, 09:15 AM
Post#6


UtterAccess Editor
Posts: 10,669
Joined: 8-November 07
From: South coast, England


yw.gif
Good luck with your project.

--------------------
Warm regards
Bernie
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th July 2020 - 07:26 AM