Search results

YES!! I got it to work. I am so happy I almost flipped my desk over. The msgbox opens up with quantity is required if nothing is entered. However, regardless of the value I put into the field, the "valid range is between 25-30 still appears, even if the value is between those numbers. What...

Okay good I have done exactly this with the combobox for selecting products. My confusion is arising when go to type the above code. When I type to reference Carbon black QC data, the field shows up selectable up in a drop down menu. When I go to refer to the min and max values contained in...

I put this project on hold for a bit now i am back to it. I have added two columns to the product table titled MinCarbonBlack and MaxCarbonBlack. I have made a combo box that has row source of the 3 fields now in the Product table (Product, MinCarbonBlack, MaxCarbonBlack) I am trying to...

Hello everyone I have two tables, Production Table and Material Usage Table. I am generating reports using a parameter query (for each production run) for both of them. The material usage query contains calculated fields using fields from both tables. When I run a the query for a unique...

Hello I am developing a database for production reports. I want the person to enter in the production data (which is organized by production lot number) into form then be able to print a report for THAT SPECIFIC lot number (one record) So I set up a parameter query that prompts them to enter...

Thank you. This is making more sense to me as I learn more VBA. When you say "row source" you just mean the columns the code is looking to for the values? "Combo" is defined as...?

Hello My last question was answered very quickly and I am thankful for that. If this question is too basic I am sorry. Is there a method of setting the default value for new entries to the same value as the previous entry? For example, I have a quality control information table that stores QC...

Thank you So apparently this isn't easy to do as I thought. The code you posted is visual basic correct?

yes I have. I have those 3 tables. Products has a one to many relationship with both lots and QualitySpec. While Lots has a one to many relationship with QualitySpec.

Hello everyone. I am (kind of) new to Microsoft Access and have a question about making validation rules more complex. I am making a quality control database with 3 tables. One containing the product and their unique codes, the 2nd with their unique lot numbers for each different production...