Microsoft® Office Access 2003 Inside Out

Some Complex Visual Basic Examples

A good way to learn Visual Basic techniques is to study complex code that has been developed and tested by someone else. In the LawTrack Contacts and Housing Reservations sample databases, you can find dozens of examples of complex Visual Basic code that perform various tasks. The following sections describe two of the more interesting ones in detail.

A Procedure to Randomly Load Data

You’ve probably noticed a lot of sample data in both the LawTrack Contacts and Housing Reservations databases. No, I didn’t sit at my keyboard for hours entering sample data! Instead, I built a Visual Basic procedure that accepts some parameters entered on a form. In both databases, the form to load sample data is saved as zfrmLoadData ...