Access Cookbook - Brossura

Getz, Ken; Litwin, Paul; Baron, Andy

Brossura

ISBN 10: 0596000847 ISBN 13: 9780596000844

Casa editrice: O'Reilly Media, 2002

Riassunto

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 interfaceor of Access application development. The diverse problems and solutions presented here are of interest to Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated.Each of the book?s 14 chapters focuses on a particular topic area related to the Access environment or Access programming. Within each chapter, individual items follow a standardized format. The authors first pose the problem, and then present its solution. Finally, a discussion follows, which consists of extended analysis of the solution, an insightful examination of how Access works, or interesting programming techniques that are used in thesolution but that you can also apply elsewhere.The kinds of problems posed and solved in the book include the following:

• Specifying query criteria at runtime, rather than at design time
• Restricting the user to a single row of a form
• Preventing a report from printing if it has no records
• Making slow forms run faster
• Insuring that user interface objects present a uniform, consistent appearance
• Controlling a printer's paper source programmatically
• Referencing data from multiple SQL Server databases in a single Access Data Project page
• Using contact information from an Access database when sending email using Outlook

The accompanying CD-ROM includes Access databases that contain the solutions for all problems presented in the text.

Su questo libro

L'autore:

Andy Baron is a senior consultant at MCW Technologies, a Microsoft MVP (Most Valuable Professional) since 1995, and a contributing editor for Advisor Media and Pinnacle Publications. Andy is co-author of the Microsoft Access Developers Guide to SQL Server (Sams), and he writes and presents courseware for Application Developers Training Co.

Ken Getz is a senior consultant with MCW Technologies and splits his time between programming, writing, and training. He specializes in tools and applications written in Visual Studio .NET and Visual Basic. Ken is co-author of best-selling several books, including Access 2002 Developer's Handbooks with Paul Litwin and Mike Gunderloy, Visual Basic Language Developer's Handbook with Mike Gilbert, and VBA Developer's Handbook with Mike Gilbert (Sybex). He co-wrote several training courses for Application Developer's Training Company (www.appdev.com), including VB.NET, ASP.NET, Access 2000 and 97, Visual Basic 6, and Visual Basic 5 seminars.He has also recorded video training for AppDev covering VB.NET, ASP.NET, VB6, Access 2000, and Access 97. Ken is a frequent speaker at technical conferences and spoken often at Microsoft's Tech-Ed conference. Ken's also a technical editor for Access-VB-SQL Advisor magazine and a columnist for Informant Publications' asp.netPRO magazine.

Paul Litwin is the president of Litwin Consulting, providing development, mentoring, and training in ASP, ASP.NET, Visual Basic, SQL Server, XML, Microsoft Access, and related technologies. Paul was the founding editor of the Smart Access Newsletter and recently became the editor-in-chief of asp.netPRO Magazine(www.aspnetpro.com). He is the author of a number of books, articles, and training materials on Access, VBA, Web development, ASP, and ASP.NET. Paul is one of the founders of Deep Training, a developer-owned training company providing training on Microsoft.NET (www.deeptraining.com). He is the conference chair of Microsoft ASP.NET Connections (www.asp-connections.com) and Office Developer Connections (www.msofficeconnections.com) and speaks regularly at other industry events, including Microsoft TechEd and Microsoft Office Deployment and Development Conference.

Contenuti:

Preface; What This Book Is About; Who This Book Is For; What You Need to Use This Book; How This Book Is Organized; What We Left Out; Conventions Used in This Book; Comments and Questions; Acknowledgments; Chapter 1: Queries; 1.1 Specify Query Criteria at Runtime; 1.2 Using a Form-Based Parameter Query; 1.3 Limit the Items in One Combo Box Based on the Selected Item in Another; 1.4 Make Formatted Date Columns Sort Correctly in a Crosstab Query; 1.5 Group Mailing Labels by Address; 1.6 Use a Field in One Table to Update a Field in Another Table; 1.7 Use a VBA Variable to Filter a Query; 1.8 Use a Query to Retrieve a Random Set of Rows; 1.9 Create a Query That Will Show Aging of Receivables; 1.10 Create a Join That’s Based on a Comparison Other than Equality; 1.11 Create a Query to Combine Data from Two Tables with Similar Structures; 1.12 Create a Combo Box That Allows a User to Select N/A; 1.13 Use a Query to Show the Relationship Between Employees and Supervisors; 1.14 Create a Query That Uses Case-Sensitive Criteria; 1.15 Use a Query to Create a New Table Complete with Indexes; 1.16 Save My Queries in a Table for Better Programmatic Access and Security; 1.17 Create a Recordset Based on a Parameter Query from VBA Code; Chapter 2: Forms; 2.1 Make Custom Templates for Forms and Reports; 2.2 Highlight the Current Field in Data-Entry Forms; 2.3 Restrict the User to a Single Row on a Form; 2.4 Use an Option Group to Collect and Display Textual Information; 2.5 Display Multiple Pages of Information on One Form; 2.6 Provide Record Navigation Buttons on a Form; 2.7 Size a Form’s Controls to Match the Form’s Size; 2.8 Make a Simple “Searching” List Box; 2.9 Create a Replacement for Access’s InputBox; 2.10 Store the Sizes and Locations of Forms; 2.11 Open Multiple Instances of a Form; Chapter 3: Reports; 3.1 Create a Report with Line Numbers; 3.2 Print the Value of a Parameter on a Report; 3.3 Create a Report with Multiple Columns; 3.4 Print a Message on a Report if Certain Conditions Are Met; 3.5 Create a Page-Range Indicator on Each Page; 3.6 Create a Simple Bar Graph on a Report; 3.7 Create a Page Total; 3.8 Avoid Unwanted Blank Rows on Mailing Labels; 3.9 Suppress Printing a Report if There Are No Records to Print; 3.10 Print Different Headers or Footers on Odd and Even Pages; 3.11 Make a Vertical Line the Same Height as a CanGrow/CanShrink Control; 3.12 Alternate Gray Bars on My Reports; 3.13 Print Only Records Matching a Form’s Filter; 3.14 Keep a Report from Breaking at an Inappropriate Place; 3.15 Customize a Report’s Grouping and Sorting at Runtime; Chapter 4: Developing and Distributing Applications; 4.1 Convert Queries into Embedded SQL Statements; 4.2 Build an Object Inventory; 4.3 Verify That Objects Use Consistent Settings; 4.4 Hide Access Screen Activity; 4.5 Find out What Language Version of Access Is Installed; 4.6 Internationalize Text in Your Applications; 4.7 Change and Reset the Access Caption Bar; 4.8 Use the Windows File Open/Save Common Dialogs; 4.9 Clean Test Data out of a Database When You’re Ready to Ship It; 4.10 Secure Your Access Database; Chapter 5: Taming Your Printer; 5.1 Retrieve a List of All the Installed Output Devices; 5.2 Set and Retrieve the Name of the Default Output Device; 5.3 Programmatically Change Margin and Column Settings for Reports; 5.4 Programmatically Change Printer Options; 5.5 Programmatically Control the Paper Source; 5.6 Retrieve Information About a Report or Form’s Selected Printer; 5.7 Choose an Output Device at Runtime; 5.8 Find Which Reports Are Not Set to Print to the Default Printer; Chapter 6: Managing Data; 6.1 Save with Each Record the Name of the Last Person Who Edited It and the Date and Time; 6.2 Determine if You’re on a New Record in a Form; 6.3 Find All Records with Names That Sound Alike; 6.4 Find the Median Value for a Field; 6.5 Quickly Find a Record in a Linked Table; 6.6 Get a Complete List of Field Properties from a Table or Query; 6.7 Create and Use Flexible AutoNumber Fields; 6.8 Back Up Selected Objects to Another Database; Chapter 7: Exploring VBA in Microsoft Access; 7.1 Build Up String References with Embedded Quotes; 7.2 Create a Global Procedure Stack; 7.3 Create an Execution Time Profiler; 7.4 Multitask Your Access Basic Code; 7.5 Programmatically Add Items to a List or Combo Box; 7.6 Pass a Variable Number of Parameters to a Procedure; 7.7 Sort an Array in Access Basic; 7.8 Fill a List Box with a List of Files; 7.9 Handle Object Properties, in General; 7.10 Detect Whether an Object Exists; Chapter 8: Optimizing Your Application; 8.1 Accelerate the Load Time of Forms; 8.2 Make Slow Forms Run Faster; 8.3 Make Combo Boxes Load Faster; 8.4 Use Rushmore to Speed Up Queries; 8.5 Accelerate VBA Code; 8.6 Test the Comparative Benefits of Various Optimization Techniques; 8.7 Accelerate Multiuser Applications; 8.8 Accelerate Client/Server Applications; Chapter 9: Making the Most of Your User Interface; 9.1 Create Context-Sensitive Keyboard Shortcuts; 9.2 Create a Form with No Menu or Toolbar; 9.3 Create a Geographical Map Interface; 9.4 Mark a Record on a Form and Return to It Later; 9.5 Carry Data Forward from Record to Record; 9.6 Create a Combo Box That Accepts New Entries; 9.7 Create Animated Buttons; 9.8 Create an Expanding Dialog; 9.9 Use an ActiveX Control; 9.10 Create a Generic, Reusable Status Meter; Chapter 10: Multiuser Applications; 10.1 Properly Secure Your Database; 10.2 Maintain Multiple Synchronized Copies of the Same Database; 10.3 Create a Transaction Log; 10.4 Send Messages to Other Users Without Using Email; 10.5 Programmatically Track Users and Groups; 10.6 Adjust an Application Based on Who’s Logged In; 10.7 List All Users with Blank Passwords; 10.8 Track Which Users Have a Shared Database Open; 10.9 Determine if a Record Is Locked and by Whom; 10.10 Set a Maximum Locking Interval for a Record; Chapter 11: The Windows API; 11.1 Remove a Form’s System Menu and Maximize/Minimize Buttons; 11.2 Flash a Window’s Titlebar or Icon; 11.3 Classify Keypresses in a Language-Independent Manner; 11.4 Restrict Mouse Movement to a Specific Region; 11.5 Run Another Program and Pause Until It’s Done; 11.6 Exit Windows Under Program Control; 11.7 Run the Application Associated with a Data File; 11.8 Check to See if an Application Is Already Running; 11.9 Retrieve a List of All Top-Level Windows; 11.10 Close a Running Windows Application; 11.11 Set File Date and Time Stamps; 11.12 Retrieve Information About Available Drives; 11.13 Collect and Display Information on the System and the Access Installation; 11.14 Create and Cancel Network Connections Programmatically; Chapter 12: Automation; 12.1 Play an Embedded Sound File from Within an Application; 12.2 Print an Access Report from Excel; 12.3 Use Excel’s Functions from Within Access; 12.4 Perform a Mail Merge from Access to Word; 12.5 Add an Item to the Startup Group; 12.6 Send Access Data to Excel and Create an Excel Chart; 12.7 Create a PowerPoint Presentation from Access Data; 12.8 Add a Contact and Send Email Through Outlook; Chapter 13: Using Data Access Pages; 13.1 Replace Navigation Button Images with Your Own Images; 13.2 Use Labels or Other Controls for Record Navigation; 13.3 Change the Text Displayed with a Navigation Control; 13.4 Create a DAP That Allows You to Update Data; 13.5 Create One File to Store Connection Information for All DAPs in an Application; 13.6 Programmatically Change the Connection String for All Pages in a Database; 13.7 Change the Default Settings for New DAPs; 13.8 Use Parameters Set in One DAP to Open Another; Chapter 14: Working with SQL Server Data; 14.1 Dynamically Link SQL Server Tables at Runtime; 14.2 Dynamically Connect to SQL Server from an ADP; 14.3 Share an ADP from a Shared Network Folder; 14.4 Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP; 14.5 Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB; 14.6 Pass Parameters to Stored Procedures from an ADP; 14.7 Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP; 14.8 Reference Data from More than One SQL Server Database in an ADP; 14.9 Use Views to Update Data in an ADP When Users Don’t Have Permissions on Tables; Colophon;

Su questa edizione

• Editore: O'Reilly Media
• Data di pubblicazione: 2002
• ISBN 10: 0596000847
• ISBN 13: 9780596000844
• Rilegatura: Copertina flessibile
• Numero di pagine: 680