Navigation:  Articles >

Apr-1997

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1997-04

 

---

 

Use Network Resources in VBA

Ken Getz & Michael Kaplan

1

 

Article

 

In the September 1995 issue of Smart Access, Michael wrote up many 16-bit network-handling API functions for Access 2. It’s

 

been a while, and many readers have upgraded to Access 95 or 97. Because these products require 32-bit API calls, the code in

 

the original article won’t work. In this article, Michael and Ken revisit some of the same topics and introduce others, and it’s geared exclusively for 32-bit applications. If you’re using any Office 95 or Office 97 application, or if you’re working with a 32-bit version of Visual Basic, you’ll find the techniques in this article useful for handling your network needs.

 

 

 

 

 

 

 

ad3468x60

 

 

 

 

 

Editorial for April 1997 Issue

Paul Litwin

2

 

Editorial

 

Paul discusses the Microsoft Web Browser Control.

 

Get Rid of Those SendKeys Commands

Tyler Coplen & Paul Litwin

7

 

Smart Tip

 

After converting an Access 2 application to Access 97, I noticed that the NumLock key was often toggled. This irritating

 

behavior was tracked down to the use of the SendKeys commands in my code...

 

 

 

7

 

Smart Tip

 

 

 

 

 

Making Sense of Access 97's Command Bars

Richard Knudson & David Shank

8

 

Article

 

In Access 97 all menus, toolbars, and shortcut menus are variations of the new CommandBar object. In this first installment of a

 

two-part series on command bars, David presents an overview of command bars and discusses some of the things to watch for

 

when converting menu bar macros to Access 97 command bars. Next month, David will discuss the programmability aspects of command bars.

 

 

 

 

 

 

 

 

 

 

 

 

 

The New Menu Bar Wizard

David Shank

9

 

Sidebar

 

Side bar for "Making Sense of Access 97's Command Bars".

 

Working SQL: Creating Objects Using Code: Is DAO or SQL Better?

Peter Vogel

11

 

Article

 

SQL may be much more useful to you than you think. In this first of a series on articles on SQL, Peter introduces SQL and

 

compares it to DAO for ease of use and performance. He also includes a utility to transfer table designs between any SQL

 

databases.

 

Garbage In, Garbage Out: Validating User Input

Mike Gunderloy

15

 

Article

 

A database is only as good as the data that it contains. The best way to make sure only good data gets saved is to check it as

 

the user is typing. In this article, Mike explores some strategies for validating user input.

 

Internationalize Your Where Clause Arguments

Dan Haught

19

 

Smart Tip

 

Have you experienced any problems with passing arguments to SQL Where clauses?

 

Fast Filename Parsing

Ken Getz

21

 

Smart Tip

 

If you have a full file name (including the path) that represents an actual file, you often need to parse out just the filename

 

portion.

 

Prevent Exclusive Access

Carl Salter

21

 

Smart Tip

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software