Toolbar launch of the Print Dialog

[cefr...@yahoo.com]

I have a custom toolbar for users during any preview of a report
launched by a button click on a form.

I would like to add a toolbar button to launch the Print Dialog (like
'Ctrl-P' or File|Print...).
Is this possible? I cant seem to find one, during customizing.

Note that there are no menus (disabled all menus) and the toolbar is
available only during Print Preview mode, when the user has launched a
report from a form.

Thanks in Advance

[Tim Marshall]

cefr...@yahoo.com wrote:

When you're in menu customization, have you tried holding the control
key down and grabbing the print menu item from, say, the standard file
menu and dragging it to your custom menu? The control key brings a copy
of an existing menu item (custom or standard) to a new location.

I do this for print and compact menus a fair bit, as well as for some of
the standard filter and sort menu items.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[cefr...@yahoo.com]

Tool bar item, not menu item, please.

Thanks

[Tim Marshall]

cefr...@yahoo.com wrote:

> Tool bar item, not menu item, please.

You still use the very same methods. 8) It's all part of the
commandbars collection and unless someone else steps in and corrects me,
all menu items, be they running function of your own design (from a
standard module) or a built-in function.

[cefr...@yahoo.com]

Tim,
I right clicked on the toolbar and chose customize.
I clicked on the Commands tab and chose File under Categories.

I scrolled on the Commands list box and found Print...(with printer
icon).
I dragged the item to the tool bar. The icon was a printer, like the
one that is already on there.
I tested by clicking the new icon on preview a report. No print dialog,
just print.

I tried your method too, by holding the control key and dragging the
Print... off the menu. Same result.

I want to give the user the Print dialog options (copies, from to, etc)
while in preview mode.

Thanks

[Tim Marshall]

cefr...@yahoo.com wrote:

> Tim,
> I right clicked on the toolbar and chose customize.
> I clicked on the Commands tab and chose File under Categories.
>
> I scrolled on the Commands list box and found Print...(with printer
> icon).
> I dragged the item to the tool bar. The icon was a printer, like the
> one that is already on there.
> I tested by clicking the new icon on preview a report. No print dialog,
> just print.
>
> I tried your method too, by holding the control key and dragging the
> Print... off the menu. Same result.

I'm not talking about taking it from the commands tab. 8)

When you have the customize dialog up, go to the top of your Access
window and click on the actual File menu. <deliberate caps!>HOLD DOWN
THE CONTROL KEY AND MAKE SURE YOU CONTINUE TO HOLD THE CONTROL KEY
DOWN</deliberate caps!> Click on the print menu item there and drag it
to your custom toolbar MAKING SURE YOU HOLD THE CONTROL KEY DOWN THE
WHOLE TIME.

And voila, you have a copy of the file/print menu item

If you don't hold the control key down, you actually move the print menu
item off the file list. There's a way to restore this, using some of
the restore buttons on the customize dialog, but it's a PITA.

[cefr...@yahoo.com]

I guess I'm not clear enough.

The icon does show up on the custom tool bar, by using either method.

The point is, that when the icon is pressed, it just prints, without
showing the Print options dialog.

I'm using Access 2000.
And, I did use your method as stated in the previous note.

I know how to use the controls keys, etc., the icon shows up on the
custom tool bar, which indicates the the item was dragged properly.
But, when the tool bar button is clicked, it prints the report without
showing the Print Options dialog.
I must be missing something.

Thanks

[PC Datasheet]

Put the following code in a standard module:
Function RptPrint()
On Error Resume Next
DoCmd.RunCommand acCmdPrint
End Function

Add a button to your custom toolbar. Open the button's properties. Put the
following expression in the button's OnAction property:
=RptPrint()

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
reso...@pcdatasheet.com
www.pcdatasheet.com

<cefr...@yahoo.com> wrote in message
news:1124455581.5...@g43g2000cwa.googlegroups.com...

[Tim Marshall]

cefr...@yahoo.com wrote:

> I guess I'm not clear enough.
>
> The icon does show up on the custom tool bar, by using either method.
>
> The point is, that when the icon is pressed, it just prints, without
> showing the Print options dialog.
>
> I'm using Access 2000.
> And, I did use your method as stated in the previous note.

No, you could not have. Otherwise, you'd have gotten the print dialog.
The method you described in the last post is the wrong way to do it.
What I described is the correct way to do it.

Reread what I wrote. You're pulling the icon from the wrong place.
Where you're pulling the print icon from, it will behave as you
describe. If you pull it from where I describe, it will give you the
print options dialog.

I've loaded a screen shot onto my personal site which indicates where
you're supposed to do what I described. It sounds as if you're stuck on
the customize dialog:

http://www.ucs.mun.ca/~tmarshal/images/AccessMenu.JPG

I guarantee this way is how you do it. I've done this countless,
countless times in setting up my toolbars and menus.

Please let me know when you have a look at this, I don't want it on my
site for very long as I have limited space there. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake

/^^ "What's UP, Dittoooooo?" - Ditto

[cefr...@yahoo.com]

Tim,
Thanks for your patience.

Sometimes, even with experience, a very small thing can make what seems
obvious and simple, very complicated and unpredictable.
I noticed on your screenshot that your File menu has Print... with the
shortcut key (Ctrl-P). Mine doesn't.
Somehow the menu item of just plain Print.. is on my menu. So even when
doing your method, I was dragging what seemed to be the right item, but
in fact it isn't.
The item just fires off the Print process. No dialog.
What was deceiving was that it was Print.., which I though was the
proper menu item. However, it was missing the shortcut key.
There is obviously two methods MS created for printing in office, with
a subtle difference, the SHORTCUT KEY!.

I apologize for all the confusion.
Though it may be a PITA, I would appreciate any advice on restoring the
internal Access menu with the proper Print...Ctrl-P item.

Thanks for helping ferret this issue out.

Your friend,

Christopher

[cefr...@yahoo.com]

Lastly,
I also posted an issue about hundreds of "Custom Popup" menus in my
toolbar properties list of toolbars.
However, using code to list the command bar objects doesn't reveal any
names of these "Custom Popups"
The names of these popups in the toolbar properties dialog are all
"Custom Popup xxxxxxxxx", where "xxxxxxxxxx" is some randon number.

Thanks again.

[Tim Marshall]

cefr...@yahoo.com wrote:

> Though it may be a PITA, I would appreciate any advice on restoring the
> internal Access menu with the proper Print...Ctrl-P item.

Ah, that explains the confusion... 8)

In the customize dialog, on the toolbars tab, select the "tool bar"
called "menu bar" and click the reset button.

If that doesn't work (I think reset only works with respect to the
current customize session), select "menu bar" again and click the
properties button.

Make sure the resultant Toolbar properties dialog has "Menu Bar"
selected in the combo box at the top (and if it doesn't, open the combo
and select "menu bar") and click the restore defaults button.

One or both of these should do the trick!

[cefr...@yahoo.com]

All works now with the toolbar. Thanks
Any ideas on the hundreds of Custom Popups post?

[Tim Marshall]

cefr...@yahoo.com wrote:

I've got a mess of those as well - about 10, I think. NOt sure what
they are. I tried the following in the debug window. The number is one
of the "Custom pop ups" similar to what you described:

commandbars("1198222").ShowPopup

This gave me aruntime error 5, "invalid procedure call or argument".
Where as this, with one of my opp up menus:

commandbars("mscMap").ShowPopup

Caused the actual mscMap custom pop up I did to appear.

So I dunno what the blink these guys are. <shrug>

BAck to your issue.

The custom pop ups don't show in the toolbar tab of the menu
customization dialog. You need to select Short Cut Menus and a separate
tool bar with short cut menus from various areas, including, at the
right, a sub menu called "Custom" which will list all your menus. I
guess because they are pop ups, they don't behave the same way in the
customize dialog as do toolbars and menubars.

[Tim Marshall]

cefr...@yahoo.com wrote:

> All works now with the toolbar. Thanks
> Any ideas on the hundreds of Custom Popups post?

See my other post. BTW, Steve's approach in his response to your
initial question is another way of achieving the same thing. The
docmd.runcommand series of ac constants covers pretty much everything.
I just got into the habit of the method I described.

[cefr...@yahoo.com]

I hope those Custom Popups dont slow things down. :)