IN THE SPOTLIGHT: MDE to MDB Conversion Service
(also supports: ACCDE to ACCDB, ADE to ADP, etc)
IN THE SPOTLIGHT: vbWatchdog
VBA error handling just got easier...
" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "
- Joe Anderson,
Microsoft Access MVP
Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)
IN THE SPOTLIGHT: vbMAPI
An Outlook / MAPI code library for VBA, .NET and C# projects
Get emails out to your customers reliably, and without hassle, every single time.
Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.
The Global Error Handler is provided as a single DLL library - the filename is VBAGlobalErrorHandler.dll.
This DLL can be found on your computer in '%PROGRAM FILES%\EverythingAccess.com\VBA Global Error Handler\' (unless you changed the installation directory)
When developing using the SimplyVBA Global Error Handler the DLL must be properly installed. The DLL does not need to be "installed" for clients - you can take advantage of the registry-free installation option instead which makes distributing applications made with this product much easier - see Registry-free client installation (DISTRIBUTABLE EDITIONS ONLY).
We provide you with a simple Setup.exe application that handles the full installation of the DLL - it is available for download here.
Once installed, the library will be available from your VBA references window.
(Tip: Press the S key on your keyboard when in the References window to scroll down to the libraries starting with the letter S)
If you've purchased a DISTRIBUTABLE EDITION of SimplyVBA Global Error handler, then you are allowed to include the VBAGlobalErrorHandler.dll in a packaged install routine for when releasing your products.
Simply copy the VBAGlobalErrorHandler.dll from your Distributable edition over during your installation routine and then register the DLL in the normal way (using regsvr32.exe).
Remember though that you are not allowed to include the DEVELOPER EDITION of the .DLL in any packaged installation since you are not allowed to redistribute that version of the DLL. You must first purchase a DISTRIBUTABLE EDITION.
Any questions regarding licensing should be put to our sales team: email@example.com
If you need to distribute the DLL to clients that don't necessarily have administrative permissions to install a COM DLL Library, we give you another neat solution.
Simply distribute the DLL file in the same folder as your application .MDB / .MDE file and go to the Add-Ins menu in your VBA IDE as follows:
>> Add-Ins >> SimplyVBA Global Error Handler >> Setup installation-free DLL support
This will add four class modules to your VBA project called ErrEx, ErrExCallStack, ErrExDialogOptions and ErrExVariables. You need not worry at all about these modules - simply understand that they provide late-binding support to the DLL.
This method of installation provides exactly the same functionality as having the normal COM reference, but doesn't require any form of installation (... apart from copying over the DLL to the same directory as your Access project). This completely avoids permission related installation problems and Vista elevation messages. "DLL Hell" no more!