MS Access VBA: Get/set Javascript Variable in Microsoft Web Browser ActiveX Control

Comments

13 responses to “MS Access VBA: Get/set Javascript Variable in Microsoft Web Browser ActiveX Control”

1. 

   Stef
   June 10, 2020

   Thank you for this explanation. But how would i populate a table with data? Can i send a JSON object?

   Reply
   1. 

      Vishal Monpara
      June 10, 2020

      Hi Stef,

      You can definitely send JSON object. Please note that Web Browser control may use IE 7 rendering regardless of which IE is installed on your computer. So certain JSON functions may not be available natively. You may need to use polyfill JavaScript.

      Regards,
      Vishal Monpara

      Reply
2. 

   Jeet
   August 28, 2015

   To resolve this error: Run time error. Access Denied: -2147024891 (80070005)
   You need to run the Access exe with Admin privileges.
   This is a very common issue with browser automation.

   Reply
3. 

   Raju
   April 10, 2014

   Hi,

   I am sucked in a point in macro, I am trying to record macro for Internet explorer. I have open a internet explorer and there is a radio button I have selected the same and submit the page and got some options in which I want to select one and open the same but there is problem it is in java script, so I am not able to open it how get it open if any one please help me to open it.

   Plesssss helppppppppp…….

   Reply
4. 

   Chris Read
   January 21, 2014

   Cracking little work around. I’ll be using this technique to obtain polygon selections made on a Google Map API FusionsTableLayer, embedded in a webpage.

   Cheers!

   Reply
5. 

   Vishal
   March 27, 2013

   @Lamar Washington
   Make sure that you have injected javascript function checkAll in the page. Otherwise, it will say that checkAll is undefined.

   Reply
6. 

   Lamar Washington
   March 27, 2013

   The function looks like this:

   function checkAll(controlObj)
   {
   var check =new Array();
   check = document.getElementsByName(‘incident’);

   for(var i=0;i<check.length;i++)
   {
   check[i].checked = controlObj.checked;
   }
   }

   The error message indicates checkAll is undefined

   Reply
7. 

   Lamar Washington
   March 25, 2013

   UPDATE:
   The calling onclick looks like this:

   The function looks like this:The function looks like this (this was provided by Phil):

   function checkAll(controlObj)
   {
   var check =new Array();
   check = document.getElementsByName(‘incident’);

   for(var i=0;i<check.length;i++)
   {
   check[i].checked = controlObj.checked;
   }
   }

   When the checkbox with the onclick event is clicked the error message indicates an unknown variable which is the function name checkAll.
   It seems as if the webbrowser control is not recognizing the jscript function

   Reply
8. 

   Lamar Washington
   March 25, 2013

   Thanks, I see how a javascript variable can be set and retrieved. Thank you very much.
   In this case I’ve injected a jscript function into the rendered HTML, added a series of checkboxes with the same name, added an onclick event to the main checkbox pointing to the function. The function simply sets all the checkbox’s to the same state as the clicked checkbox:
   I am using the msaccess webbrowser control to display and run captured html, added html components (checkboxes) and javascript. The rendered html works perfectly. However, in the control the javascript is not working at all. I don’t think the webbrowser control knows what to do with the js. I have a particular html checkbox with an onclick event calling the js function ‘allCheck(this)’. When I click on the checkbox the js is supposed to set all the other check boxes to the same state as the one calling. When I load the html and js in the IE10 browser (using a local file) everything works normally including the js. When I try to execute the same text in the webbrowser control (not loaded from a local file but generated within the program) the HTML is rendered correctly but when clicking the checkbox with the ‘onclick’ event the error message:

   “The value of the property is null or undefined, not a Function object” results.

   It seems the webbrowser control is unaware of the js between the and html tags.

   The calling ‘onclick’ looks like this:

   CODE –>

   The function looks like this (this was provided by Phil):

   CODE –>

   function checkAll(controlObj)
   {
   var check =new Array();
   check = document.getElementsByName(‘incident’);

   for(var i=0;i<check.length;i++)
   {
   check[i].checked = controlObj.checked;
   }
   }

   I appreciate any input as to why the webbrowser control is not processing the js and what I can do to enable it. Or if the control just cannot do this is there a web browser control that does, preferably free?

   Thanks,

   Reply
9. 

   flyingscot
   October 25, 2012

   This post rocks! Great sample code – works in Access 2007.

   Reply
10. 

    James
    June 5, 2012

    I see the same error: access Denied. This worked for me before in Access 2007 but I recently upgraded to 2010 and the error is popping up.

    Reply
11. 

    sayed abas
    February 14, 2012

    I see this error
    Run time error. Access Denied: -2147024891 (80070005)
    Can you help me?

    Reply
12. 

    Pere
    June 28, 2011

    Looks nice.
    Do you know an easy way to solve de error situation on calling the java functions?
    Say: Run time error. Access Denied: -2147024891 (80070005)

    Thanks

    Reply