VBA – Creating an HTML Document

I made a couple recent posts regrading mapping, encoding, decoding, all web related stuff

Access - Google Maps Basics

This is the first in a series of articles on Mapping within Access using the Web Browser control. Today, I thought I’d demonstrate how easy it is to provide a map of an address to your users using Google Maps.

VBA - URL Encode, URI Encode

After presenting a couple recent articles on mapping in which we build up a URL and then needed to replace certain characters to make it compatible with Google/Bing… I thought I’d share a couple functions that can do this more efficiently and perform URL/URI encoding.

VBA - HTML Encode and Decode String

So in my previous post I demonstrated a couple techniques to encode/decode a URL/URI. Today, I thought I’d demonstrate how easy it is to encode a text string into HTML with the proper HTML entities for special characters, and decode an HTML string back to plain text.

so I thought I’d demonstrate how one can use VBA to dynamically create, or manipulate, an HTML document.

Creating a MSHTML HTML Document via VBA

Continue reading →

VBA – URL Decode, URI Decode

In my previous article

VBA - URL Encode, URI Encode

I demonstrated how we could easily encode a URI/URL, taking

https://www.bing.com/maps/?v=2&where1=Mount Rushmore National Memorial,13000 SD Highway 244, Keystone, SD, United States

and, depending on the technique used, returning

https://www.bing.com/maps/?v=2&where1=Mount%20Rushmore%20National%20Memorial,13000%20SD%20Highway%20244,%20Keystone,%20SD,%20United%20States

https%3A%2F%2Fwww.bing.com%2Fmaps%2F%3Fv%3D2%26where1%3DMount%20Rushmore%20National%20Memorial%2C13000%20SD%20Highway%20244%2C%20Keystone%2C%20SD%2C%20United%20States

Today, I thought it wise to explore how we can do the inverse, that is decode and HTML URI/URL back to plain text.

Continue reading →

VBA – HTML Encode and Decode String

So in my previous post

VBA - URL Encode, URI Encode, URL Decode, URI Decode

I demonstrated a couple techniques to encode/decode a URL/URI.

Today, I thought I’d demonstrate how easy it is to encode a text string into HTML with the proper HTML entities for special characters, and decode an HTML string back to plain text.

Continue reading →

VBA – URL Encode, URI Encode

After presenting a couple recent articles on mapping

Access - Google Maps Basics

Access – Bing Maps Basics

After demonstrating how easy it was to use Google Maps to display a map of an Address or Geolocation coordinates in my article I wanted to demonstrate that the same was true for mapping with Microsoft Bing Maps.

in which we build up a URL and then needed to replace certain characters to make it compatible with Google/Bing… I thought I’d share a couple functions that can do this more efficiently and perform URL/URI encoding.

Continue reading →

Microsoft Access– Adding a Progress Bar

I recently wrote a couple articles about integrating progress bars into application:

Excel (using Conditional Formatting)

Excel - Adding a Progress Bar

I was recently doing some work for a client in which I build an Excel WorkBook that processed a series of large CSV files to clean them up, format the content, … because of their size the process could take several minutes and they contacted me thinking it wasn’t working and that they thought the…

Continue reading →

MS Office (using a Userform)

Microsoft Office – Adding a Progress Bar

So a few days ago I published an article about using conditional formatting to create a progress bar in an Excel Worksheet to display, in real-time, the progress of some process to your users. You can read all the details at: That said, I then pushed a little further to create a reusable progress bar…

Continue reading →

Since Microsoft Access is unique in that is has it’s own native forms, today I would like to demonstrate how we can create a standard form and with a little ingenuity and VBA code, we can create a simple, reusable progress bar to display the progress of iterative and/or multi-step processes.

Continue reading →

Access – Bing Maps Basics

After demonstrating how easy it was to use Google Maps to display a map of an Address or Geolocation coordinates in my article

Access - Google Maps Basics

I wanted to demonstrate that the same was true for mapping with Microsoft Bing Maps.

Continue reading →

Microsoft ODBC SQL Server Broken!

Yep, another round of updates, another database issue. This time it’s a doozy potentially breaking Microsoft ODBC SQL Server.

Database connections using Microsoft ODBC SQL Server driver might fail.
Apps using ODBC connections might fail to connect to databases.Microsoft

After installing KB5019980, apps which use ODBC connections utilizing the Microsoft ODBC SQL Server Driver (sqlsrv32.dll) to access databases might fail to connect. You might receive an error within the app or you might receive an error from SQL Server, such as “The EMS System encountered a problem” with “Message: [Microsoft][ODBC SQL Server Driver] Protocol error in TDS Stream” or “Message: [Microsoft][ODBC SQL Server Driver]Unknown token received from SQL Server”.Microsoft

Continue reading →

Access – Google Maps Basics

Emulation Mode

Do note that Google Maps, as of the date of publishing this article, requires a Web Browser Feature Browser Emulation of IE11 or later, so 11000+. If you’re not familiar with this, I urge you to quickly look over:

Microsoft Access WebBrowser Control | DEVelopers HUT

Everything You Never Wanted to Know About the Microsoft Access WebBrowser Control. The ins and outs of working with Access’ WebBrowser control.

Continue reading →

Microsoft Office – Adding a Progress Bar

Excel - Adding a Progress Bar

Continue reading →

That said, I then pushed a little further to create a reusable progress bar utilizing a Userform that could be incorporated within any Microsoft Office application and that works as a pop-up overlay to display the progress of a process.

Continue reading →

The Site Ahead May Contain Harmful Programs

I wanted to properly document a recent problem I experienced with Google which I briefly mentioned in my post:

The Day I Stopped Using FireFox

So yesterday, I received a nice notification from Google: Side note: GMail report Google’s own e-mail to me as “This message seems dangerous”! Once Google did this, my webpage via Firefox started to load to:

I am hoping that I can provide a few links and help others in a similar position as Google offers no easy way to locate this information. At least I found it very difficult to find truly helpful information.

Continue reading →