PC Review


Reply
Thread Tools Rate Thread

Custom Menu Bar - Print Command

 
 
Frank B
Guest
Posts: n/a
 
      30th Aug 2003
I moved the Print Command to my custom Menu Bar, and it
worked OK, and was context sensitive (i.e. it stayed
greyed until a Report was Active). However, when Print
was selected, it would not prompt for copies, select
printer, etc. I tried without success to get it to
prompt. In the process I not only failed to get it to
prompt, but I lost the context sensitivity. Any ideas how
I lost context sensitity, and how to fix it? And, how to
get it to Prompt?

Thanks,
Frank
 
Reply With Quote
 
 
 
 
Albert D. Kallal
Guest
Posts: n/a
 
      30th Aug 2003
The way to solve the context problem is to make a custom menu bar for your
reports.

Simply specify the menu bar in the reports property sheet, and it will
appear when a report is launched.

The code that you can use for the print command that will show the print
dialog is:

DoCmd.RunCommand acCmdPrint

If you have a form with a timer event, you can experience a focus problem,
so I actually have my menu option call the following code:

Function DisplayPrintDialog()

On Error Resume Next
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint

End Function


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
File, Print command for Custom Menu =?Utf-8?B?U2FyYWgwODI0?= Microsoft Access 0 23rd Jul 2007 05:54 AM
Alt command for custom menu jhahes Microsoft Excel Programming 1 10th Aug 2006 10:32 PM
custom menu command =?Utf-8?B?TWVsaXNzYSBt?= Microsoft Outlook Contacts 1 27th Feb 2006 07:27 PM
Print Command On Custom Menu =?Utf-8?B?Um9zY28=?= Microsoft Access 0 29th Nov 2004 07:29 PM
Custom menu- Print command Eric G Microsoft Access Form Coding 4 5th Mar 2004 04:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:30 AM.