Navigation:  Articles >

Feb-2003

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2003-02

 

---ad2468x60

 

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.

 

Coming Next: Access 11/XP

Peter Vogel

2

 

Editorial

 

Microsoft has posted a white paper about what to expect in the next version of Access. For the past two years, we here at

 

Smart Access have been guessing about what you’d need to know next. Read more on Peters conclusions about this post.

 

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.

 

Crystal Reports 9’s Microsoft Access Repository

Gord Maric

11

 

Article

 

Like many other products, Crystal Reports uses Microsoft Access under its hood. Gord Maric shows you how Crystal Reports

 

uses Access as a repository to build reports with shared components. With that information, you’re just one step away from

 

managing th

 

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.

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software