[AccessD] Re: How to do an Admin Table

John,

tsys_Defaults

DefaultID               Autonumber  PK
DefaultDesc             text(20)  Unique Key
                                 (i.e. Mileage Rate, Call Phone Rate, etc)
DefaultNbrValue         Number (double)
DefaultTxtValue         Text(10)

With this, you can do a lookup for whatever value you want to use and not 
have to add columns to a table when you get new requirements.

Robert

At 03:42 PM 2/6/2004 -0600, you wrote:
>Date: Fri, 06 Feb 2004 14:24:54 -0500
>From: "John Clark" <John.Clark at niagaracounty.com>
>Subject: [AccessD] How to do an Admin Table
>To: <accessd at databaseadvisors.com>
>Message-ID: <s023a3e1.054 at nebnov1.niagaracounty.com>
>Content-Type: text/plain; charset=US-ASCII
>
>Forgive me, if this is an easy one, but I've even asked someone that
>teaches the Microsoft Access certification classes, and they didn't know
>how to do this either--or maybe I wasn't clear, when I asked.
>
>I have had many programs where it would be useful to have an "admin"
>table. This table would contain one single record with information
>referenced in other parts of the program. For instance, I have a program
>that figures monthly mileage for our county legislators, but it is
>currently setup so that the rates are hard-coded and I have to alter
>them everytime they are changed. I would like the user to alter this
>themselves.
>
>I have also thought about using this for programs--maybe in their
>splash screens--to list the current directors names, and other info that
>may or may not change in the future.
>
>Any ideas how?
>
>Thanks ahead of time...because I know if it can be done, somebody on
>this list knows how to do it!!!
>
>John W Clark
>
>John W. Clark
>Computer Programmer
>Niagara County
>Central Data Processing