While the techniques listed below are native to Access/VBA and allow the functionality required, in order to make good use of the VBA/JS integration, a bit of a framework needs to be put together. This framework is being actively developed using native Access/VBA and will allow developers to quickly and easily integrate bemb projects into their applications.
(to subscribe to updates to the bemb project, click here)
Essentially, the bemb project allows for any HTML utility to be integrated into your VBA project. A few example use cases are as follows:
- Advanced navigation controls without trying to fight against the current with Access and VBA
IE 11 Emulation w/ the Web Browser Control
The Web Browser control by default runs in IE7 emulation mode, which is typically insufficient for tasks of any substantial means. Usually, we’ll want to use IE11 Emulation mode instead. This involves the setting of some registry values, as fellow Access MVP Daniel Pineault explains in this link (furthermore, use the HKCU root instead of HKLM so users (and your code) don’t require UAC to make the change – thanks to Access MVP Tom van Stiphout for working that out).
A demo video of this process can be found here: Registry Settings
Here it is, the last piece of the tripod. The following MSDN article explains how to create a class module that can be used as an event handler for an HTML element:
Do note that this link refers to VB6, not VBA, and in order to work in VBA requires a bit of a trick to set the default method of a class. Chip Pearson explains here: Setting the Default Member of a Class