A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printer options



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2004, 12:11 PM
Basil
external usenet poster
 
Posts: n/a
Default Printer options

Hiya,

When I disable toolbars, full menus etc on the database startup option, it does not give me the print option under file in the menu bar.

I accommodated this by having a 'print' button on the form and creating my own toolbar with it on.

However the problem is that it always sends it to the default printer - is there anyway through code I can bring up the printer options menu (where they can select printer/no. of copies etc)?

Alternatively is there a way through code that I can allow the 'print...' menu item under file to be visible?

Thanks,

Basil
  #2  
Old May 19th, 2004, 02:43 PM
solex
external usenet poster
 
Posts: n/a
Default Printer options

Basil,

This is a big kludgy but works: When in the customize mode of your tool bar
open up the file menu and drag the print button from the file menu to your
toolbar. This will allow you to show the print dialog before you print the
down side is that the file print menu option is now on your toolbar and not
in the menu.

Regards,
Dan

"Basil" wrote in message
...
Hiya,

When I disable toolbars, full menus etc on the database startup option, it

does not give me the print option under file in the menu bar.

I accommodated this by having a 'print' button on the form and creating my

own toolbar with it on.

However the problem is that it always sends it to the default printer - is

there anyway through code I can bring up the printer options menu (where
they can select printer/no. of copies etc)?

Alternatively is there a way through code that I can allow the 'print...'

menu item under file to be visible?

Thanks,

Basil



  #3  
Old May 19th, 2004, 03:41 PM
Basil
external usenet poster
 
Posts: n/a
Default Printer options

That works great! Thanks.

I also found another method that would not require me removing the print... from the file menu:
Create a macro that does runcommandrint
If you put this macro on the toolbar and then copy the printer button icon across it will also give you the print dialogue box, and you won't have to remove it from the file menu.

I find it very strange that by removing full menus from the db startup options it will offer you 'print...' on the file menu yet when opening a report it won't - even though Ctrl+P will still work. The logic behind that decision baffles me.

Baz

----- solex wrote: -----

Basil,

This is a big kludgy but works: When in the customize mode of your tool bar
open up the file menu and drag the print button from the file menu to your
toolbar. This will allow you to show the print dialog before you print the
down side is that the file print menu option is now on your toolbar and not
in the menu.

Regards,
Dan

"Basil" wrote in message
...
Hiya,
When I disable toolbars, full menus etc on the database startup option, it

does not give me the print option under file in the menu bar.
I accommodated this by having a 'print' button on the form and creating my

own toolbar with it on.
However the problem is that it always sends it to the default printer - is

there anyway through code I can bring up the printer options menu (where
they can select printer/no. of copies etc)?
Alternatively is there a way through code that I can allow the 'print...'

menu item under file to be visible?
Thanks,
Basil




  #4  
Old May 19th, 2004, 05:06 PM
Basil
external usenet poster
 
Posts: n/a
Default Printer options

Oops.
I meant to write that it is weird when you disable full menus that 'file''print...' is visible when viewing a form, but not visible when viewing a report in preview.

Baz
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.