Mike Wolfe - No Longer Set (Page 12)

Week in Review: December 30, 2023

Highlights include a 4-part Oasis SVN walkthrough, 3 new Edge browser control videos, VBA class basics, and a deep dive into Access's Filter By Form feature.

Database Design

Common Uses for One-to-One Database Relationships

One-to-one relationships are the red-headed step-children of the relational database world. Here are 25 reasons it doesn't have to be that way.

Form Design

How to Filter Reports in Microsoft Access

Here are 5 ways to filter reports in Microsoft Access, along with a closer look at my personal favorite approach.

UX

18 Tips to Build a Great Report Filtering User Experience in Microsoft Access

A great report filtering UX should be intuitive, consistent, simple, powerful, efficient, and beautiful. Here are 18 tips to help you do just that.

Edge Browser Control

How to Access the .Document Property to Parse Web Pages Using the New Edge Browser Control

The loss of the .Object property in the new Edge browser control is a big blow to web automation in VBA, but a workaround from Daniel Pineault helps fill the gap.

Holiday

Merry Christmas

"The Word became flesh and made his dwelling among us. We have seen his glory, the glory of the one and only Son..."

twinBASIC Weekly Update

twinBASIC Update: December 24, 2023

Highlights include an updated twinBASIC roadmap, a sneak peek at upcoming IDE menu and docking improvements, and RadioMan - a new tB project from fafalone.

Week in Review

Week in Review: December 23, 2023

Highlights include an MZ-Tools tour from developer Carlos Quintero, an Edge browser control video series, and multi-select filtering of a continuous form.

Code Library

How to Set the Background Color of the Microsoft Access Application Window with VBA

A series of Windows API calls will "repaint" the Microsoft Access canvas with the color of your choice. It is a bit rough around the edges, though...

Announcement

Dropping `#If VBA7 Then` From API Declares

Plus, step-by-step instructions for restoring the `#If VBA7 Then` code construct if you still need to support Office 2007 or earlier.

Debugging

FIXED: "You entered an expression that has no value."

"You entered an expression that has no value," is a common Microsoft Access error message. Luckily, while the fix is not obvious, it is easy.

Tools

Poe: My Tool of Choice for Exploring the World of LLMs

With so many new and exciting LLMs and AI image generators, how do you pick just one? What if you didn't have to?

AI

"AI Will Take My Job": A Self-Fulfilling Prophecy

Whether you think AI is coming to *take* your job... Or you think AI will help you *be more productive* at your job... You're probably right.

twinBASIC Weekly Update

twinBASIC Update: December 17, 2023

Highlights include a new twinBASIC project to allow easy input filtering of text boxes and the renaming of the tbShellLib project to reflect its expanded scope.

Week in Review

Week in Review: December 16, 2023

Highlights include my recent talk on using classes with import/export specs, many 64-bit VBA guides, and a new release of Adam Waller's version control add-in.

VBA

32-bit vs. 64-bit VBA: Deep Dive

A deep dive into the past, present, and future of the transition from 32-bit VBA to 64-bit VBA.

Code Library

GetCanvas(): Convenience Function for Working with Windows API Calls in Access

This simple function serves as a great foundation for manipulating the display of Microsoft Access forms and reports with a variety of Windows API calls.

Code Library

CenterForm(): Using the Windows API to Center Forms on the Access Canvas

The form Auto-Center property is all you need in most cases. However, let's consider four different situations where my custom code might be a better fit.

Code Library

GetInnerAccessHwnd(): Retrieve the Window Handle to the Microsoft Access Canvas

This function returns the window handle to the Microsoft Access "canvas", the inner portion of the application window where forms and reports are drawn.

VBA

The Curious Case of the Return Type of the hWndAccessApp Method in 64-bit VBA

Is everything I thought I knew about 64-bit vs. 32-bit VBA wrong? Or is there a problem with the Access object model? Or is it something else?

twinBASIC Weekly Update

twinBASIC Update: December 10, 2023

Highlights include an extended discussion on the possibility of open-sourcing some or all of twinBASIC in the future, plus a Linebreak Repair utility from fafalone.

Week in Review

Week in Review: December 9, 2023

Highlights include new (undocumented) functions for working with DateTimeExtended, an AI Builder for Access, and Jon Halder's TDD journey.

Tools

PureText: Paste Unformatted Text From Your Clipboard

Are you tired of the Notepad dance: Copy rich text, paste in Notepad, select all, copy, paste plain text? If so, this simple utility could be life-changing.

VBA

Improve the Readability of Numeric Settings in VBA

In VBA, numeric property settings (such as ComboBox.TextAlign–where 3 = "Right") can be handled in many ways, but some ways are more right than others.

Presentations

clsImExSpecs Presentation to the Access Europe User Group

A list of resources and further reading for my presentation on my custom Import/Export Specifications class module.