opening a pdf file from a form

[Guest]

Hi All

I have been trying to open a PDF file in a form. I am using the following
code.

Dim objXL As Object
Set objXL = CreateObject("Acrobat.Application")

objXL.Document.Open "L:\BP Database\Data Base Form\Pal form.pdf"
objXL.Visible = True

 

[Arvin Meyer [MVP]]

Try using ShellExecute:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I've seen this answer a number of times...but us newbies have no clue how to
use it. Could someone supply directions on where to place it and how to call
it? I'd appreciate any input. thanks.

 

[Douglas J. Steele]

Create a new module in Access. Copy everything between Code Start and Code
End from the web page into the new module, then save the module. (Make sure
you don't name the module the same as the functions within it)

Then, to open the file, you'd use:

Call fHandleFile("L:\BP Database\Data Base Form\Pal form.pdf", WIN_NORMAL)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)