K
Kevin
From a construction project management application, I
would like to create code to launch Excel and load the
last revision of the last estimate of the current project.
The form involved is based on the Projects table; the
ProjectNumber is the primary key. A subform holds all
estimates. Revisions are not tracked.
Our naming convention is:
<projectnumber>E<estimatenumber>[R<revisionnumber>], e.g.,
04003E1
04003E2R1
04003E2R2
Can anyone point me in the right direction?
Kevin Sprinkel
would like to create code to launch Excel and load the
last revision of the last estimate of the current project.
The form involved is based on the Projects table; the
ProjectNumber is the primary key. A subform holds all
estimates. Revisions are not tracked.
Our naming convention is:
<projectnumber>E<estimatenumber>[R<revisionnumber>], e.g.,
04003E1
04003E2R1
04003E2R2
Can anyone point me in the right direction?
Kevin Sprinkel