Opening a pdf from access menu

  • Thread starter Thread starter -Michelle-
  • Start date Start date
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*
 
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.
 
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
 
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
 
Back
Top