Recent content by mumbles10

This is a re-post... but my first post was vague... For Example if I have a join table like... Company Plane City Delta 1 London Delta 1 Philly Delta 2 London and I wanted to find only Plane numbers that have been to London and London alone... so that...

Thanks for the reply, but I am not 100% sure I know what you mean.

I have a query that I am trying to build... Where I need to find a specific value that is not equal to any other value. For example; Column 1 is Counterparty, and Column 2 is City. There can be multiple Cities for each Counterparty... I need to create a query where I find only the...

That's pretty much exactly what I need it to do. So I have to create the module to find the values? Or did you do that just for the sake of the example? Also, I got an error when I clicked on the "Document My Tables" button. Thanks JDraw...

Combo0 = is the FieldNames for tblInfoForAudit. Combo2 gets the rowsource based on the selection of Combo0. It shows the values of the selection. So if the Fieldname is LastName, it shows all the lastnames. Combo4 is the expression, either "=" or "<>" I was trying to do this from the OnClick...

Yeah... except whenever the user creates the choices based on the 3 combos... I want the query to populate. I imagine I have to build out the SQL Where statement in VBA but having issues... Sub CreateQuery() On Error GoTo Err_CreateQuery Dim db As DAO.Database Dim qdf As QueryDef Dim...

Okay... I have 3 comboboxes... cmb1, cmb2, cmb3. cmb1 is a field list of tblInfo. cmb3 is the values of the cmb1 selection. So say lastname is chosen in cmb1, cmb 3 displays all the lastnames from the tblInfo. cmb2 is a value list with "=" and "<>". My question is, how do I put these...

I figured it out... I created a new form and re did the operation and now it works... weird.

Thanks for the response... not exactly sure what you mean by the last part, in regards to the appending the values to the string?

Ok... I have two comboboxes, cmb1 and cmb2... I have cmb1 rowsourcetype = FieldNames and rowsource = tblInfo. What I would like it to do is populate cmb2 with the list of values based on the users selection of cmb1. From what I have found and read... This needs to be done in VBA based on the...

I got it to work... thanks.

That is what I tried initially but it didn't work.

I know this is wrong... but I am trying to write a DELETE Query in SQL based on certain parameters... Thanks. DELETE tblEmployeeAccess.EmployeeID, tblEmployeeAccess.SystemID, tblEmployeeAccess.EntitlementID FROM tblEmployeeAccess WHERE (((tblEmployeeAccess.EmployeeID) =(SELECT...

Jack... I am glad you are available... I have another question for you... Let's say I had another example... but this time I two combo boxes to populate the two different listboxes. I am trying to do the same thing as before, however, I need the employees to be able to choose entitlements from...

Great, thanks Bob.