Alison Balter's Mastering Access 2002 Enterprise Development

Practical Examples: Using Transaction Processing to Improve the Integrity of Your Applications

As you continue to develop your own applications, you might find it necessary to use VBA code to accomplish certain tasks. These tasks might require that several processes complete successfully or not at all. As these situations arise, you should consider placing them in a transaction loop. An example of such a situation is the frmArchivePayments form, as shown in Figure 16.1. frmArchivePayments enables the user to specify a date range. The code uses this date range as the criterion to determine what data it sends to the tblPaymentsArchive table and removes from the tblPayments table. When the user runs the process, you want to ensure that the process ...