Search results

Here are the steps to import the "lazy-loading" combo box feature: Import the weComboLookup class module code from this article Add the following to the form's code-behind module: Private ComboLookup As New weComboLookup Private Sub Form_Load() Const MinimumFilterTextLength As Integer = 3...

Here's a link to my article that has a downloadable sample database with all the code that I demonstrate in the video: Advanced Combo Box Techniques

And this is why the reports of Access's death are greatly exaggerated.

The problem with disconnecting labels from their associated text boxes is that you break other functionality. Namely, you can no longer click on the label and have the focus automatically go to the text box. I think the best solution, in this case, is a transparent command button. I use them...

I figured as much. Thanks for confirming (and updating my post to a working link).

Yep. So far, it's all me. If I publish other authors in the future, they will get their own byline and author page.

Yep, that scenario should work fine. It's the library integration that will bite you. There have been numerous stability increases over the past few months. There are probably still some remaining issues that will prevent you from copying and pasting large VBA/VB6 code files, but those have...

You can compile and run 32-bit twinBASIC projects on a 64-bit machine. You just can't reference a 32-bit twinBASIC library (.dll) from a 64-bit version of VBA/Office.

Also, to be clear, I don't have any official ties to the twinBASIC project. I'm a long-time vbWatchdog user (another of Wayne Phillips's projects). I just happened to start writing a daily blog on Access and VBA about 4 months before Wayne was set to announce twinBASIC. He asked if I would...

The article wasn't really intended as a plug for twinBASIC. In fact, the whole thing started as an aside about how hard it is to find in-depth info about VBA because Microsoft has largely ignored it for nigh on 20 years. The short aside turned into a couple of paragraphs. Before I knew it...

Hi all! My name is Mike Wolfe. I write daily articles about Microsoft Access and VBA at:- https://nolongerset.com/ I'm a 2002 graduate of the US Military Academy at West Point. I served 5 years as an active-duty Army officer. Since 2007, I've been a professional software developer...