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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment

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

Posted in VBA | Leave a comment