Link to home
Start Free TrialLog in
Avatar of Izzy Green
Izzy Green

asked on

MS Access Web Browser Control to save PDF before closing

i have a web browser control in ms access that displays a fallible PDF. How do i save the changes made to the PDF before closing it?
Avatar of PatHartman
PatHartman
Flag of United States of America image

Why are you using a web browser control to open the pdf?  The only way Access could control the save is if you used SendKeys to activate the button on the browser window.

I would use the FollowHyperlink method and use the native .pdf reader.  That way when the user closes the pdf, it will get saved.

Application.FollowHyperlink strInput, , True

strInput = the full path name to ANY file with an extension recognized by windows.
Avatar of Izzy Green
Izzy Green

ASKER

Reason is because its part of as part of a process we need to edit the PDF and and continue with our process. Therefore we cant leave MS Access.
So, you're saying that moving to a new record does n't save the pdf that was modified?
Once i finish filling in whatever needs to be filled in on the PDF i have a button on the form that closes this form ("frmEditApp"). when the form closes it does not save the changes i made to the PDF.
Can you add a save button to the pdf?  If you do, how would it know where to save and what to name the file?
hi Izzy,

is the PDF opening in a PDF reader? Click the save button there, inside the browser window -- or maybe Ctrl-S works too.  Since there is no way Access can know if it is saved or not with this method, it might be better to do as Pat suggested and use Application.FollowHyperlink -- that would make the PDF file easier to read also.

have an awesome day,
crystal
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.