The original error "Access Denied" is triggered when VBA tries to execute the below call. I am not fully certain how running it through the Document Object Model would assist. Please note that at medium IE 11 security settings I don't experience any errors on my machine running the same OS...
vbaInet,
The error thrown on my machine is thrown by IE not MS Access. The dialog is an IE dialog. The error that my users experience which I cannot reproduce is displayed in a standard VBA msgbox. I don't believe the javascript even executes on the user's machines but in my case it does.
I disabled every scripting setting in IE 11 and surprisingly the JavaScript starts but I get the same error as on High settings shortly after the JavaScript executes. That is not what I expected.
My IE 11 security settings were on Medium and there was no problem executing the JavaScript from VBA. When I put the Security settings on High I did get an error but it was thrown from within the Script meaning the script executed.
The original error is thrown by VBA and the script doesn't...
It happens on some Windows 7 Pro machines but generally works on Windows 7 Pro Machines. I am going to play around with IE security settings to see if I can reproduce the error on my Windows 7 Machine. I get very little time with the machines that actually generate the error since they are on...
I wrote the JavaScript. It's embedded in an HTML file that I created which is embedded in a Web Browser Control on an MS Access form. Typically there is no issue but on some machines I get the mentioned error.
On some machines I receive the Error: "Access is Denied" Error #: -2147024891 when initiating JavaScript from within VBA.
Call Forms("frmMap").WebBrowser.Document.parentWindow.execScript("initialize()", "", "JavaScript")
Is this a security setting in Internet Explorer ? I don't have much...
Hello Access Expert,
I would like to place an image file located at e.g. "C:\MyImages\image.png" into the clipboard. I have not been able to figure out how to do this. I have been able to place Text into the Clipboard using the DataObject late binding sub below.
Thank you
Public Sub...
Thank you for your response.
1. Interesting I never thought of that.
2. I actually did. I used the forum search function and didn't find anything.
3. I am using Access 2007. Does it only work in 2010?
Thanks
Hello Access Expert.
I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map.
I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do...
Sorry for the confusion.
I have been able to figure out how to Filter the Selections by using the Where argument in the Docmd.
The only thing missing now is being to Select All once the Pivot Chart Form is open.
Thank you.
JHB,
The Selecting all items can be done once the Pivot Chart form is open.
The Selecting All Code can even reside in the form that opened the Pivot Chart form.
I am looking for something like this.
frm.ChartSpace.PivotFields("Waste Class").ShowAllItems = True
Pr2. Thanks for that link. I was hopeful that it would work but Call fSetAccessWindow(SW_SHOWMAXIMIZED) did not set the focus back to Access for some reason.
Since every user will have IE installed I decided to use the following solution.
Set objIEapp =...
Hello,
In my VBA I open the default browser using the following code.
Application.FollowHyperlink "http://www.google.com", , False
Right after opening the browser I would like Focus to go back to Access.
How can I do this?
Thank you
RandomCoder,
I am just looking at your solution. I am running it in Access 2007. The functionality is very good and the code is very well documented.
Thank you for providing this solution. I don't believe you implemented the feature I am looking for in your example but I will keep studying...
Hi RandomCoder
Can you check out my PivotChart VBA question below? I have downloaded your solution and will also look for the answer there.
Thank you
http://www.access-programmers.co.uk/forums/showthread.php?t=257010