Category Archives: MS Access Forms

MS Access Forms

How to Select and De-Select an Item in a Listbox

Simplifying Data Entry in Microsoft Access: Setting Default Selections in Listboxes

While working on a project for a charity I support, I aimed to streamline data entry by setting a default selected item in a Listbox. Given that 95% of the time, this would be the desired value, it seemed like a simple way to reduce clicks and enhance user experience.

Instead of hardcoding a value directly into the Property Sheet or using VBA, I recalled a subroutine I had developed years ago for a similar purpose. After some digging, I found that routine and decided to enhance it by updating the header and refining the error handler. The result? A more robust solution for selecting or deselecting specific items in a Listbox.
 
Continue reading →

Modern Web Browser Bug Rendering Media with CAPITILIZED Extensions

Software Bug

Here’s another really weird bug with the Modern Web Browser control that was mentioned to me by Juanfran Rodriguez (@juanfranrodriguez), one of my YouTube viewers.

The issue is that if you use a capitalized the file extension used in the Modern Web Browser control’s Control Source, when trying to directly display media, you will get gibberish displayed rather than the actual media.

Continue reading →

Playing Around With Microsoft Access Text Boxes

Today, I thought I’d simply share a few bits of code for things developers often need to do with Text boxes, and a few that I had fun creating just for the sake of seeing how it could be done!

Things like:

  • Positioning the Cursor
  • Selecting Text
  • Inserting Text
  • Retrieving Content
  • And More…

Continue reading →

Control Renaming Event Bug

Software Bug

Since I’m on the subject of Event bugs…

Software Bug
Copying or Cutting a Control Looses Its Events!?
I know, this isn’t anything new, but I still view it as a bug. Why is it if I Cut a control on a form to go and paste it in the same form elsewhere, we loose any associated events? The code remains in the Form module (VBE), just the event property value of [Event Procedure] are lost.

It only makes sense to mention another longstanding bug when renaming controls!  One that I was reminded of by a recent comment on my YouTube channel by Xavier Batlle (@xavierbatlle1828)

Events also are lost when controls are renamed.Xavier Batlle

Continue reading →

Another Bug With The Modern Web Browser Control On a Tab Control

Software Bug

After my recent article regarding the Modern Web Browser control always appearing when placed on a tab control:

Software Bug
Modern Web Browser Flashes When Used On Tab Control - Bug
Well, there’s yet another issue with the Modern Web Browser control! This is one I didn’t find myself, but that one of my viewers brought to my attention via my YouTube channel.

I decided to do a little more testing, as this was one thing I had never explored before, well not with the Modern Web Browser control at least.

Sadly, things went downhill!

Continue reading →

Form and VBA Based Slider Control – Modernizing the Interface

Well, 96% of people indicated that they want to learn more about creating Slider controls.

So, in this post, I start covering the subject by introducing the ‘simplest’ (maybe not quite, but what you would think would be the simplest) slider control built entirely using a couple label controls and a command button.

I will post a few more articles in the coming days that will cover other possibilities:

  • Multi-range slider
  • Legacy Web Browser slider
  • Modern Web Browser slider

Continue reading →

Modernizing the Interface – Sliders

In a push to refresh the Access interface I published a couple articles and videos showing how we could pull HTML menus into Access, add security, control what was accessible by whom, drive the content from tables, …

Modernizing The Microsoft Access Interface!
Some people have asked me what I’ve been working on and so I thought I’d share a sneak peak. Basically, I’ve been working on trying to elevate the Access interface a bit and have been working on a few new menus concepts and thus developing content, demos for my blog and YouTube channel.

Along the same train of thought, I have been exploring trying to simplify data entry and one of those aspects brought me to Sliders!

Instead of needing to switch to the keyboard, simply dragging a slider can simplify data entry.  It also gives a more modern look and feel to an application.

Continue reading →

Table Driven Modern Menus

In a continuation of my article on Improving the Microsoft Access Interface

Modernizing The Microsoft Access Interface!
Some people have asked me what I’ve been working on and so I thought I’d share a sneak peak. Basically, I’ve been working on trying to elevate the Access interface a bit and have been working on a few new menus concepts and thus developing content, demos for my blog and YouTube channel.

I recently released a YouTube video in which I demonstrated how we could take a static menu and switch it to be table/data driven.

Continue reading →