472,986 Members | 2,906 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,986 software developers and data experts.

"Access Cookbook, Second Edition" Released by O'Reilly

---------- Forwarded message ----------

Solutions to Everyday User Interface and Programming Problems
O'Reilly Releases "Access Cookbook, Second Edition"

Sebastopol, CA--Neither reference book nor tutorial, "Access Cookbook,
Second Edition" (O'Reilly, US $49.95), by Ken Getz, Paul Litwin, and
Andy Baron, delivers hundreds of practical examples, up-to-date
suggestions, and handy solutions to real-world problems that Access users
and developers have faced, will likely face, and perhaps haven't yet
even considered as they attempt to build increasingly complex and even
more productive applications.

"This is an idea book," claim Getz, Litwin, and Baron. "If you're
using Access and you aspire to create database applications that are more
than wizard-created clones of every other database application, this is
the book for you."

Featuring the reader-friendly, highly useful problem-solution format that
O'Reilly cookbooks are known for, "Access Cookbook, Second Edition"
delivers easy-to-find and ready-to-digest "recipes" for more than 170
common (and not so common) Access problems. A single recipe in this
cookbook can save hours of frustration, but the "Access Cookbook" is much
more than a handy assortment of cut-and-paste code. Alongside each recipe,
the authors present insights on how Access works, potential pitfalls,
interesting programming techniques that are used in the solution, and how
and why the solution works, so readers can adapt the problem-solving
techniques to other similar situations.

Fully updated and expanded, the second edition of "Access Cookbook"
includes four brand-new chapters covering Access and SharePoint,
SmartTags, .NET, and XML. Each recipe has been tested for compatibility
with Access 2003, Windows XP, and Windows Server 2003.

Access power users and programmers at all levels, from the relatively
inexperienced to the most sophisticated, will rely on the "Access
Cookbook" for quick, timely solutions to gnarly problems, such as:

-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 when it contains no records
-Making slow forms run faster
-Ensuring that application user interface objects present a uniform and
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
-Posting ASP.NET data to an Access database
-Importing and exporting XML documents

To make things easier yet, "Access Cookbook, Second Edition" includes a
CD-ROM with Access databases that contain the solutions for each problem
presented in the text.

Praise for the first edition:

"The title pretty well says it all, and if you work with Access or plan to
or even just want to know some of the things Access can do, you need this
--Jerry Pournelle, Byte.com, April 2002

"If you've ever wondered how to create an Access query that uses
case-sensitive criteria or how to keep a report from breaking at an
inappropriate spot, check out 'Access Cookbook'...The authors show you how
to overcome these problems--and much more--for Access 97, 2000, and 2002."
--James E. Powell, "The Office Letter," May 2002

"A good book with clear code and some interesting suggestions about
solutions for a wide range of problems."
--Computer Shopper, August 2002

Further reviews can be found at:

Additional Resources:

Chapter 7, "VBA," is available online at:

For more information about the book, including table of contents, index,
author bios, and samples, see:

For a cover graphic in JPEG format, go to:

Access Cookbook, Second Edition
Ken Getz, Paul Litwin, and Andy Baron
ISBN 0-596-00678-0, 810 pages, $49.95 US, $72.95 CA

About O'Reilly
O'Reilly & Associates is the premier information source for leading-edge
computer technologies. The company's books, conferences, and web sites
bring to light the knowledge of technology innovators. O'Reilly books,
known for the animals on their covers, occupy a treasured place on the
shelves of the developers building the next generation of software.
O'Reilly conferences and summits bring alpha geeks and forward-thinking
business leaders together to shape the revolutionary ideas that spark new
industries. From the Internet to XML, open source, .NET, Java, and web
services, O'Reilly puts technologies on the map. For more information:

# # #

O'Reilly is a registered trademark of O'Reilly Media, Inc. All other
trademarks are property of their respective owners.
Nov 12 '05 #1
0 2856

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Prince Kumar | last post by:
When running LOAD with "ALLOW READ ACCESS", I get the following error if select is running againt the table (isolation UR). load.sql --------- db2 load from /u02/data/dly_d040817_test.dat of...
by: Frederick Noronha \(FN\) | last post by:
---------- Forwarded message ---------- Solutions to Everyday User Interface and Programming Problems O'Reilly Releases "Access Cookbook, Second Edition" Sebastopol, CA--Neither reference book...
by: VMI | last post by:
In Access, when a user's going to import a fixed-width format ascii file, a window in the "Import Text Wizard" lets the user "mark" where in a string one field will begin and end (with the vertical...
by: Richard Phillips | last post by:
Hello, Does anyone else out there have a copy of this? I'm working through my copy and have discovered that it has no chapter 11... Pages 341-388 are just not there! Anyone else able to check...
by: egrill | last post by:
I need assistance on how I can keep the results of a calculated field as part of a record. Each time I use the form I loose the previous calculation. I can set-up the form calculation but want to...
by: Odd B Andersen | last post by:
I get this message in the db2diag.log. 2008-04-01- E13321H539 LEVEL: Error (OS) PID : 3528 TID : 144 PROC : db2syscs.exe INSTANCE: DB2 ...
by: Jeff Bigham | last post by:
Hi, I'm getting an "Access is denied" error in IE when I try to focus an input box with node.focus() My understanding is that should only happen when the domains are different of the...
by: =?Utf-8?B?bXVyYWRqYW1lcw==?= | last post by:
Yes, sorry I tried to make it clear in the original question that I want to get the user token of the service - ie. the account the service is running under. I know services don't have user tokens...
by: sbasavar | last post by:
Hi All, In my excel programming, I am using XML http object (MSXML2.XMLHTTP.3.0). Using this object when I try to send a request application throws an "Access is Denied" error. Strange thing...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.