Navigation:  Articles >

Feb-1997

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1997-02

 

---

 

When Access Math Doesn't Add Up

Luke Chung

1

 

Article

 

All versions of Access share several quirks that can result in inaccurate mathematical calculations in both code and queries.

 

Understanding these quirks will help you avoid unnecessary headaches when the numbers you generate don’t match the

 

mathematically correct values.

 

Editorial: The More Things Change . . .

Paul Litwin

2

 

Editorial

 

The More Things Change...: discussion of articles in this issue.

 

Expand Your Outlook with Access 97

David Shank

5

 

Article

 

This article presents a brief overview of the Outlook object model and demonstrates how to incorporate Outlook objects in your

 

Access applications.

 

Managing Discontinued Data

Stu Alderman

11

 

Article

 

Relational databases are well enabled to support the entry of accurate normalized data. Unfortunately, there are few

 

capabilities in relational databases to assist in removing data as it becomes obsolete. In this article, Stu discussed how to

 

manage data

 

Summarizing Data on a Report: When Crosstab Queries Aren’t Enough

Karen Clark & Michael Keller

13

 

Article

 

A typical report based on a crosstab query displays row headings down the left side of the report and column headings across

 

the top, with only one calculated value at each row and column intersection (such as sales for each customer for each month).

 

Michael and Karen demonstrate how to create a spreadsheet-like report for data that needs to be summarized over some time interval, with subheadings for the columns, which allow you to summarize more than one value for each row and column intersection (such as sales, payments, and discounts for each customer for each month).

 

 

 

 

 

Article

 

 

 

ad3468x60

 

 

 

Sorting Arrays of Strings

Ken Getz

17

 

Access Answers

 

This month, Ken goes digs in deep on one question: sorting an array of strings.

 

I need to be able to sort an array of strings. I can’t believe that Access doesn’t include this functionality! I mean, it certainly knows how to sort things itself. Why can’t it make this available to my code?

 

 

 

Easy Backup of Database Objects

Helen Feddema

22

 

Smart Tip

 

Here is a macro to put into your AutoKeys macro group that lets you easily create multiple copies of a database object, so you

 

can go back to a former version after making changes to an object.

 

Preload Objects for Easy Debugging

H. Stephen Reinheimer

22

 

Smart Tip

 

I debug Access Basic and VBA code daily. Access does not provide a complete debugging environment. Often, I want to view

 

tabledef, querydef, form, or security information. It is not easy to view this information unless I am in the middle of a function or

 

Using Optional Parameters

Paul Litwin

23

 

Smart Tip

 

Access 95 added support for optional parameters using the Optional keyword. Discussion of how to use them in Access 95 and

 

Access 97.

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software