Category Archives: MS Access Reports

MS Access Reports

Advanced Automation With The New Access Modern Web Browser Control

In my previous posting on the subject:

Access Modern Web Browser Control
Everything You Never Wanted to Know About the Access Modern Web Browser Control
So, we have a new ‘Modern’ Web Browser control, some people have also referred to it as the Edge Web Browser control! …

Continue reading →

I demonstrated a couple times how to extract specific items from a active web page. This is done by using the RetrieveJavascriptValue method to execute the specified JavaScript command and we do this over, and over, and over…

That said, this is no way to do proper parsing. Don’t get me wrong, it could be done, but it is ugly and inefficient. For 1 element it is fine, but not if you’re trying to breakdown a page, extract lots of elements…, well that’s a different story.

Continue reading →

Everything You Never Wanted to Know About the Access Modern Web Browser Control

Access Modern Web Browser Control

So, we have a new ‘Modern’ Web Browser control, some people have also referred to it as the Edge Web Browser control! Well that is if you are running MS365 and using the BETA or Current Update Channels running build 16.0.16327.20214 or greater.

Access Ribbon Controls

You can check out the complete Modern Web Browser release cycle by reviewing:

Modern Web Browser Release Cycle
Recently, on my YouTube channel, @user-do9yi7gs4u asked when the Modern Web Browser would be available for Enterprise users.

I thought, I would start documenting the new ‘Modern’ Web Browser control, like I had done for its predecessor:

Everything You Never Wanted to Know About the Access WebBrowser Control
The Access WebBrowser control is one of the greatest and most frustrating controls available to any Access developer! The beauty of this control is it enables you to gain the power of the web within your database. On the other hand, I have found it very frustrating to program as many properties/methods available to the…

Continue reading →

 
Continue reading →

Access – Buttons Won’t Print

I was working on a report recently and my client wanted to include some buttons (this isn’t something that I commonly do).

So I set everything up and show them the mock-up and everyone was happy.

Then we tested it out by printing it! Nothing appeared, no buttons?!

No problem, there’s a setting for that, I’ve seen it. So I went into design mode and found the “Display When” property, but to my amazement it was already set to “Always”?!?!!?

 

Continue reading →

Access – Controlling A Label’s Trailing Colon

In my recent YouTube video:

I demonstrate how we can set Access to include, or not, trailing colons for text box associated labels.

Now this is great when doing new development, but what about when we take over an existing project and we want to update and standardize things?!

Have no fear, the solution is hear!
 
Continue reading →

Access – New Modern Web Browser Control

Microsoft Access New Modern Web Browser Control

At one point in time the New (Modern) Web Browser Control was scheduled for General Availability (GA) for October 2021. Then it was pushed back to September 2022. Then it was removed from the Roadmap altogether! Recently, it reappeared with a GA date of March 2023 and then a second entry appeared stating April 2023. I guess it got pushed back again, but the previous entry wasn’t removed.

Well, I finally have some good news! No really.

Continue reading →

Access – VBA – Close All Open Objects

So after posting about closing individual objects:

Access - VBA - Close All Open Tables
Have you ever needed to close any and all open tables? Ensure that no tables are still open? It is remarkably easy to do!  
Access – VBA – Close All Open Queries
Continuing down the same path as my previous post: I thought I’d share a simple function to close any and all open queries. The concept is the same in that we loop through all the queries (CurrentData.AllQueries), check to see if each one is loaded (IsLoaded), and if so, close them (DoCmd.Close).
MS Access - VBA - Close All Open Forms
In some cases it may be useful to close all the forms within a database. Why you might ask, one example would be to ensure you close all connection to the back-end prior to working with it.
Access – VBA – Close All Open Reports
Similar to my previous couple of posts: I thought I’d present a function to close all the open reports within a database. The code is slightly simpler that the 2 previous posts as we can use the Reports property which returns a list of only the open reports.  Thus we don’t need to validate whether…

Continue reading →

Access – VBA – Close All Open Macros
Once again, a continuation of my recent posts: … In this post, I’d like to present another function which will close all the currently open Macros within the current database.

I thought it simply made sense to create a single procedure that did it all.
 
Continue reading →

Access – VBA – Close All Open Reports

Similar to my previous couple of posts:

Access - VBA - Close All Open Tables
Have you ever needed to close any and all open tables? Ensure that no tables are still open? It is remarkably easy to do!  
Access – VBA – Close All Open Queries
Continuing down the same path as my previous post: I thought I’d share a simple function to close any and all open queries. The concept is the same in that we loop through all the queries (CurrentData.AllQueries), check to see if each one is loaded (IsLoaded), and if so, close them (DoCmd.Close).

I thought I’d present a function to close all the open reports within a database.

The code is slightly simpler that the 2 previous posts as we can use the Reports property which returns a list of only the open reports.  Thus we don’t need to validate whether the report is loaded or not.

Continue reading →

Access – VBA – Convert ControlType to Name

If ever you created code to loop over controls to identify their type (.ControlType), if you’re like me, at times, you wanted to report the data in English, not as numbers.

It’s nice to know the ControlType is 104, but what the hell does that truly mean?!

So then you go looking through the Object Browser and eventually review the AcControlType Enum to find out that 104 = “Command Button”.

Now, while it is pleasant to do this manually every time, we need to automate this for our sanity.

Need not worry, we can simply create a simple function like:

Continue reading →

Access – VBA – Find Images In Forms and Reports

Experienced developers know that we always want to minimize the file size of a database so it loads faster.  We always want to squeeze the most performance out of every element and also ensure we never near Microsoft Access’ 2GB file size limit.

To that end, whenever I am asked to look over a database, one aspect I always review is the use of images.  Novice developers often insert images without first resizing them for their use within the database.

For instance, I’ve shrunk a db by over 250MB just by resizing 3 images! In that specific instance, I reduced the database by 1.2GB once I had properly optimized all the images within the database. So this can have huge implications.

Continue reading →