Other Topics > Smart Access 1996-2006 > Feb-2002

Feb-2002

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

Feb-2002

 

Smart Access Article Abstracts

Page

 

 

2002-02

 

---

 

Auto-Generated Update SQL

Ann Ziegler

1

 

Article

 

Retrieving data isn’t all that you can do with generated SQL statements. Ann Ziegler shows how to create an update-and-

 

append statement on the fly.

 

Boys and Their Toys

Peter Vogel

2

 

Editorial

 

I just discovered two new toys, and they’re so neat that I can’t wait to tell people about them. Before going further, I should

 

admit that I hate doing these kinds of articles. No sooner do I trot these tools out than I get a dozen e-mails explaining to m

 

Working SQL: Efficient SQL

Peter Vogel

7

 

Article

 

In the latest edition of the “Working SQL” column, Peter Vogel looks at some of the general issues around creating SQL queries that run quickly.

 

 

 

Shrink-Wrapped or Do-it-yourself Queries

David Cornelius

11

 

Article

 

David Cornelius explains how to use multiple queries, both canned and custom-built, to build an application using only one form

 

and a report. You can empower your users to become more productive and efficient.

 

 

 

 

 

 

 

ad7468x60

 

 

 

Cool Tricks for the Sophisticated Developer

Christopher R. Weber

16

 

Access Answers

 

This month, Chris Weber addresses questions from real-life, Access training seminar attendees about report totals, splash screens, trapping keystrokes, managing

 

control widths, when there’s more in a memo than meets the eye, triple state check boxes...

 

 

 

Starting the Interface with Access Data Projects

Martin Reid

18

 

Article

 

This month, Martin Reid shows you how to build your user interface to an Access Data Project. You’ll see how easy it is to create

 

an Access form that’s bound to a stored procedure without giving up the benefits of parameters.

---

 

 

 

---