How to Display PDF file on Form

[Leo_Polla_Psemata]

Hi
I want to display a pdf file on a form.
I tried the exact steps from this video
https://www.youtube.com/watch?v=UltWxgzgXPk&t=17s
as well as from several other similar

The error I get is
"The OLE server isn't registered"
To register the OLE server, reinstall it"
There is no object in this control"

Do you have any idea how could I solve this problem?

 

[isladogs]

Use a web browser control.
Arnelgp did a nice example of this here
https://www.access-programmers.co.uk/forums/showthread.php?t=297837
It can be used for various file types

 

[Leo_Polla_Psemata]

https://www.access-programmers.co.uk/forums/showthread.php?t=297837

Hi, I visited the link.
This sample database, in that link, does exactly what I need.
I downloaded in my pc and db works just fine, when I transfer the code to my own database, I get the below error

---
Dim fd As Office.FileDialog

Compile error
User-defined type not defined
---

My knowledge in VBA is rudimentary and I feel I must have missed something very very basic.
Please help. Why id doesn't work in my database? I have crosschecked twice, all names and controls are correct.

 

[isladogs]

Look at the VBA references in arnels example.
Compare with yours and add any that are missing.
Probably Microsoft Office Object Library but check for yourself

 

[Leo_Polla_Psemata]

I checked.
Indeed , example database has a tick in
Microsoft Office 16.0 Object Library

which I don't find this reference in my database.

Could I update it from somewhwere ?

Alternative, I could transfer the objects from my database into example and continue with example

 

[AccessBlaster]

Microsoft Office 16.0 Object Library, if you have a reference similar to this try it.

 

[Ranman256]

you DONT want to display pdf on a form. It looses resolution.
Just open the pdf.

 

[isladogs]

I checked.
Indeed , example database has a tick in
Microsoft Office 16.0 Object Library

which I don't find this reference in my database.

Could I update it from somewhwere ?

Alternative, I could transfer the objects from my database into example and continue with example

You do have it otherwise it would be marked as MISSING in arnel's example
If its not in the list (it should be...) you need to browse for it
The file you want is called mso.dll and for Office 16.0 (2016) the path will be something like: C:\Program Files\Common Files\microsoft shared\OFFICE16\mso.dll but as I'm using Office 2010 that may not be exactly correct for you

Alternatively you can of course import all your database objects into arnel's example.

Incidentally, I disagree with ranman about the quality of PDF resolution in a web browser utility. Suggest you try for yourself and see what you think

 

[Gasman]

You need your version included in the References..

I run 2007, so mine is version 12.
That is included and arnelgp's db runs fine

HTH

I checked.
Indeed , example database has a tick in
Microsoft Office 16.0 Object Library

which I don't find this reference in my database.

Could I update it from somewhwere ?

Alternative, I could transfer the objects from my database into example and continue with example