Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 13th, 2006, 11:46 AM
Authorized User
 
Join Date: Apr 2004
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need code to open the printer dialog screen

I have a customized toolbar for my reports within Access. I put the printer on it but when the user clicks on the printer button from the toolbar it simply prints the report to the default printer instead of bringing up the printer dialog screen. I need the printer dialog screen to come up to allow the user to select the printer and how many copies they need, and various other things. The only way I know how to do this is to place the File menu on my custom toolbar but I need to know if there is some code to do this instead. I don't want my users to have the file menu. Thanks in advance for the help.

Donrafeal

 
Old June 13th, 2006, 01:35 PM
Authorized User
 
Join Date: Apr 2004
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

nevermind, I found the code I was looking for in the Access forum.

DoCmd.RunCommand acCmdPrint


Donrafeal






Similar Threads
Thread Thread Starter Forum Replies Last Post
get the printer name chosen in print dialog deep_ocean Classic ASP Basics 0 March 14th, 2007 10:27 AM
Force printer dialog to appear when printing mjk6035 Crystal Reports 0 June 28th, 2006 11:37 PM
Open a Parameterised Query to screen using code vbark Access VBA 2 June 5th, 2006 05:46 PM
OPEN DIALOG.... NOW !!!!!!!!!!!! ALEX_GRIM Beginning VB 6 1 December 8th, 2004 10:26 AM
Showing Printer Dialog Box in .vbs file ntgk VBScript 0 August 6th, 2004 06:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.