In the end this came down to a syntax issue. I used the WebBroswer Control and this line of code:
ShowPDF.ControlSource = "='" & "C:\123\Name.pdf" & "'"
In life, it is a fine line between being a genius and muddling around like a blind person!
Thanks for your help and support and hope someone else can use this one day!
Patty
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: Saturday, February 23, 2019 3:21 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] How to use web browser control to display pdf in form.
thanks, Patty, and you're welcome ~
miss John's presence (and presents) here too
~crystal
On 2/22/2019 8:52 PM, Patty Mapes patty.mapes@gmail.com <mailto:patty.mapes@gmail.com> [MS_Access_Professionals] wrote:
You are brilliant! This is worth some Saturday hours.
You remind of the old days when John V would just find these answers in the air!
Thank you so much.
Sent from my iPhone
On Feb 22, 2019, at 8:24 PM, crystal 8 strive4peace2008@yahoo.com <mailto:strive4peace2008@yahoo.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups..com> > wrote:
ps
there are a few more steps too -- the first time you use it in the database (I'm guessing -- or maybe its the form, not sure yet), you actually end up installing the ActiveX control ... what your client didn't want to use, but obviously has to be used ....
there is a link that pops up that you click. I didn't do it yet though because I want to record it when I do
~crystal
On 2/22/2019 7:10 PM, crystal 8 wrote:
hi Patty,
I was wrong, there IS a way. Asked someone else today. You have to change settings in the PDF viewer to allow it to display the PDF in a browser. Use the Shell.Explorer.2 web browser control.
In Foxit, it is:
Preferences, File Associations, check: Display PDF in Browser
~crystal
<anklidhnpnglhnmo.png>
On 2/22/2019 10:27 AM, crystal 8 strive4peace2008@yahoo.com <mailto:strive4peace2008@yahoo.com> [MS_Access_Professionals] wrote:
you're welcome, Patty ~ happy to help
This was something I wanted to know too. I think if it can be done, you would need to use JavaScript, which isn't something I would dig into without a paying client. I did find a link that mentioned using a free JS library ... but whether Access would support it is another story.
~crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
On 2/22/2019 3:10 AM, Patty Mapes patty.mapes@gmail.com <mailto:patty.mapes@gmail.com> [MS_Access_Professionals] wrote:
It is possible that it was 2007. I have had that thought. I need to find out what client is thinking as this is a big gap. They are using this app in an office network as well as smaller version (not split) on laptops for specific remote tasks so I need more info on that aspect of things.
Years ago (20) I had a commercial mob app that I distributed with addition files in the install. Potentially I could do that here if I can run down the activeX file.
You are a great help!
Thank you,
Patty
Sent from my iPhone
On Feb 22, 2019, at 3:18 AM, crystal 8 strive4peace2008@yahoo.com <mailto:strive4peace2008@yahoo.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups..com> > wrote:
hi Patty,
you're welcome
I'm using 2013. It doesn't work -- at least not in the couple hours I tried. I read it quit working in 2010 -- so the version to try would be 2007? Or get the ActiveX control ...
~crystal
-----------
[later responses -- trying to keep everything in the thread]
Patty:
Very interesting. The good news here is I might not be loosing it!
Their original development was done in 2003, but they said they were up to 2013,
Their motivation was get bloat out of the file which didn't entirely make sense to me..
On the machine I have it on it is about 350 MB which they are expecting to reduce to about 20 MB. Which I'm not about to do either. I think I have a lot to learn about 2016.
On Feb 22, 2019, at 12:16 AM, crystal <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups.com> > wrote:
hi Patty,
I also tried showing an HTML file pointing to a PDF using <object> but Access blocks the content because it could be "dangerous" -- so perhaps Microsoft is just keeping us "safe" by not allowing it anymore.
"To help protect your security, your web browser has restricted this file from showing active content that could access your computer"
also tried using <embed> instead of <object> but I couldn't get it to work either
~~~
Displaying a PDF with a Web Browser Control might still work with Access 2007.
Sorry I don't have better news for you. I did some searching and others are disappointed this doesn't work anymore too.
~crystal
-----------------------------
On 2/22/2019 1:36 AM, Patty [MS_Access_Professionals] wrote:
This is extremely helpful. I was working on a machine that I have 2016 on (2013 previously) . It's 2:30 AM and I've woken up thinking I should try this on a machine with only 2013.
I think I'll take this link and open it on another machine first.
Thank you very much!
Sent from my iPhone
On Feb 21, 2019, at 11:37 PM, crystal [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups.com> > wrote:
hi Patty,
If there is a way to do it, I couldn't figure it out. I do see OLD examples of doing it -- but the web browser control also used to play videos and doesn't do that anymore, so maybe this doesn't work anymore either. Neither web browser control will render a PDF inside Access (not saying it isn't possible, just that I couldn't do it -- if you figure it out, share!) You can try it yourself and show the client. There is a sample database here:
http://www.msaccessgurus.com/tool/WebBrowserControl/WebBrowserControl_DisplayImages_s4p.zip
This example was created to show how to display images on the web in Access, but you can add another record (in the only table that is there) with the path and filename of a PDF, or the URL of a PDF.
There are 2 forms, one for each of the web browser control types you can create.
Now if the client wants to convert PDFs to JPG, PNG, or other image format, it could work this way ...
have an awesome day,
crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
On 2/21/2019 9:17 PM, Patty Mapes patty.mapes@gmail.com <mailto:patty.mapes@gmail.com> [MS_Access_Professionals] wrote:
Sadly, the client is insisting on using MS Web browser. I'm so stuck!
Sent from my iPhone
On Feb 21, 2019, at 7:19 PM, crystal 8 strive4peace2008@yahoo.com <mailto:strive4peace2008@yahoo.com> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups..com> > wrote:
you're welcome, Patty. Please let us know if this works for you
~crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
On 2/21/2019 6:08 PM, Patty Mapes patty.mapes@gmail.com <mailto:patty.mapes@gmail.com> [MS_Access_Professionals] wrote:
I will look at this!
Thank you!
Sent from my iPhone
On Feb 21, 2019, at 6:55 PM, crystal [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups.com> > wrote:
hi Patty,
perhaps the ActiveX control from Foxit reader?
https://developers.foxitsoftware.com/kb/article/use-foxit-activex-visual-basic-application/
https://developers.foxitsoftware.com/pdf-sdk/windows/activex/
~crystal
On 2/21/2019 3:41 PM, Patricia Mapes patty.mapes@gmail.com <mailto:patty..mapes@gmail.com>
[MS_Access_Professionals] wrote:
> This used to be done with the adobe activeX control but that is no longer available.
> I am new to this project and I've been pulling my hair out over this.
>
> I can open a pdf (in adobe reader) but that is not the requirement. It does help me know that I have the path, etc. In this case I'm using "Application.FollowHyperlink Me.Documents_Subform_List.Form.DocLocation,,True,False"
>
> Q1 - All the MS documentation says to open form in Layout view, add the (activeX control?) and then click on the control and it will open "Insert Hyperlink.
> When I go to layout view I can only see "Use Control Wizards" and it will not open or display any wizard. Does anyone else have this experience?
>
> Q2 If I go to design view, I can add the activeX control "Microsoft Web Browser" which is what the client specified, but I have tried many ways to get it to find my pdf but it will not.
> Does anyone know how to do this?
>
> I'm using Win8 MS Access 2016.
>
> If anyone can help I will be very grateful!
>
> Thank you,
>
> Patty Mapes
>
>
>
>
>
> ------------------------------------
> Posted by: Patricia Mapes <patty.mapes@gmail.com <mailto:patty.mapes@gmail.com> >
> ------------------------------------
>
>
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
[Non-text portions of this message have been removed]
Posted by: <patty.mapes@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (19) |
Tidak ada komentar:
Posting Komentar