I am trying to make an estimator application for a friend who is in the business of fabricating aluminium-and-glass casements. I have managed to break down the requirements into a neat little database that starts with products and breaks them down into components and parts and applies formulas on the parts to compute the precise lengths of each raw material based on the measurements of each product on order. I want to save the computed results in another table called "Requirements" that will have the [ORDERID]+[ORDERDETAILSID]+[PRODUCTID]+[COMPONENTID]+[PARTID]+[FORMULAID] as the composite key. This will enable me to query for any particular combination of requirements as needed.
Where I am stuck with my rusty VBA skills (I used Access extensively in the mid-1990s), is how best to design a form where the user can define each formula e.g. PartXLength = "(Height / 2) -7.5" or Rivets = 4. I am thinking instead of saving the formula as a multi-field row, it would be best to save it as a string field and then translate it when needed.
Question is: How to write all the code needed to translate very different formula strings?
Attached is the zipped mdb. I have had to strip it of all the forms and queries to get it to the 500Kb limit, so bear with me if it does not make much sense.
Any help will be appreciated.