PDF displaying in Form

[hilfesucher]

Hello,



I am currently having a form that have a textbox field, a command button. I am trying to find a code to so that I can open or display a PDF file in a form.
What I need is a Code to open various PDF file from the folder (the folder is called “PDF”) is located in “C:\Users\RU\Desktop\PDF”.
When I write the name of the PDF in the textbox and click the button, the PDF loads directly in Form and if the PDF name is not found in the folder then the message box "File not exist" should appear.

Any help would be greatly appreciated
Thanks,

[June7]

Think requires Web Browser control to display PDF file.

Bing: Access database display pdf in form

http://stackoverflow.com/questions/1...tent-on-a-form

Also, https://www.accessforums.net/access/...ive-41691.html

[hilfesucher]

Hello June7,
I have access 2007,where can I find the "WebBrowser Control"?
thanks

[June7]

I don't remember. Never used it.

Bing: Access 2007 web browser control

http://bytes.com/topic/access/answer...-access-2007-a

[hilfesucher]

Hello,

I am currently having a form that have a textbox field, a command button. I am trying to find a code to so that I can open or display a PDF file in a form.
What I need is a Code to open various PDF file from the folder (the folder is called “PDF”) is located in “C:\Users\RU\Desktop\PDF”.
When I write the name of the PDF in the textbox and click the button, the PDF loads directly in Form and if the PDF name is not found in the folder then the message box "File not exist" should appear.

I insert the following code in the button but it not works:

Private Sub CommandButton1_Click()
Dim myPath As String
Dim myfile As String

myfile = "C:\Users\RU\Desktop\PDF\" & Me.TextBox1.Text & ".PDF"
Shell & myfile, vbNormalFocus
End Sub



Any help will be greatly appreciated

[June7]

Merged threads.

[HiTechCoach]

Hello,

I am currently having a form that have a textbox field, a command button. I am trying to find a code to so that I can open or display a PDF file in a form.
What I need is a Code to open various PDF file from the folder (the folder is called “PDF”) is located in “C:\Users\RU\Desktop\PDF”.
When I write the name of the PDF in the textbox and click the button, the PDF loads directly in Form and if the PDF name is not found in the folder then the message box "File not exist" should appear.

I insert the following code in the button but it not works:

Private Sub CommandButton1_Click()
Dim myPath As String
Dim myfile As String

myfile = "C:\Users\RU\Desktop\PDF\" & Me.TextBox1.Text & ".PDF"
Shell & myfile, vbNormalFocus
End Sub



Any help will be greatly appreciated

The Shell command is used to run programs. It does not understand files extension and how to open the associated program. To use Shell you must include the path to the application (exe) before the file name.

You will need to use ShellExec if you want to pass only a file. I have created this example that shows how to use it: Document Links (Click Here)

Note: Using Shell or ShellExec will open the PDF in a separate application not on the form.

The native (built-in) Web Browser Contriol (WBC) was added in Access 2010. It can be used to view the the PDF directly on a form. In 2007 and earlier you have to use teh WBC ActiveX control.

My users say it is difficult to read a PDF when on a form. They prefer opening it in a PDF viewer.

[hilfesucher]

Hello HiTechCoach,
and thank you for your help
I want to ask if you can tell me please, how the code should be if I want to write in the textbox the name of File and not the File Path.

Thank you in advance for your help

[HiTechCoach]

Hello HiTechCoach,
and thank you for your help
I want to ask if you can tell me please, how the code should be if I want to write in the textbox the name of File and not the File Path.

Thank you in advance for your help

It looks like you already have that figured out:

From you post (#5)

myfile = "C:\Users\RU\Desktop\PDF\" & Me.TextBox1.Text & ".PDF"

[NTC]

Whenever one attempts to window an application (Adobe PDF in this case) inside a database form - it is problematic. This question comes up routinely also involving Word, Excel, etc. If you are trying to display a passive single page image - then exporting the pdf to a jpg or bmp or something and relying on the image control is the way to go. But the Adobe PDF application is overall quite sophisticated - so if you wish to use its full features and functions one should generally not be windowing it thru a database form but instead rely on the operating system - the true 'Windows' solution....to launch the application outside of the database....