Initialize database

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

John Hipskind

My DB is a set of standardize tables, forms, etc. that is
copied to each construction project folder and renamed;
each project having its own DB.

I've created an "Initialize" form for that data which is
repeated throughout a project's DB objects, such as
Project Number. (This data varies from project to
project, but is the same within any given project.)
I've been able to get a project's various forms to accept
most of my "initialized" values as their default, using
code suggested by Marsh.

Where I'm having a problem is illustrated in this example:
Each project may have a different number of days after
which a response to a Request For Information (RFI) is
considered late.
If I use =[Date:]-Date()-10, for example, in the Control
Source of my report's field set up for that purpose, I
get the right answer--if 10 happens to be the number of
days allowed for a response.
But rather than go in and enter the number of allowed
days in that report for each project, I'd like that
number to be one of my "initialization" values.

How can I do this? In this example, "10" needs to be a
variable that is assigned in the Initialization form.

Thanks.

John
 
How can I do this? In this example, "10" needs to be a
variable that is assigned in the Initialization form.
Click to expand...

Store it in a table (Initialization is a decent name) and use DLookUp
to retrieve it in the expressions where it's needed.
 
Back
Top