Other Topics > Smart Access 1996-2006 > Feb-2003

Feb-2003

<< Click to Display Table of Contents >>

Navigation:  Other Topics > Smart Access 1996-2006 >

Feb-2003

 

Smart Access Article Abstracts

Page

 

 

2003-02

 

---

 

Using Invisible Forms to Track Users

Tobi Hoffman

1

 

Article

 

Migrating a project into the Citrix platform provided a workable environment for Tobi Hoffman’s company’s people nationwide to access a single database, yet presented some unexpected challenges. Since Citrix forces all users into a single application, keeping track of users’ individual security clearances was almost impossible—until the application got a form that no one saw.

 

 

 

 

 

 

 

 

 

 

 

 

 

Navigation Through Recursion

Christopher R. Weber

8

 

Article

 

Knowing your way around your Access project is important for any developer. In this article, Christopher Weber demonstrates his recursive query and the reporting techniques he uses to generate a tree navigation map of a database. Along the way, he builds a reusable module that uses Access graphics to draw hierarchies in reports.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

An Object-Oriented Speed Tip

Peter Vogel

12

 

Smart Tip

 

An Object-Oriented Speed Tip

 

Using Triggers

Russell Sinclair

13

 

Article

 

Last month, Russell Sinclair explained the anatomy of triggers and how they work. In this month’s instalment of 'Working T-SQL,' he shows you how to write triggers and how to put them to work in your database application.

 

 

 

 

 

 

 

 

 

 

 

 

 

Combining Tables

Peter Vogel

18

 

Access Answers

 

This month, Peter Vogel looks at reporting from two tables where one table overrides entries in the other table.

---

 

 

 

---