Navigation:  Articles >

Nov-1998

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1998-11

 

---

 

An Access Nightmare

Andy Baron

1

 

Article

 

 

A very serious bug has been lurking in Access, possibly since version 2. Andy describes the problem and provides an effective workaround.

 

 

 

Bugs and Quality

Peter Vogel

3

 

Editorial

 

Peter discusses the reality of bugs and Access

 

Use Excel to Analyze and Graph Access Data

Sanjay Singh

6

 

Article

 

Excel is an excellent tool for analyzing and graphing data. Here's a "generic" utility to transfer data from Access to Excel. It's so

 

generic that it can be used to create complete graphing solutions without one additional line of code.

 

Charting Variable Ranges in Excel

Sanjay Singh

10

 

Sidebar

 

Charting Variable Ranges in Excel

 

An Access Control Panel, Part 2

Ivor Davies

11

 

Article

 

The first article in this series described how to capture information on database objects (see "Building an Access Control Panel" in

 

the September 1998 issue). Part 2 examines how to store that information using DAO and the Documents collection.

 

Adding Database Tools to Excel Spreadsheets

Garry Robinson

17

 

Article

 

Microsoft Access 95 supports using Excel as a database through the Link table manager. Here's how that works using a Contact

 

software database that allows you to manage Company and related information. While the data is stored in Excel, the Contact

 

Manage

 

SQL Discrepancies, List Boxes, and Still Trying to Get a Date

Peter Vogel

19

 

Article

 

Teaching for Learning Tree International, Peter gets peppered with questions, many of them about Access.

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software