Access Cookbook Solutions to Common User Interface and Programming Problems

ISBN-10: 0596006780

ISBN-13: 9780596006785

Edition: 2nd 2004

List price: $49.95
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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 "AccessCookbook 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.

eBooks Starting from $31.99
Rent eBooks
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $49.95
Edition: 2nd
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 4/3/2004
Binding: Paperback
Pages: 840
Size: 7.00" wide x 9.00" long x 1.50" tall
Weight: 2.596
Language: English

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.

Preface
Queries
Specify Query Criteria at Runtime
Using a Form-Based Parameter Query
Limit the Items in One Combo Box Based on the Selected Item in Another
Make Formatted Date Columns Sort Correctly in a Crosstab Query
Group Mailing Labels by Address
Use a Field in One Table to Update a Field in Another Table
Use a VBA Variable to Filter a Query
Use a Query to Retrieve a Random Set of Rows
Create a Query That Will Show Aging of Receivables
Create a Join That's Based on a Comparison Other than Equality
Create a Query to Combine Data from Two Tables with Similar Structures
Create a Combo Box That Allows a User to Select N/A
Use a Query to Show the Relationship Between Employees and Supervisors
Create a Query That Uses Case-Sensitive Criteria
Use a Query to Create a New Table Complete with Indexes
Save My Queries in a Table for Better Programmatic Access and Security
Create a Recordset Based on a Parameter Query from VBA Code
Forms
Make Custom Templates for Forms and Reports
Highlight the Current Field in Data-Entry Forms
Restrict the User to a Single Row on a Form
Use an Option Group to Collect and Display Textual Information
Display Multiple Pages of Information on One Form
Provide Record Navigation Buttons on a Form
Size a Form's Controls to Match the Form's Size
Make a Simple "Searching" List Box
Create a Replacement for Access's InputBox
Store the Sizes and Locations of Forms
Open Multiple Instances of a Form
Reports
Create a Report with Line Numbers
Print the Value of a Parameter on a Report
Create a Report with Multiple Columns
Print a Message on a Report if Certain Conditions Are Met
Create a Page-Range Indicator on Each Page
Create a Simple Bar Graph on a Report
Create a Page Total
Avoid Unwanted Blank Rows on Mailing Labels
Suppress Printing a Report if There Are No Records to Print
Print Different Headers or Footers on Odd and Even Pages
Make a Vertical Line the Same Height as a CanGrow/CanShrink Control
Alternate Gray Bars on My Reports
Print Only Records Matching a Form's Filter
Keep a Report from Breaking at an Inappropriate Place
Customize a Report's Grouping and Sorting at Runtime
Applications
Convert Queries into Embedded SQL Statements
Build an Object Inventory
Verify That Objects Use Consistent Settings
Hide Access Screen Activity
Find out What Language Version of Access Is Installed
Internationalize Text in Your Applications
Change and Reset the Access Caption Bar
Use the Windows File Open/Save Common Dialogs
Clean Test Data out of a Database When You're Ready to Ship It
Secure Your Access Database
Printers
Retrieve a List of All the Installed Output Devices
Set and Retrieve the Name of the Default Output Device
Programmatically Change Margin and Column Settings for Reports
Programmatically Change Printer Options
Programmatically Control the Paper Source
Retrieve Information About a Report or Form's Selected Printer
Choose an Output Device at Runtime
Find Which Reports Are Not Set to Print to the Default Printer
Data
Save with Each Record the Name of the Last Person Who Edited It and the Date and Time
Determine if You're on a New Record in a Form
Find All Records with Names That Sound Alike
Find the Median Value for a Field
Quickly Find a Record in a Linked Table
Get a Complete List of Field Properties from a Table or Query
Create and Use Flexible AutoNumber Fields
Back Up Selected Objects to Another Database
VBA
Build Up String References with Embedded Quotes
Create a Global Procedure Stack
Create an Execution Time Profiler
Multitask Your VBA Code
Programmatically Add Items to a List or Combo Box
Pass a Variable Number of Parameters to a Procedure
Sort an Array in VBA
Fill a List Box with a List of Files
Handle Object Properties, in General
Detect Whether an Object Exists
Optimization
Accelerate the Load Time of Forms
Make Slow Forms Run Faster
Make Combo Boxes Load Faster
Use Jet Engine Optimizations to Speed Up Queries
Accelerate VBA Code
Test the Comparative Benefits of Various Optimization Techniques
Accelerate Multiuser Applications
Accelerate Client/Server Applications
User Interface
Create Context-Sensitive Keyboard Shortcuts
Create a Form with No Menu or Toolbar
Create a Geographical Map Interface
Mark a Record on a Form and Return to It Later
Carry Data Forward from Record to Record
Create a Combo Box That Accepts New Entries
Create Animated Buttons
Create an Expanding Dialog
Use an ActiveX Control
Create a Generic, Reusable Status Meter
Multiuser Applications
Properly Secure Your Database
Maintain Multiple Synchronized Copies of the Same Database
Create a Transaction Log
Send Messages to Other Users Without Using Email
Programmatically Track Users and Groups
Adjust an Application Based on Who's Logged In
List All Users with Blank Passwords
Track Which Users Have a Shared Database Open
Determine if a Record Is Locked and by Whom
Set a Maximum Locking Interval for a Record
Windows APIs
Remove a Form's System Menu and Maximize/Minimize Buttons
Flash a Window's Titlebar or Icon
Classify Keypresses in a Language-Independent Manner
Restrict Mouse Movement to a Specific Region
Run Another Program and Pause Until It's Done
Exit Windows Under Program Control
Run the Application Associated with a Data File
Check to See if an Application Is Already Running
Retrieve a List of All Top-Level Windows
Close a Running Windows Application
Set File Date and Time Stamps
Retrieve Information About Available Drives
Collect and Display Information on the System and the Access Installation
Create and Cancel Network Connections Programmatically
Automation
Play an Embedded Sound File from Within an Application
Print an Access Report from Excel
Use Excel's Functions from Within Access
Perform a Mail Merge from Access to Word
Add an Item to the Startup Group
Send Access Data to Excel and Create an Excel Chart
Create a PowerPoint Presentation from Access Data
Add a Contact and Send Email Through Outlook
Data Access Pages
Replace Navigation Button Images with Your Own Images
Use Labels or Other Controls for Record Navigation
Change the Text Displayed with a Navigation Control
Create a DAP that Allows You to Update Data
Create One File to Store Connection Information for All DAPs in an Application
Programmatically Change the Connection String for All Pages in a Database
Change the Default Settings for New DAPs
Use Parameters Set in One DAP to Open Another
SQL Server
Dynamically Link SQL Server Tables at Runtime
Dynamically Connect to SQL Server from an ADP
Share an ADP from a Shared Network Folder
Fill the Drop-Down Lists When Using ServerFilterByForm in an ADP
Pass Parameters to Stored Procedures from Pass-Through Queries in an MDB
Pass Parameters to Stored Procedures from an ADP
Use Controls as Parameters for the Row Source of Combo and List Boxes in an ADP
Reference Data from More than One SQL Server Database in an ADP
Use Views to Update Data in an ADP When Users Don't Have Permissions on Tables
Office Web and SharePoint
Work with SharePoint Data from Access
Create a SharePoint Data View Web Part Based on Access Data
Conditionally Format a Data View Web Part
Create a Master/Detail Page using Data View Web Parts
Post Web Form Data to an Access Database
Create a Web Frontend to an Access Table Using FrontPage
Smart Tags
Use the Built-in Smart Tags
Display Multiple Smart Tags on Multiple Forms
Display Smart Tags when Application Starts
Execute a Smart Tag Action Without Displaying the Smart Tag
Create a Smart Tag on a Table in an Access Project
Create a Custom Smart Tag to Get a Weather Report
Create a Custom Smart Tag DLL
.NET
Call a .NET Component from Access
Call a .NET Component Containing a Parameterized Constructor
Retrieve Access Data from an ASP.NET Application
Call a Web Service from Access
Work with a Web Service that Returns a DataSet
Print an Access Report from .NET Windows Form Application
XML
Import XML Structured as Elements
Import XML into Existing Tables
Import XML Using a Schema (XSD)
Export XML
Exporting Selected Columns to an HTML Table
Export Unrelated Tables
Export Using a Where Clause
Export a Report
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×