Is it possible to insert a PDF picture into an Access form ? 1

[vamoose]

Wondering if this is at all possible.

Thank you.

 

[Pampers]

I don't think that would be possible... Is there any specific reason why you want to use this file type?

Pampers
Keeping it simple can be complicated

 

[Remou]

Pampers, I have found it is possible to put all sorts of files in Bound and Unbound Object Frames, including PDFs. Did you mean something different?

 

[Pampers]

Hi Remou,
That is good to hear, I did't think it could be done... So, looking forward to your next post.

Pampers
Keeping it simple can be complicated

 

[vamoose]

Me too. Please do tell...

 

[Remou]

I am not sure that I have not missed a point, but here goes anyway. If you create a table with a field type of OLE Object, you will be able to create a form from this table and add all sorts of files, including PDF, to the OLE Object field. Alternatively, you can add an Unbound OLE Frame to your form and choose "Create from file", this will show whatever object you choose on your form.

 

[vamoose]

Can someone possibly tell me what I am doing wrong from this code ? I am stuck with using the PDF format due to our documentation department. I am trying to create a form that will load the appropriate .pdf picture dependant on a user input of a part number. Using Access 2000, Adobe Reader 8.0, Windows 2000 Pro, SP4.

1. I have created a form, called frmStart
2. On this form I have inserted an unbound OLE Object frame, called OLEUnbound199, from a .pdf picture file and selected the link check box. This picture comes from another computer loaded with all the pictures I need to access.
3. The .pdf picture shows up fine in the form.
4. I rezized it, set the size mode property to stretch and it is perfect so far...
5. Now, I have deleted the text
\\172.16.6.172\PackSpec\DA2030500D.pdf in the Source Doc property and inserted the following VBA code to replace it with:
Me!OLEUnbound199!SourceDoc = "\\172.16.6.172\PackSpec\DA2030500D.pdf" to load the correct picture after the entry of a valid part number.

I now get an error of: "Run-time '438' Object doesn't support this property or method" The picture is always the same. Any ideas please ? Thank you very much.

 

[Remou]

How about:

With Me.OLEUnboundX
    .Enabled = True
    .Locked = False
    .OLETypeAllowed = acOLELinked
    .Class = "AcroExch.Document.7"
    .SourceDoc = "C:\Docs\Tek-Tips.pdf"
    .Action = acOLECreateLink
    .SizeMode = acOLESizeClip
End With