Complex function with conditional message boxes, calculations, auto adding in form/table

[gaker10]

Complicated is being generous, hehe. This is an Engineering process so it gets much more technical.



Is there such code to implement a check pre-export?

[June7]

Access doesn't know what's valid or not. You define the conditions and evaluate data. You can do that manually (eyeballs on tables, record by record) or automate with algorithm (queries and/or VBA code).

[gaker10]

Right, I can implement some conditions, I'm just not sure where or how. It does not take much for one person doing a job to overlook things. A second set of eyes is really the only help, but there are few of us. So, I need to program the "second set of eyes". Also, going through 100+ records can make anyone lose their mind, me included. Perhaps I can implement a part type (transitions, sleeves, boots, wires etc in the parts database), and do a check that way?

[June7]

Possibilities are endless. I don't know your data and business process. Queries could be structured to return records that meet criteria, such as "SELECT * FROM table WHERE [field1] = 'transition' and [field2] Is Null;". If the query returns records then you have invalid data to fix before export.

[gaker10]

I'm afraid it would be more complicated than that. A customer might specify a different tape for every transition and if every transition is a different type, it would be calculated differently. I'll play with the product categorization idea, since we need to re-do our commodities anyway. Thank you