Navigation:  Articles >

May-1997

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1997-05

 

---

 

Programming Access 97's Command Bars

David Shank

1

 

Article

 

In the April issue of Smart Access, David showed us how to convert existing custom menus and toolbars into command bars and

 

how to create custom command bars using the Access UI. In this article, David introduces us to the CommandBar object model

 

and shows us how to program these new Office 97 objects.

 

Editorial: In Defence of VBA

Paul Litwin

2

 

Editorial

 

Titled in Defence of Microsoft and VBA. Discussion of Microsoft and VBA programming versus Sun/Netscape/Oracle and Java.

 

References, References

David Shank

3

 

Sidebar

 

Sidebar to "Programming Access 97's Command Bars". If you encounter a compile error "User-defined type not defined" while

 

attempting to run the code in this article, this is most likely because you didn't set a reference to the Office 97 type library.

 

Avoid Rounding Errors by Using the Decimal Data Type

Andy Baron & Mary Chipman

7

 

Article

 

Working with floating-point numbers frequently causes headaches for developers. In this article, Andy and Mary explain the

 

new Decimal data type and how you can use it to avoid precision errors in floating-point computations.

 

 

 

 

 

 

 

ad2468x60

 

 

 

Working SQL: SQL Without Joins

Peter Vogel

9

 

Article

 

If you always join tables you put in a query, then you aren't taking advantage of one of the fundamental features of SQL. Not

 

only that, Peter writes, but you're also missing an opportunity to see how SQL really works.

 

Do Natural Language Queries Work?

Karen Watterson

10

 

Review

 

Let's be honest---writing SQL queries is neither fun nor intuitive. For years, universities have been doing "natural language"

 

research (and Microsoft continues the investigation today). In her review of English Wizard, however, Karen tells us that this i

 

Code Like the Experts: Make Your Apps Reusable and Easily Maintained

Paul Litwin

13

 

Article

 

Do you find yourself constantly reinventing the wheel as you develop applications? Or perhaps you've looked horrified when

 

you revisited some code that you wrote a year ago? Paul presents an assortment of ideas on how to improve your

 

development style and

 

Access World News for May 1997 Issue

Paul Litwin

19

 

Access World News

 

Black Moshannon Systems' SPEED Ferret for Access 97; Advanced Software Development Corporation's U.A. Corporate

 

Accounting

 

Shuffling Lists of Numbers, Ranking, and Control-Level Validation

Ken Getz

20

 

Article

 

This month Ken takes on three issues: shuffling values to provide a random list of numbers without repeats, ranking rows in a

 

query, and providing control-level validation on a form. Look for code in Access 2 format (all of this month's solutions work in

---

 

Find all the PDFs and Downloads

http://www.vb123.com/smart/

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software