Search results

Fixed it!!!

I have a number of text boxes and comboboxes on my form. All of these are writing to the table except the checkbox. I made sure the Default value is 0. All the other boxes including this one all use the same query for the Control Source and Form Record Source. Is there anything else I should...

The database is used for Quality Assurance of contracts. Reviewers are assigned a number of contracts per period to review for accuracy. This form allows them to enter the contract information in the database via this form. The top of the form captures the contract info and the listboxes...

jed, This part of the code work correctly ( it writes the NonconformanceRecID and PRoblem ID for each record in the Problem_Record table When I add your code I get an error message. Error 3201 You can not add or change a record because a related record is required in nonconformance_record...

Before we changed to this new form, the users had the ability to provide a Description for anything they wanted which led to a lot of anecdotal information. By going with the form we are using this as a way to control their input. I would "Love" to be able to limit the input to allow only when...

That is correct. The auxillary problem text is captured in the Description field and stored in the Problem Record with the NonconformancRecID and ProblemID All the records in the Nonconformance Record tbl are kept so we can run reports and queries on which contracts or Contract Specialist or...

You are absolutely correct! The Problem tbl is a defined list of items per lstbox that we are tracking. The Other (ProblemID 8) allows us to track "one off" items so we see if there is pattern that we need to start formally tracking. There is no additional Business Description. That is all...

Here is pic of the Form. The top section writes to the NonconformanceRec tbl. Working fine! The lstCAR displays ProblemID, CategoryID and Problem. User can mulitselect from this box. If they select ProblemID 8 we want them to provide a Description of the Problem because it does not meet the...

You have the concept correct. "Only the ProblemID would be in the Problem_Record table -and if more than 1 problem applied to the same Nonconformance record, then there would be multiple records in the Problem_record table. There would be (in the junction Problem-Record table) 1 record for each...

JDraw, In my delirium at 1am I thought I had this working. Well it 'kind of' worked! When I added the code for the texbox it worked by writing the Description to the Problem_Record tbl when the ProblemID=8 However, it was not writing the Description on the line which has the ProblemID =8, it...

JDraw I'm sitting here at 1am and I finally got it! Sorry you had to repeat it so many times before it finally sunk in ! Your advice has been invaluable to me. I should be able to turn this in once we get out of this East Coast blizzard! Thank you again for your patience and coaching!

Your Mockup.db has this correct. How would you write a Description to that tbl what way you have it designed.

1. The following items are writing to the Nonconformce_rec. : ProbelmDivision, FiscalYear, Quarter, ContractNumber, ContractSpecialist, Contracting Officer, My Name, No Finding 2. The Description needs to follow the Problem_Record. The Problem tbl is a static list of Problems with a ProblemID...

JDraw Thank you so much for all your help last week. I am really learning a lot from this project. I used the weekend to clean up the db as best as I could. I removed the duplicate Description field from the Nonconformance_rec tbl. As this point in time I don't think I have the knowledge to...

lstJust is one of seven listboxes on the page that I will need to cycle through the Items.Selected. They all use the same Rowsource as lstCAR but I use CategoryID = to display the correct set of items base on a specific CategoryID. When I copied the code and changed the listbox name I got the...

READ FIRST I just looked at your Mock db and you have it correctly in there. The problem_record tbl does have the Description in it! How do I get that field for each Item.Selected in the listbx.

I rechecked putting the Problem Description in the Problem tbl and here is why it won't work. Each time a Nonconformance Record is created it is selecting the type of Problem from the Problem table (finite list) via the ProblemID. It then creates both a Nonconformance Record which is contract...

Thanks I was trying to get around putting the Problem Description in the other tbl but I will give it a shot. It does seem to make more sense with the lstbox. I copied this loop section of code fir the fist lstbox and added it right below the last End With for the next lstbox but I am...

I'm having trouble getting this Description box to work correctly. I added the field to my form using the Field List. I selected the field Description_Probelm_record. I can't test it because it won't let me enter data in the field. I made sure it wasn't locked and looked for other things that...

SUCCESS! The logic works perfectly once I changed the fields names! (no small feat in an existing database). I will need to use the extra line of code for the Description. The Description field which was part of the old form was a "comment" field that was there for explanations. The old...