Source of Control Behind Toolbar Button.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Walker - 24 Mar 2005 00:19 GMT

Hi,
Using Access 2003, I go to Tools/Customize... put a check in a toolbar to
display it, then right click on one of the toolbar buttons and click
Properties. A window called "Reports Control Properties" opens, but the "On
Action" field is empty. How can I tell what action this button is
performing? FYI, when I click on this button in runtime it gives me a list
of the available format for my reports to be emailed in, e.g. HTML, Excel,
Rich Text Format, Text...

Basically what I'm trying to do is add PDF to the list of available formats,
but I don't even know where the current list is coming from, and that's what
I'm trying to find out.

Thanks in advance,
John

Reply to this Message

John Walker - 24 Mar 2005 20:13 GMT

Hi,
I found part of what I was looking for. The button was actually "File/Mail
Recipient (as Attachment)" from the Customize window and under the Command
tab, but the icon was changed by the developer, so that's why I had trouble
finding it. But I still have the same problem where I don't know if I can
make Adobe Acrobat an available option on the Mail Recipient send list. Does
anyone have experience here?

Thanks,
John

> Hi,
> Using Access 2003, I go to Tools/Customize... put a check in a toolbar to
[quoted text clipped - 11 lines]
> Thanks in advance,
> John

Reply to this Message

Scott McDaniel - 25 Mar 2005 12:56 GMT

You can't add the PDF format, since it's not supported internally by Access.
The action that's being performed is, basically, the DoCmd.SendObject method
(see online help for a list of the available formats).

You can fudge it, however, by building your own customized menu and forcing
the report to (a) print to your PDF printer and then (b) open an Outlook
mail message and attach the PDF file. How you do this depends on what PDF
capabilities you have ... for example, if you have just a PDF printer (i.e.
no SDK or other automation utilities) then you're pretty much stuck trying
to make this a fully automated process. If you have Adobe Acrobat, then you
can certainly automate that, but you'd be better off posting in the Adobe
forums for info on that. I use a program from www.acrosoftware.com to
automate this and it works fine, but it's pricey.

> Hi,
> I found part of what I was looking for. The button was actually
[quoted text clipped - 30 lines]
>> Thanks in advance,
>> John

Reply to this Message