Microsoft Access 2010 Bible

Chapter 24: Optimizing Access Applications 873 problems by using SQL Server as the database engine, you’ll probably have a much ...

Part IV: Professional Database Development 874 Recognizing that compiling and compacting may not be enough As you add, delete, a ...

Chapter 24: Optimizing Access Applications 875 Open a new empty database. Select the External Data ribbon tab. Click the Access ...

Part IV: Professional Database Development 876 Using the decompile option A little known start-up, command-line option is called ...

Chapter 24: Optimizing Access Applications 877 Caution Make sure that you immediately exit Access after it finishes decompiling ...

Part IV: Professional Database Development 878 One line of code can be added anywhere in your program to detect an uncompiled ap ...

Chapter 24: Optimizing Access Applications 879 FIGURE 24.18 A module to automatically compile and compact your database Making s ...

...

881 CHAPTER Advanced Data Access with VBA IN THIS CHAPTER Using a combo box to find a record on a form Using the form’s filter o ...

Part IV: Professional Database Development 882 Figure 25.1 shows frmProducts with an additional control at the top — a combo box ...

Chapter 25: Advanced Data Access with VBA ............................................................................. 883 The ...

Part IV: Professional Database Development 884 the search criteria, Access moves the datasheet record pointer to the first row t ...

Chapter 25: Advanced Data Access with VBA 885 The next block of code is If Not IsNull(cboQuickSearch.Value) Then DoCmd.FindRecor ...

Part IV: Professional Database Development 886 FIGURE 25.5 Using a RecordsetClone bookmark to find a record The Recordset object ...

Chapter 25: Advanced Data Access with VBA 887 Tip Creating criteria in code is sometimes a complicated process. The objective is ...

Part IV: Professional Database Development 888 Note Criteria can be as complex as you need them to be, even involving multiple f ...

Chapter 25: Advanced Data Access with VBA 889 The first line of code sets form’s Filter property: Me.Filter = “ProductID = “ &am ...

Part IV: Professional Database Development 890 The Chapter25.accdb database contains a parameter query named qryProductParameter ...

Chapter 25: Advanced Data Access with VBA 891 FIGURE 25.8 Running the parameter query Tip You can use the wildcards * (anything ...

Part IV: Professional Database Development 892 FIGURE 25.9 The Query Parameters dialog box Tip If you want to add more-complex p ...