[AccessD] How to do an Admin Table

Think of it as a lookup table.
For the directors names, addresses, etc.
You can use domain functions to glean the values.
Use the table for the splash screen.

In your case, I would have at least two tables, one for directors and
another for mileage.
The mileage table would have rates and effective dates.
Add a row for the next effective date range.  That way, a person can
recalculate for any given period.

HTH
Jim

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com]
Sent: Friday, February 06, 2004 1:25 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] How to do an Admin Table


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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com