Well, as this is my first major project, I am prone to say that it could be weak all over. I have questioned the design from day 1, trying out examples from other users and my own logic. Then, the use of temp vars, queries and vba.
Admittedly, the forms are not visually aesthetic yet, but that is not real important at this time.
I suppose if you were to critique the design (table structure that is), some additional info might help. Obviously we are attempting to track parts inventory. We have three separate areas that parts are kept, because we have multiple buildings. Each area has their own labeling for exact part location. Some parts are stored in multiple locations because they are used on multiple equipment.
The parts rooms are not manned 24/7 and therefore are open to anyone looking for something. So, we want to track who takes what and when. We also want the maintenance to perform semi-annual stock takes. We also want the parts manager to be able to add, edit, delete parts and suppliers.
You may notice that I've been playing with record sets in vba versus using queries. Still not sure if one is better than the other for certain functions.
I will be on today and perhaps tomorrow. I am developing this on my normally off days, usually two days a week.
