Search results

  1. K

    Different validation rules for different product entries?

    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...
  2. K

    Different validation rules for different product entries?

    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...
  3. K

    Different validation rules for different product entries?

    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...
  4. K

    Query with calculated fields across Multiple Tables returns duplicate values

    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...
  5. K

    Setting Query as record source for report causes crash?

    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...
  6. K

    Different validation rules for different product entries?

    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...?
  7. K

    Setting default value for new entry as previous entry

    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...
  8. K

    Different validation rules for different product entries?

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

    Different validation rules for different product entries?

    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.
  10. K

    Different validation rules for different product entries?

    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...
Back
Top Bottom