Throwback Thursday: August 22, 2024

Today's edition is all about controlling how and where Access forms open on your screen.

Throwback Thursday: August 22, 2024

With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.

That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.


Highlights from NoLongerSet.com

6 Techniques to Control Where Forms Open On-Screen in Access
With Overlapping Windows in Access, you need to think about where each form should open on-screen for the user. Here are 6 techniques to help you do that.
Fun with Form Windows
Using my FillAccessWindow function to resize Form and Report objects relative to the amount of available space on the Access canvas.
KeepFormOnCanvas(): Get Back Here, Form!
What happens if the user resizes their Access window so that our form can’t open in its entirety? KeepFormOnCanvas() to the rescue!
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.
CascadeForm(): Prevent Multi-Instance Forms From Hiding Behind Each Other
The CascadeForm() function introduces the cascading-window effect from the Windows operating system to Microsoft Access.

Wisdom from Around the Web

Microsoft Access tips: Managing Multiple Instances of a Form
How to open more than one instance of a form at once in a Microsoft Access database, and manage the instances independently of each other.

Developer Humor

Cover image generated by Ideogram

All original code samples by Mike Wolfe are licensed under CC BY 4.0