K
Kevin Sprinkel
We currently maintain our project schedule in Excel, but
are migrating it to an Access application. We perform
several estimates and estimate revisions for our clients,
and name the Excel estimate files per the following syntax:
<projectnumber>E<estimatenumber>[R<revisionnumber>], e.g.,
04003E1
04003E2R1
04003E2R2
The project number is the primary key to our Projects
table, and each estimate is given a number by the user.
It has an autonumber primary key and an FK field to link
it to the Projects table. In the many data form, the
Estimates are in a multi-record subform. The revisions
are not tracked.
I would like to load the last revision of the last
estimate file for review by some means (our most typical
need), and also to load any specific estimate on demand.
If revisions exist, a combo box should display the
revision # and file date.
Can anyone point me in the right direction?
Kevin Sprinkel
are migrating it to an Access application. We perform
several estimates and estimate revisions for our clients,
and name the Excel estimate files per the following syntax:
<projectnumber>E<estimatenumber>[R<revisionnumber>], e.g.,
04003E1
04003E2R1
04003E2R2
The project number is the primary key to our Projects
table, and each estimate is given a number by the user.
It has an autonumber primary key and an FK field to link
it to the Projects table. In the many data form, the
Estimates are in a multi-record subform. The revisions
are not tracked.
I would like to load the last revision of the last
estimate file for review by some means (our most typical
need), and also to load any specific estimate on demand.
If revisions exist, a combo box should display the
revision # and file date.
Can anyone point me in the right direction?
Kevin Sprinkel