> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Archive Collection: Window Functions
- URL: https://nolongerset.com/archive-window-functions/
- Published: 2024-01-06T18:54:00.000Z
- Updated: 2026-05-08T12:37:55.000Z
- Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Window Functions.
- Author: Mike Wolfe
- Tags: Archive, #Import 2026-05-20 02:59

*I've been writing a daily article here since September 1, 2020; that's over 1,200 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). I'm currently on a family vacation, which makes maintaining this streak a bit...tricky.*

*I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.*

*In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.*

*I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* 

*Enjoy!*

---

## Window Functions

[Fun with Form WindowsUsing my FillAccessWindow function to resize Form and Report objects relative to the amount of available space on the Access canvas.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/building-1245984_1920.jpg)](https://nolongerset.com/fun-with-form-windows/)

[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!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/rodeo-500570_1920.jpg)](https://nolongerset.com/get-back-here-form/)

[Get a Handle on Window StateUsing the IsZoomed and IsIconic API calls to return the window state (minimized, maximized, or restored) of a form, report, or Access itself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/12/window-4041891_1920.jpg)](https://nolongerset.com/get-a-handle-on-window-state/)

[UseHand(): Changing the Mouse Cursor in Microsoft AccessA classic Microsoft Access mouse cursor trick gets simplified and updated for 64-bit VBA compatibility.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/09/UseHand-1-.jpg)](https://nolongerset.com/usehand/)

[CascadeForm(): Prevent Multi-Instance Forms From Hiding Behind Each OtherThe CascadeForm() function introduces the cascading-window effect from the Windows operating system to Microsoft Access.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/07/CascadeForm.jpg)](https://nolongerset.com/cascadeform/)

[CenterForm(): Using the Windows API to Center Forms on the Access CanvasThe 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.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/12/CenterForm.jpg)](https://nolongerset.com/centerform/)

[How to Set the Background Color of the Microsoft Access Application Window with VBAA 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...![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/12/SetCanvasBgColor.jpg)](https://nolongerset.com/setcanvasbgcolor/)

### Additional Reading

[Code LibraryBuilding Your LibraryThirteen years ago, I chose to maintain a folder of textfiles rather than a single Access database library. I’ve never once regrettedthat decision.No Longer SetMike Wolfe \[https://nolongerset.com/building-your-library/\]TheDependency TrainLet’s torture a train metaphor to illu…![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/prague-980732_1920.jpg)](https://nolongerset.com/code-library/#hash-windowfunctions)