Microsoft Access 2010 Bible

Chapter 23: Handling Errors and Exceptions 833 l (^) VBA procedures often open recordsets, establish object variables, and perfo ...

Part III: More-Advanced Access Techniques 834 If the user selects the Yes button (vbYes), the Resume statement forces processing ...

Chapter 23: Handling Errors and Exceptions 835 Note When using error traps, one option is to redirect processing to an error tra ...

Part III: More-Advanced Access Techniques 836 The Error event Access provides a special Error event when running a bound form or ...

Chapter 23: Handling Errors and Exceptions 837 This particular error-handling routine traps the errors on a bound form that occu ...

Part III: More-Advanced Access Techniques 838 ‘Insert your code here ExitHere: Exit Sub HandleError: If cnn.Errors.Count > 0 ...

Part IV Professional Database Development IN THIS PART Chapter 24 Optimizing Access Applications Chapter 25 Advanced Data Access ...

30_475348-pp04.indd 84030_475348-pp04.indd 840 4/1/10 1:55 PM4/1/10 1:55 PM ...

841 CHAPTER Optimizing Access Applications IN THIS CHAPTER Taking advantage of VBA’s Load on Demand functionality Deciding which ...

Part IV: Professional Database Development 842 early versions of Access, on-demand loading of modules wasn’t fully realized beca ...

Chapter 24: Optimizing Access Applications .............................................................................. 843 A ...

Part IV: Professional Database Development 844 procedure’s immediate call tree— and not the module’s call tree — your applicatio ...

Chapter 24: Optimizing Access Applications 845 The Access .accdb format supports several new features, such as multivalued field ...

Part IV: Professional Database Development 846 Tip Change the default Access file format for new files by opening the Access Opt ...

Chapter 24: Optimizing Access Applications 847 contain no source code) and always keep their modules in a compiled state. Becaus ...

Part IV: Professional Database Development 848 Specify a name, drive, and folder for the database. Don’t try to save the .accd ...

Chapter 24: Optimizing Access Applications 849 Even on computers with large amounts of installed memory, loading both the compil ...

Part IV: Professional Database Development 850 Note When you choose Debug ➪ Compile Database Name, you see the name of your proj ...

Chapter 24: Optimizing Access Applications 851 Caution When you change a project name (but not the filename), the entire applica ...

Part IV: Professional Database Development 852 Caution Any library procedures declared as Private are not accessible to the call ...