Category Archives: VBA

Save Yourself Some Work

This month, Doug Steele looks at an undocumented feature within Access that allows you to save Access objects as text files. Access allows you to save the code associated with a form or module as a text file. Is there … Continue reading

Posted in VBA | Leave a comment

Read this to feel PtrSafe about Office 64 Bit compatibility

If you write Microsoft Access databases with basic VBA code and no fancy Windows calls, you will find your database will run with Office 32 bit and Office 64 bit with no problems. But if you have used fancy windows … Continue reading

Posted in VBA | 1 Comment

Put XML to Use in Access 2002

You’ve heard that XML is easy to import and export from Access 2002, but you have yet to come up with a good use for it. Danny Lesandrini solves two problems with Access 2002’s XML support: dynamic file linking and … Continue reading

Posted in VBA | Leave a comment

Properties Without Fear

If you aren’t using DAO’s ability to create new properties, perhaps you should be. Gary outlines a couple of very interesting ways to use this facility to give you more powerful applications. A simple way to improve your products is … Continue reading

Posted in VBA | Leave a comment

Programming WithEvents

By using the WithEvents keyword, you can extend the possibilities of Access’s classes. Marek presents new ideas on programming in Access. In the Access 97 Developer’s Handbook by Litwin, Getz, and Gilbert (Sybex), there’s an example of how to use … Continue reading

Posted in VBA | Leave a comment