Access cookbook / Ken Getz, Paul Litwin, and Andy Baron.

Format:

Book

Author/Creator:

Getz, Ken.

Contributor:

Baron, Andy.

Litwin, Paul.

Microsoft Corporation.

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Physical Description:

1 online resource (840 p.)

Edition:

2nd ed.

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly, [2004]

Language Note:

English

System Details:

text file

Summary:

Not a reference book, and not a tutorial either, the new second edition of the highly regarded Access Cookbook is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single ""recipe"" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, Access Cookbook, Second Edition is much more than a handy assortment of cut-and-paste code. Each of the ""recipes"" examine

Contents:

Access Cookbook, 2nd Edition; Uses the Tools at Hand; Follows a Problem-Solution Format; Who This Book Is For; What You Need to Use This Book; How This Book Is Organized; What We Left Out; How Do I Create a New Module?; How Do I Import an Object?; How Do I Create an Event Macro?; How Do I Create an Event Procedure?; How Do I Place Code in a Form or Report&s Module?; How Do I Know What to Do with Code Examples?; How Do I Use Data Access Objects (DAO) in New Databases?; Conventions Used in This Book; Comments and Questions; Acknowledgments; 1. Queries; 1.1.2. Solution; 1.1.3. Discussion

1.2. Using a Form-Based Parameter Query1.2.2. Solution; 1.2.3. Discussion; 1.3. Limit the Items in One Combo Box Based on the Selected Item in Another; 1.3.2. Solution; 1.3.3. Discussion; 1.3.4. See Also; 1.4. Make Formatted Date Columns Sort Correctly in a Crosstab Query; 1.4.2. Solution; 1.4.3. Discussion; 1.5. Group Mailing Labels by Address; 1.5.2. Solution; 1.5.3. Discussion; 1.5.4. See Also; 1.6. Use a Field in One Table to Update a Field in Another Table; 1.6.2. Solution; 1.6.3. Discussion; 1.7. Use a VBA Variable to Filter a Query; 1.7.2. Solution; 1.7.3. Discussion; 1.7.4. See Also

1.8. Use a Query to Retrieve a Random Set of Rows1.8.2. Solution; 1.8.3. Discussion; 1.9. Create a Query That Will Show Aging of Receivables; 1.9.2. Solution; 1.9.3. Discussion; 1.9.4. See Also; 1.10. Create a Join That&s Based on a Comparison Other than Equality; 1.10.2. Solution; 1.10.3. Discussion; 1.11. Create a Query to Combine Data from Two Tables with Similar Structures; 1.11.2. Solution; 1.11.3. Discussion; 1.12. Create a Combo Box That Allows a User to Select N/A; 1.12.2. Solution; 1.12.3. Discussion; 1.12.4. See Also

1.13. Use a Query to Show the Relationship Between Employees and Supervisors1.13.2. Solution; 1.13.3. Discussion; 1.14. Create a Query That Uses Case-Sensitive Criteria; 1.14.2. Solution; 1.14.3. Discussion; 1.15. Use a Query to Create a New Table Complete with Indexes; 1.15.2. Solution; 1.15.3. Discussion; 1.16. Save My Queries in a Table for Better Programmatic Access and Security; 1.16.2. Solution; 1.16.3. Discussion; 1.17. Create a Recordset Based on a Parameter Query from VBA Code; 1.17.2. Solution; 1.17.3. Discussion; 2. Forms; 2.1.2. Solution; 2.1.3. Discussion; 2.1.4. See Also

2.2. Highlight the Current Field in Data-Entry Forms2.2.2. Solution; 2.2.3. Discussion; 2.2.4. See Also; 2.3. Restrict the User to a Single Row on a Form; 2.3.2. Solution; 2.3.3. Discussion; 2.3.4. See Also; 2.4. Use an Option Group to Collect and Display Textual Information; 2.4.2. Solution; 2.4.3. Discussion; 2.5. Display Multiple Pages of Information on One Form; 2.5.2. Solution; 2.5.3. Discussion; 2.6. Provide Record Navigation Buttons on a Form; 2.6.2. Solution; 2.6.3. Discussion; 2.6.4. See Also; 2.7. Size a Form&s Controls to Match the Form&s Size; 2.7.2. Solution; 2.7.3. Discussion

2.8. Make a Simple ""Searching"" List Box

Notes:

"Solutions to practical user interface and programming problems."--Cover.

Includes index.

Description based on print version record.

ISBN:

9780596154387

0596154380

9780596552527

0596552521

OCLC:

609840680