Search results

JDraw Thank you so much for all your help. Especially the Mock db. I learned so much from reviewing your code and comments!! I copied everything over to mine and I got the following error on these two lines. Compile Error - Syntax error. 90 rst!Problem ID =...

I see that Pat's code uses a Public Function and I was using a Private Sub. Not sure how these two work together. I also wasn't sure if I should keep my existing code and integrate Pat's or scrap mine so I added his to the bottom. The fields at the top of the form are writing correctly to the...

Here is my latest attempt!!!! I am getting an error on the Select and Where statement so I must not be writing this correctly. Dim varItem As Variant 'Selected items Dim strWhere As String 'String to use as WhereCondition Dim strDescrip As String 'Description of WhereCondition Dim lngLen As...

Help! I have been playing around with this since yesterday and still can't get it to work. I don't know how to write the code for the "The loop would have an rs.AddNew, then the NonConformance record id, your Selected items as ProblemID and an rs.Update" Also, I have will have several...

Thanks for the insight! I didn’t realize this was already a junction table setup until you explained it. It is called Problem_Record. My lstCAR displays a multiselect list of Problems with the Record Source as the Problem tbl. Now I need to write the selected values to the Problem_Record tbl...

You are correct. I made a mistake in my last message. My lstCAR pulls both the ProblemID and Problem. I am only displaying the Problem for the user to see. So, the ProblemID needs to write to the ProblemID in the Problem_Record tbl which ties to the ProblemID in the Nonconformance_record...

Hi, I am an "Advanced Novice" user. I know a little but not a lot! I have a database that I did not design but have been asked to make changes to. I have a Multiselect Listbox lstCAR that I need to write the results from to a table when the record is created. The old database was using a bunch...

Paul I have been playing around with this but I am not familiar enough adding multiple arguments to the OpenArgs. Can you provide the exact syntax. Sorry but I am very new to this!

Can I use this code as provided or do I need to add a fieldname to it?

Paul I like this. Where in the code would I place this statement?

I read through some other posts and I am not sure I can use the Group and Sort. This report is pulled and run each time a different cmd button is selected. For example, I have a cmdManager, cmdCOD, cmdFisalYear etc, All of which run the report from the cmd button.

I am using this code from a cmd on my form to run a report. The report is running correctly and pulling the data but it is not sorting correctly. Can you help me edit this code to make it sort ascending. Private Sub cmdPreviewCategory_Click() On Error GoTo Err_Handler 'Purpose: Open the report...

JHB Sorry for the delay. Had a long holiday weekend. Here is my latest database. The only drop down that is not working is Contract_Staff.

I fixed those two issues but the drop down box is showing the correct listing but it is still not filtering on the subform.

Ok. So I have been playing around with the statement you provided and I got the cboStaff to display the list of employees so that part works. But when I select a Staff from the list their corresponding record shows up on the subform filter but their name does not show in the subform field...

Thank you !!!! that worked to fix my Problem and Category combo boxes. I tried to use the same logic to fix the cboStaff but it didn't work. I think the problem might be with my Row Source for this one. The cboStaff has been driving me crazy for days!!! I know it's something simple. Also...

I have attached my database in a zip file

I have a basic database with several tables. I can get all but 3 of the combo boxes to filter data to the subform and I can't get these last 3 to work. I tried to attach my database but it wouldn't work. This is my first post on any board so excuse me if I am doing this wrong! The combo...