Throwback Thursday: August 22, 2024
Today's edition is all about controlling how and where Access forms open on your screen.
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.
Mike Wolfe
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.
Mike Wolfe
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!
Mike Wolfe
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.
Mike Wolfe
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.
Mike Wolfe
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
"A computer will do what you tell it to do, but that may be much different from what you had in mind." – Joseph Weizenbaum
— Programming Wisdom (@CodeWisdom) August 8, 2023
Cover image generated by Ideogram
