Opening a pdf from access menu

M

-Michelle-

Hi
Using Access 2003

I have a user manual which is saved in pdf format.

I want the user to be able to click on a customised menu item to open up the
..pdf from within the program.

Can anyone suggest a way to do this?

TIA
Michelle
*Please only post replies to the newsgroup*
 
A

Albert D. Kallal

Just make a public function in a standard Module

You can go:

Public Function MyHelp()

application.FollowHyperlink "c:\myhelp\myhelpsuff.pdf"

end Function

And, I sure you many times run code from a custom menu.

So, add a "custom" menu option, and in the on-action event of the menu,
simply run the above public function

To, run a function from a menu, you just would go:

=MyHelp()

And, using application.FollowHyperlink will launch any file based on the
type (extension) as if you clicked on it.
 
C

cgordon

I found this thread interesting to a project I am working on. I am trying to
open PDF files from a form in Access and want to pass the name of the
document from a field in the form. I can open the document per your example,
but I have 540 documents that I need to me able to scroll through or query on
the Access form and then open.

Any assistance would be greatly appreciated.

Craig Gordon, Phoenix, AZ
 
A

Albert D. Kallal

What not then just build a c continues form...place a button on the "right"
side with a cute set of glasses..and when clicked on, you simply take the
field names with path/file name....and open it....

Here is some screen shots of some continues forms...and note how many of
them have a repeating "button". Heck, give the button the pdf icon if you
want!!

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

The code to open the file behind this button on the continues form would be:

if isnull(me.MyFieldWithDocPathName) = false then
application.FollowHyperlink me.MyFieldWithDocPathName

endif
 
Top