Using A Form To Record Quality Inspection Data

[KComfort]

To Start this Off I am New to the Access World and I am trying to recreate in a more stable, user friendly and secure database a Quality Check Database (our previous one has crashed).



Background - We perform Quality Check Hourly and we (Management) would like to have a Form Where the Operator Selects the Mold, Press and Item - then Another Form Opens and the can enter the Visual Check Indicated (Each Part has different Visual Checks) - that form then populates a Summary Results Table that Can be Exported when needed (there will be another Form for Measurements and Table for Measurement ONLY Results).

How my Database is Set Up:
Tables -
FormData - This Created by a query - This Contains ALL Mold, Press, and Item Details - ALL with a Unique Key of PartID
Inspection Visual - This Contains by PartID all the Visual Checks Needed.
Inspection Results - This Table I would like to Populate from the Visual Inspection Form (Fields listed in the table are unbound field on the form)

Form -
Inspection Step 1 (Linked to FormData Table) - This is where the operator will use the Combo Box to Select the Item (Click Step 2 Button)

Inspection Step 2 (Linked to Inspection Visual Table) - This is where the Operator will Complete the Inspections (P/F) and I would Like the Date/Time, Lot, PartID, Mold, Press and Result all to populate the Inspection Results Table



There is a 3rd Step (Measurement Inspections) - However that form is not completed.

I would like the Result to be Saved as a NEW Record when Any of the Buttons are clicked (Visual ONLY, Press Down or Step 3) so essentially when the form is closed - all buttons are set to close the Form with the next Form is opened.

I have Tried the Link both the Inspection Visual and Inspection Results tables to the Step 2 Form - However when I did that the Visual Inspections did not Populated using the PartID as they Do now.

I have posted this on a couple other Boards (sorry I know that this Frowned Upon) however I have not Received any Responses and I am able to go into more details with the Pictures here.

Am I not setting this up correctly - I am trying to make sure that None of my Tables have duplicate information on them and to follow the whole Normalization Rules for Tables in Access.

[Gicu]

Can you post a sample of your db so we could have a look? You might want to have the step 2 form open in Data Add mode so it always opens at a new record.

Cheers,

[KComfort]

Here you are

[Gicu]

Hi there,
I had a look at your db and I am sorry to say but you need to make quite a few changes. First of all the approach you are using in adding/editing data is prone to fail and worse, to create serious data inconsistencies. Do you realize that in your form1 you are constantly editing whatever record you happen to be on when you change the mold in the combo-box? Usually you would have a Search Mold combobox that is unbound (should go in the form header) and that will bring up the selected record in the details section (using the actual bound fields not references to the combo's columns like you have it). When you add a new combo box to a form Access will prompt you what do you want it to do, look for Find a record on this form.... and it will create the VBA code for it.
Secondly, your naming convention will cause many problems - read about it here https://answers.microsoft.com/en-us/...f-eebd1f4c8040).

In your case the design should be changed to have one main form to list the parts and their details and one or two subforms for the inspections. If each operator has their own copy of the front-end (as they should) then you could automate the operator name to (for example using environ("username" to get the Windows logon).

In any way, I did not spent time to add a new record in the current db as it would not be useful to you once you change the design. Please post back once you made the changes.

Cheers,
Vlad