I am starting to change my estimating program from an EXCEL to an ACCESS based program. The start up menu will include 3 main buttons: old estimate, current estimate, and new estimate. The old estimates are completed, the the current is in progress, and the new is self evident. each estimate has its own number. Any suggestions on a way to handle each so that they are group accordingly. Thank You in advance. Tom
Are you wanting a record for each
Or could you just have an Estimate Type and switch it when necessary
Thomas GardegaOP
@Reply 4 years ago
Thank you Alex for your reply,
Each estimate is a very detailed event with multiple levels, rooms and different assemblies with associated quantities etc. When an estimate is completed it will result in a bid document, which may or may not result in an approved contract. these estimates should then be locked against change and I suppose should be check marked completed and submitted. All of these are the old estimates. The current estimate is the one in progress., The new one that is just starting. To answer your question each have to be saved as a separate entity (by estimate ID). the older estimates will need to be in a drop down list but current and new have a single choice each.
Tom
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.
