• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Transaction Processing > Practical Examples: Improving the Integrit...

Practical Examples: Improving the Integrity of the Time and Billing Application Using Transaction Processing

As you continue to develop the Time and Billing application, 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 22.1. frmArchivePayments enables the user to specify a date range. This date range is used as the criterion to determine what data is sent to the tblPaymentsArchive table and removed from the tblPayments table. When this process is run, you want to ensure that the process runs in its entirety or not at all. Listing 22.7 shows transaction loop code suitable for Time and Billing.

Figure 22.1. The frmArchivePayments form enables the user to specify a date range of payments to be archived.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint