Microsoft Access 2010 Bible

Chapter 24: Optimizing Access Applications 853 After a database is referenced, you can call the procedures in the referenced dat ...

Part IV: Professional Database Development 854 End If Next ref ExitHere: Exit Function HandleError: MsgBox Err & “: “ & ...

Chapter 24: Optimizing Access Applications 855 can’t be opened exclusively. (Actually, the first user can open it exclusively, b ...

Part IV: Professional Database Development 856 Note Although databases should be compacted regularly, that does not mean they sh ...

Chapter 24: Optimizing Access Applications 857 Entire volumes of text have been devoted to the subject of database theory. Teach ...

Part IV: Professional Database Development 858 l (^) The field’s data type is Text, Number, Currency, or Date/Time. l You antici ...

Chapter 24: Optimizing Access Applications 859 l (^) Limit the columns of data returned in a select query to only those you need ...

Part IV: Professional Database Development 860 Minimizing form and report complexity and size One of the key elements to achievi ...

Chapter 24: Optimizing Access Applications 861 l (^) Use an Image control. If the image never changes, use an Image control. Ima ...

Part IV: Professional Database Development 862 Getting the most from your modules An area where you’ll often be able to use smar ...

Chapter 24: Optimizing Access Applications 863 In addition to using integers and long integers whenever possible, you should als ...

Part IV: Professional Database Development 864 Some Access functions perform similar processes but vary greatly in execution tim ...

Chapter 24: Optimizing Access Applications 865 frm![InvoiceDate] = something frm![SalespersonID] = something This way, the form ...

Part IV: Professional Database Development 866 LISTING 24.1 Using a Bookmark to Mark a Record Public Sub BookmarkExample() Dim r ...

Chapter 24: Optimizing Access Applications 867 When using Jet or ACE as the database engine, an Access application can run only ...

Part IV: Professional Database Development 868 To create a splash screen, create a basic form with appropriate information, such ...

Chapter 24: Optimizing Access Applications 869 Using the built-in progress meter In addition to using the hourglass, you should ...

Part IV: Professional Database Development 870 The first step for using the percent meter is initializing the meter by calling t ...

Chapter 24: Optimizing Access Applications 871 This progress meter has some advantages over the standard Microsoft Access progre ...

Part IV: Professional Database Development 872 The function SetPMeter consists of only three lines — one to display the rectangl ...