Results 1 to 2 of 2
  1. #1
    desk4tbc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    29

    Question Printing Report on opening print preview without dialog box

    Hey guys,

    I was wondering if it were possible to print a report after it opens in print preview but without the dialog box (and here's the kicker) while a form sub is still running.



    I figured out DoCmd.PrintOut will print without the dialog box but it wont run while Access is still running a sub from a form. (It gives a Run-time error 2585: This action can't be carried out while processing a form or report event.)

    The other thing I tried was putting RunCommand acCmdPrint after the open report line but that results in the unwanted print dialog box. Is there anyway to achieve this? I need the report to load in Print Preview as there is script in the onload bit of the report that needs to run in order for it to be printed correctly. Thanks ahead of time for the help.

  2. #2
    Stingaway is offline Efficiency Junkie
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Location
    The deep south. Keep going until you hit water basically.
    Posts
    224
    Try looking at the code behind the scenes of the "Quick Print" function, which sends the report to the default printer without a dialog box. You might be able to utilize that same function to do it via code instead of a button push.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-16-2011, 10:24 AM
  2. Replies: 1
    Last Post: 04-21-2011, 01:58 PM
  3. Report not opening, just printing.
    By Desstro in forum Reports
    Replies: 3
    Last Post: 12-11-2010, 01:36 PM
  4. Replies: 0
    Last Post: 07-15-2010, 12:13 PM
  5. Can't see sub report in print preview
    By LoggyDoggy in forum Access
    Replies: 1
    Last Post: 04-20-2010, 05:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums