Category Archives: MS Access Forms

MS Access Forms

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 – Determine a Label’s Associated Control

I’ve previously posted how we can determine the label which is associated with a control:

MS Access - VBA - Determine a Control's Associated Label
It can become necessary to need to determine the associated label to a given control. It actually is, yet again, very simple to do. Not what I’d call intuitive, but easy once you are aware of the proper synthax to use. To reference a control’s associated label you use the following synthax Me.ControlName.Controls(0) Or Forms!FormName.Form.ControlName.Controls(0)…

Continue reading →

There, in the comments, David asked how we could do the inverse, that is determine the control associated to a given label.  At the time I wasn’t aware of any simple solution, but today Bruce Hulsey was kind enough to share with us that there was indeed a simple solution.  Building upon his statement, below is a function we can use to determine to which control a label is associated:
 
Continue reading →

Update Crosstab Query’s Subform To Reflect New Fields

I recently embedded a query as a subform in another form and encountered an issues.

Here’s the gist of the situation. For a project I was working on, I have a process that updates a tables data. I then use a crosstab query to display it properly (or as the user wants it displayed). The issue being that the fields in the crosstab change with iteration of the process. Thus, it was impossible to build a form since the fields were not constant.

So the solution was to embedded a query directly as a subform.

The Real Issue

The issue I then encountered was that after the process ran, I could requery the query’s subform and the data would indeed update to refelect the latest iteration’s values, but the field that were displayed did not get updated. I tried Requery, Refresh, Repaint, nothing seemed to be able to get the subform to show the proper listing of fields from the source query. Yet, if I opened the query, the fields had indeed been changed.

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 →

A More Modern Date Time Picker

In a recent discussion, someone asked if there were any more modern Date Time Pickers available to implement in their Microsoft Access database. Rightfully, as they stated, most current Date Time Pickers are very much visually stuck in the 80’s.

So I set out to tinker and see what was possible.

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 →