Access cookbook

Access Cookbook contains a comprehensive collection of problems, solutions,and practical examples for the Access power user or programmer who is running up against some of the apparent limits of the Access user interface or of Access application development. The diverse problems and solutions presen...

Descripción completa

Detalles Bibliográficos
Autor Corporativo:	Microsoft Corporation Content Provider (content provider)
Otros Autores:	Getz, Ken Author (author), Baron, Andy Contributor (contributor), Litwin, Paul Contributor
Formato:	Libro electrónico
Idioma:	Inglés
Publicado:	[Place of publication not identified] O'Reilly 2002
Edición:	1st edition
Materias:	Microsoft Access. Database management Engineering & Applied Sciences Computer Science
Ver en Biblioteca Universitat Ramon Llull:	https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627029006719

Tabla de Contenidos:

Intro
Table of Contents
Preface
What This Book Is About
Promotes Creative Use of the Product
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 Set Control Properties?
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
Queries
1.1 Specify Query Criteria at Runtime
Problem
Solution
Discussion
1.2 Using a Form-Based Parameter Query
Problem
Solution
Discussion
1.3 Limit the Items in One Combo Box Based on the Selected Item in Another
Problem
Solution
Discussion
See Also
1.4 Make Formatted Date Columns Sort Correctly in a Crosstab Query
Problem
Solution
Discussion
1.5 Group Mailing Labels by Address
Problem
Solution
Discussion
See Also
1.6 Use a Field in One Table to Update a Field in Another Table
Problem
Solution
Discussion
1.7 Use a VBA Variable to Filter a Query
Problem
Solution
Discussion
See Also
1.8 Use a Query to Retrieve a Random Set of Rows
Problem
Solution
Discussion
1.9 Create a Query That Will Show Aging of Receivables
Problem
Solution
Discussion
See Also
1.10 Create a Join That's Based on a Comparison Other than Equality
Problem
Solution
Discussion
1.11 Create a Query to Combine Data from Two Tables with Similar Structures
Problem
Solution
Discussion
1.12 Create a Combo Box That Allows a User to Select N/A
Problem
Solution.
Discussion
See Also
1.13 Use a Query to Show the Relationship Between Employees and Supervisors
Problem
Solution
Discussion
1.14 Create a Query That Uses Case-Sensitive Criteria
Problem
Solution
Discussion
1.15 Use a Query to Create a New Table Complete with Indexes
Problem
Solution
Discussion
1.16 Save My Queries in a Table for Better Programmatic Access and Security
Problem
Solution
Discussion
1.17 Create a Recordset Based on a Parameter Query from VBA Code
Problem
Solution
Discussion
Forms
2.1 Make Custom Templates for Forms and Reports
Problem
Solution
Discussion
See Also
2.2 Highlight the Current Field in Data-Entry Forms
Problem
Solution
Discussion
See Also
2.3 Restrict the User to a Single Row on a Form
Problem
Solution
Discussion
See Also
2.4 Use an Option Group to Collect and Display Textual Information
Problem
Solution
Discussion
2.5 Display Multiple Pages of Information on One Form
Problem
Solution
Discussion
2.6 Provide Record Navigation Buttons on a Form
Problem
Solution
Discussion
See Also
2.7 Size a Form's Controls to Match the Form's Size
Problem
Solution
Discussion
2.8 Make a Simple "Searching" List Box
Problem
Solution
Discussion
2.9 Create a Replacement for Access's InputBox
Problem
Solution
Discussion
Using optional parameters
Creating pop-up forms
Initializing pop-up forms
Programmatically accessing online help
Miscellaneous comments
See Also
2.10 Store the Sizes and Locations of Forms
Problem
Solution
Discussion
See Also
2.11 Open Multiple Instances of a Form
Problem
Solution
Discussion
Reports
3.1 Create a Report with Line Numbers
Problem
Solution
Discussion.
3.2 Print the Value of a Parameter on a Report
Problem
Solution
Discussion
3.3 Create a Report with Multiple Columns
Problem
Solution
Discussion
See Also
3.4 Print a Message on a Report if Certain Conditions Are Met
Problem
Solution
Discussion
3.5 Create a Page-Range Indicator on Each Page
Problem
Solution
Discussion
3.6 Create a Simple Bar Graph on a Report
Problem
Solution
Discussion
3.7 Create a Page Total
Problem
Solution
Discussion
3.8 Avoid Unwanted Blank Rows on Mailing Labels
Problem
Solution
Discussion
3.9 Suppress Printing a Report if There Are No Records to Print
Problem
Solution
Discussion
See Also
3.10 Print Different Headers or Footers on Odd and Even Pages
Problem
Solution
Discussion
3.11 Make a Vertical Line the Same Height as a CanGrow/CanShrink Control
Problem
Solution
Discussion
3.12 Alternate Gray Bars on My Reports
Problem
Solution
Discussion
3.13 Print Only Records Matching a Form's Filter
Problem
Solution
Discussion
3.14 Keep a Report from Breaking at an Inappropriate Place
Problem
Solution
Discussion
3.15 Customize a Report's Grouping and Sorting at Runtime
Problem
Solution
Discussion
Applications
4.1 Convert Queries into Embedded SQL Statements
Problem
Solution
Discussion
See Also
4.2 Build an Object Inventory
Problem
Solution
Discussion
Documenting all the containers
Creating the inventory table
Documenting each container
Avoiding errors
Comments
See Also
4.3 Verify That Objects Use Consistent Settings
Problem
Solution
Discussion
Creating the temporary tables and query
Getting ready to document items
Visiting all the objects
Recording property information
Comments
See Also.
4.4 Hide Access Screen Activity
Problem
Solution
Discussion
Hiding reports in design view
See Also
4.5 Find out What Language Version of Access Is Installed
Problem
Solution
Discussion
4.6 Internationalize Text in Your Applications
Problem
Solution
Discussion
4.7 Change and Reset the Access Caption Bar
Problem
Solution
Discussion
4.8 Use the Windows File Open/Save Common Dialogs
Problem
Solution
Discussion
See Also
4.9 Clean Test Data out of a Database When You're Ready to Ship It
Problem
Solution
Discussion
See Also
4.10 Secure Your Access Database
Problem
Solution
Discussion
Printers
5.1 Retrieve a List of All the Installed Output Devices
Problem
Solution
Discussion
Adding items to a list box
See Also
5.2 Set and Retrieve the Name of the Default Output Device
Problem
Solution
Discussion
5.3 Programmatically Change Margin and Column Settings for Reports
Problem
Solution
Discussion
5.4 Programmatically Change Printer Options
Problem
Solution
Discussion
5.5 Programmatically Control the Paper Source
Problem
Solution
Discussion
5.6 Retrieve Information About a Report or Form's Selected Printer
Problem
Solution
5.7 Choose an Output Device at Runtime
Problem
Solution
Discussion
5.8 Find Which Reports Are Not Set to Print to the Default Printer
Problem
Solution
Discussion
Data
6.1 Save with Each Record the Name of the Last Person Who Edited It and the Date and Time
Problem
Solution
Discussion
See Also
6.2 Determine if You're on a New Record in a Form
Problem
Solution
Discussion
6.3 Find All Records with Names That Sound Alike
Problem
Solution
Discussion
6.4 Find the Median Value for a Field
Problem
Solution.
Discussion
6.5 Quickly Find a Record in a Linked Table
Problem
Solution
Discussion
6.6 Get a Complete List of Field Properties from a Table or Query
Problem
Solution
Discussion
See Also
6.7 Create and Use Flexible AutoNumber Fields
Problem
Solution
Discussion
6.8 Back Up Selected Objects to Another Database
Problem
Solution
Discussion
The MultiSelect property
Filling the lboObjects list box
The backup process
Comments
VBA
7.1 Build Up String References with Embedded Quotes
Problem
Solution
Discussion
7.2 Create a Global Procedure Stack
Problem
Solution
Discussion
7.3 Create an Execution Time Profiler
Problem
Solution
Steps
Discussion
7.4 Multitask Your VBA Code
Problem
Solution
Discussion
7.5 Programmatically Add Items to a List or Combo Box
Problem
Solution
Filling a list box by calling the AddItem method
Filling a list box by modifying the RowSource property
Filling a list box by creating a list-filling callback function
Discussion
Calling the AddItem method
Modifying the RowSource property
Creating a list-filling callback function
7.6 Pass a Variable Number of Parameters to a Procedure
Problem
Solution
Discussion
7.7 Sort an Array in VBA
Problem
Solution
Discussion
See Also
7.8 Fill a List Box with a List of Files
Problem
Solution
Discussion
7.9 Handle Object Properties, in General
Problem
Solution
Discussion
7.10 Detect Whether an Object Exists
Problem
Solution
Discussion
See Also
Optimization
8.1 Accelerate the Load Time of Forms
Problem
Solution
Discussion
8.2 Make Slow Forms Run Faster
Problem
Solution
Graphic and memo controls
Combo and list box controls
Discussion
8.3 Make Combo Boxes Load Faster.
Problem.

Access cookbook

Ejemplares similares