viewing a pdf in web browser control (1 Viewer)

[roosn]

Hi

i have an access 2013 unbound form, for which the aim was to record certain information from a pdf file.

so rather than load the fields with information copied and pasted from a pdf, i would like to show a pdf in a web browser, the file location controlled by a location on a txtbox

currently when i open the form, if the txtbox has no value the last pdf opened, reopens, if the txtbox has a value then the related pdf opens.

however, i do not want the pdf to open in its own right, i but for it to be viewed with a control (web browser) on the unbound form

can this be done on unbound forms, or am i missing something

thanks in advance

 

[jdraw]

roosn,

I'm attaching a sample db that is Acc 2010.
An unbound form with web browser.

You click the Go button and it will show file dialog for files in a folder you specify.
You'll have to open the form in design mode, look at the click event and adjust the folder reference to meet your needs.

Hope it is helpful.

Good luck.

 

[roosn]

Hi jdraw

thank you for that reply

its interesting because again, the actual pdf file opens, and the web browser itself shows a blank page, albeit with the text "Navigation to the webpage was cancelled"

 

[Minty]

What version of Acrobat do you have on the machine you are trying this on ?

 

[jdraw]

roosn,

Did you adjust the folder reference?
I'm using acc2010, but don't think 2013 would cause change in functionality.
I have my folder set to the value in the event procedure

Private Sub btnGo_Click()

10    On Error GoTo Err_btnGo_Click

'  Navigate to the folder where you have the pdfs you want to browse

      ' Me.WebBrowser0.Navigate "file:///" & GetMyPDF("I:\MyPDFS\")
20    Me.WebBrowser0.navigate "file:///" & GetMyPDF("C:\users\mellon\documents\")
Exit_btnGo_Click:
30        Exit Sub

Err_btnGo_Click:
         
40        MsgBox Err.Description
50        Resume Exit_btnGo_Click
          
End Sub

I am attaching the screen shot as a jpeg.

 

[roosn]

Hi Minty

Adobe Acrobat X Pro

Hi jdraw

there is no .Navigate control on the 2013 version

i came across this earlier when i was googling

thanks guys for the replies

i'm using access 2013 64-bit, it could be that i need to use the 32 bit version

 

[jdraw]

see if Albert Kallal's answer here is applicable to you.
I don't have A2013. But what he is describing may be the new web browser control.

Good luck.

 

[roosn]

thanks jdraw

i caught this page earlier and tried the various text described

and there he comments that the web browser control can't be assigned on an unbound form, which i think i am proving the now