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 a particular problem--problems that commonly occur when you push the upper limits of Access, or ones that are likely to trip up a developer attempting to design a more elegant Access application--even some things you never knew Access could do. The authors then, in a clear, accessible, step-by-step style, present the problems' solution. Following each "recipe" are insights on how Access works, potential pitfalls, interesting programming techniques that are used in the solution, and how and why the solution works, so you can adapt the problem-solving techniques to other similar situations.Fully updated for Access 2003, Access Cookbook, Second Edition is also one of the first books to thoroughly explore new support for .NET managed code and XML. All of the practical, real-world examples have been tested for compatibility with Access 2003, Windows XP, and Windows Server 2003. This updated new edition also covers Access and SharePoint, Access and SmartTags, Access and .NET; and Access and XML.Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the Access Cookbook for quick solutions to gnarly problems. With a dog-eared copy of Access Cookbook at your side, you can spend your time and energy where it matters most: working on the interesting facets of your Access application, not just the time-consuming ones.
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Solutions to Practical User Interface and Programming ProblemsAbout the Author:
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.
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.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Descrizione libro O'Reilly Media, 2004. Condizione libro: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Preface1. Queries1.1 Specify Query Criteria at Runtime1.2 Using a Form-Based Parameter Query1.3 Limit the Items in One Combo Box Based on the Selected Item in Another1.4 Make Formatted Date Columns Sort Correctly in a Crosstab Query1.5 Group Mailing Labels by Address1.6 Use a Field in One Table to Update a Field in Another Table1.7 Use a VBA Variable to Filter a Query1.8 Use a Query to Retrieve a Random Set of Rows1.9 Create a Query That Will Show Aging of Receivables1.10 Create a Join That''s Based on a Comparison Other than Equality1.11 Create a Query to Combine Data from Two Tables with Similar Structures1.12 Create a Combo Box That Allows a User to Select N/A1.13 Use a Query to Show the Relationship Between Employees and Supervisors1.14 Create a Query That Uses Case-Sensitive Criteria1.15 Use a Query to Create a New Table Complete with Indexes1.16 Save My Queries in a Table for Better Programmatic Access and Security1.17 Create a Recordset Based on a Parameter Query from VBA Code2. Forms2.1 Make Custom Templates for Forms and Reports2.2 Highlight the Current Field in Data-Entry Forms2.3 Restrict the User to a Single Row on a Form2.4 Use an Option Group to Collect and Display Textual Information2.5 Display Multiple Pages of Information on One Form2.6 Provide Record Navigation Buttons on a Form2.7 Size a Form''s Controls to Match the Form''s Size2.8 Make a Simple "Searching" List Box2.9 Create a Replacement for Access''s InputBox2.10 Store the Sizes and Locations of Forms2.11 Open Multiple Instances of a Form3. Reports3.1 Create a Report with Line Numbers3.2 Print the Value of a Parameter on a Report3.3 Create a Report with Multiple Columns3.4 Print a Message on a Report if Certain Conditions Are Met3.5 Create a Page-Range Indicator on Each Page3.6 Create a Simple Bar Graph on a Report3.7 Create a Page Total3.8 Avoid Unwanted Blank Rows on Mailing Labels3.9 Suppress Printing a Report if There Are No Records to Print3.10 Print Different Headers or Footers on Odd and Even Pages3.11 Make a Vertical Line the Same Height as a CanGrow/CanShrink Control3.12 Alternate Gray Bars on My Reports3.13 Print Only Records Matching a Form''s Filter3.14 Keep a Report from Breaking at an Inappropriate Place3.15 Customize a Report''s Grouping and Sorting at Runtime4. Applications4.1 Convert Queries into Embedded SQL Statements4.2 Build an Object Inventory4.3 Verify That Objects Use Consistent Settings4.4 Hide Access Screen Activity4.5 Find out What Language Version of Access Is Installed4.6 Internationalize Text in Your Applications4.7 Change and Reset the Access Caption Bar4.8 Use the Windows File Open/Save Common Dialogs4.9 Clean Test Data out of a Database When You''re Ready to Ship It4.10 Secure Your Access Database5. Printers5.1 Retrieve a List of All the Installed Output Devices5.2 Set and Retrieve the Name of the Default Output Device5.3 Programmatically Change Margin and Column Settings for Reports5.4 Programmatically Change Printer Options5.5 Programmatically Control the Paper Source5.6 Retrieve Information About a Report or Form''s Selected Printer5.7 Choose an Output Device at Runtime5.8 Find Which Reports Are Not Set to Print to the Default Printer6. Data6.1 Save with Each Record the Name of the Last Person Who Edited It and the Date and Time6.2 Determine if You''re on a New Record in a Form6.3 Find All Records with Names That Sound Alike6.4 Find the Median Value for a Field6.5 Quickly Find a Record in a Linked Table6.6 Get a Complete List of Field Properties from a Table or Query6.7 Create and Use Flexible AutoNumber Fields6.8 Back Up Selected Objects to Another Database7. VBA7.1 Build Up String References with Embedded Quotes7.2 Create a Global Procedure Stack7.3 Create an Execution Time Profiler7.4 Multitask Your VBA Code7.5 Programmatically Add Items to a List or Combo Box7.6 Pass a Variable Number of Parameters to a Procedure7.7 Sort an Array in VBA7.8 F. Codice libro della libreria ABE_book_new_0596006780
Descrizione libro O'Reilly Media, 2004. Paperback. Condizione libro: New. book. Codice libro della libreria 0596006780
Descrizione libro O'Reilly Media, 2004. Paperback. Condizione libro: New. 2nd. Codice libro della libreria DADAX0596006780
Descrizione libro O'Reilly Media, 2004. Paperback. Condizione libro: New. Codice libro della libreria P110596006780
Descrizione libro O'Reilly Media. PAPERBACK. Condizione libro: New. 0596006780 New Condition. Codice libro della libreria NEW4.0310652