Apr-1997 |
  
|
Apr-1997 |
|
|
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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
