Category Archives: VBA
Invisible Forms Revisited: Park Your Global Values Here
Back in Feb-2003, Tobi Hoffman wrote an article about using invisible forms in conjunction with Citrix or Terminal Services based Access databases. Since then, Tobi has discovered that adding an invisible form to your application can make a number of … Continue reading
Hide Your Input, and it’s Pretty Common
This month, Doug Steele looks at how you can enhance the built-in InputBox, as well as how to programmatically call a couple of the standard Windows dialogs (the Color and Font dialogs). Is there any way that I can use … Continue reading
Handling Quotations
This month, Doug Steele shows one way to add shortcuts to your application, demonstrates how to handle embedded quotes in SQL statements, and provides a quick documenter to list the objects in your application. See the rest of the Access … Continue reading
Handling Print Layout
Your users like to have some flexibility in how they get their printed data–but they give up the ability to modify printer settings when you compile or secure your applications. Or do they have to? Russell Sinclair takes a look … Continue reading
Fuzzy Dates
This month, Rebecca Riordan strays from the subject of building interfaces in Access to look at the subject of handling dates. She begins by examining the DateTime data type and the joys of VBA date functions, but the core of … Continue reading