Recent content by PG1

Thank you. I'll take a look.

When I change the criteria on the 'Production Query' to reference any of the combo boxes (for example: [Forms]![Production Query Form]![CboJobNo]) the result of the query is blank.

Here's a zip of the file.

I have two main tables - one for production and one for quality. Production will enter: Date part was made, part number made, quantity of that part number made, operation that was performed. Quality will enter date a part was rejected, part number of the reject, operation the reject came from...

Ok, sorry for confusion. Yes, we are a manufacturing plant. We currently record out production and fallout (defects) in multiple excel spreadsheets. This makes calculating yields difficult. I am working on having this data entered into Access so that we can query the data by date, name of...

Here's the jpeg Thanks!

Hello Access Gurus, I need help. Background: I am storing date, an operation name (weld, drill, etc), part number, Machine number, Quantity into a table called Production. Part number, Operation name, machine numbers are each listed in their own tables. When I enter data via a form into the...

I've tried that and when I do, that particular field is written to the table as I want. However, the 'child' combobox called 'MachNo' then doesn't display any values on the form. The reason for displaying the data I want to see the way I want to see it is for exporting to Excel.

Yes, but I guess I wasn't clear. What you show isn't the issue. The table that the combobox records to for operation name is recording the ID number and not the actual name. I've attached two screen shots. First is the form with the data I entered which is for the weld operation. The second...

Thanks for taking a look at this. I reviewed the amended file but it does the same thing as the original. When I run the 'Production_Entry_Form' entering the required information and save, the production table will display the OpID in the Op field instead of the name of that operation. I just...

I've attached the database. Thank you.

I'm confused. I've tried different combinations of column count, column width, and bound count. If I change the configuration in OpName to record the actual name in that table, CbMachine (combobox for machine) goes blank. If I configure the form to have the names displayed in the comboboxes, the...

What I'm attempting to do is have the description appear in the table, not the ID number.

MS Access wizards - I need help. I have a form which has two combobox drop downs that I've linked so that the second changes depending on the first entry. The first combobox is CboOpName and the second is CbMachine. What it does is only display the respective machines dependent on the...

Thanks for the help. I can run a query and get correct results. I queried each table separately with summing the data that I needed and then built a third query that pulls the results and calculates. Might not be the most eloquent solution but it works. I do have issues (don't we all?) with...