Search results

I am trying to disable certain form controls based on a combo box selection. The combo box looks up a product list in a products table. However I am not disabling the form control based on the first column combo box value but the value of column in the same record. Private Sub...

Will this return the maximum value of the lot number. The lot numbers may not be larger or smaller then each other, as they have text. What I'm looking for is returning the lot number that was entered for THAT product. this value may be higher or lower then the lot number that is being entered...

Hello In my quality control database QC techs will be entering in test results. Each quality control entry they put in will have a product and lot number it is related too. My question is about making data entry easier for the QC techs. When two jobs are being run at once, the techs may have...

Ah this works However I want the user to still be able to edit the record after clicking out of the msgbox.

No. I mean that the user is editing an existing record. I want the user to see a warning informing him is editing EXISTING data, not entering new data. Our QC techs can get a bit trigger happy and I don't want them writing over existing records accidently. Ideally I'd like it to say "Warning...

This may be a simple question. But how do I have a message box pop up that warns the user he is about to edit an already entered record? Is there a setting for this in the form design. Or do I need VBA, in which case what form event would I tie the msg box too?

Hello. I am designing a quality control database to store data regarding my company's production runs. Here is a picture of the relationships http://i.imgur.com/yEt9yY3.png The product table contains the product name with its QC specifications. The lot number table contains the unique...

Here is an example of the handwritten QC Form that I am trying to emulate in my QC Data table with Access. http://imgur.com/pK8V43W

I don't see how I can do this with time series data. Every record stored is a from a sample taken at a specific time (with different tests being performed at different intervals). Also some tests are quantitative, some qualitative, some numerical, some text. How would I account for that by...

My QC Data table EntryID Product LotNo Time BoxNo TestA TestB TestC TestD 1 PE-500 1212 8:00 1 50 75 80 2 PE-500 1212 8:30 2 55 80 85 the QC Data table is the same for all the products however the...

I believe my tables are normalized as I understand the term. My tables are like are Products, Lot Numbers, and QC Data. Every product has multiple production runs (which means different lot numbers) and the QC Data gets (up to dozens of entries over time of production) entered for each...

My goal is to generate a certificate of analysis from a quality control database. There are different products each requiring a different tests (meaning different fields are entered) in the database. My report will be based on a query for a specific lot number for a product which will average...

My question involves allowing Null values for the fields on the form. Not every QC entry requires every test to be done so the fields will need to be allowed the values between the fields on the product table (the specifications) and to be left null. What is the proper code to allow these...

I got it working and it looks like everything I need is functioning correctly. This has been a great intro to VBA and understand how it works. Thank you very much for your continued help

Ah yes! I got it working again. My final requirement is making access accept the values entered if a "Not Approved" check box is marked YES. How would I code this logically with the other values?

So I don't know what happened. I was updating the column count and width property of the row source to match the amount of fields and now none of my code referencing the columns in the combo work. The combo is functioning fine. I have the correct amount of columns and the combo looks up the...

Both the fields in the product table and the fields being entered into the QC Info table are defined as numeric but are still require the val function to operate as intended. What else could be causing this? Other then that I updated the combobox to accept all the columns for all the min and...

The me.product.column(3) and (4) are returning IsNull values despite me entering in quantities into the field. I also updated the column count in the combo properties to accommodate the next min and max values (which would be in columns 3 and 4). What am I missing that would make...

Now my question is: I have multiple fields that require validation like this. Do I need to add another beforeupdate event for every field required when I code for the next field required I get an "Invalid Use of Null "error message. this message appears when I attempt to enter a value into the...

This is what I first thought. But both fields are defined as numeric in the table they refer too. edit: the value function works!! omg i'm so happy. thank ya'll