Search results

  1. M

    Finding a particular record

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

    Query equal to a specific instance

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

    Query equal to a specific instance

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

    Combo box to pass criteria to Query

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

    Combo box to pass criteria to Query

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

    Combo box to pass criteria to Query

    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...
  7. M

    Combo box to pass criteria to Query

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

    Cascading Combobox based on FieldList

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

    Cascading Combobox based on FieldList

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

    Cascading Combobox based on FieldList

    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...
  11. M

    Delete Query... SQL not working

    I got it to work... thanks.
  12. M

    Delete Query... SQL not working

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

    Delete Query... SQL not working

    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...
  14. M

    Jack... I am glad you are available... I have another question for you... Let's say I had...

    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...
  15. M

    Listbox Troubles

    Great, thanks Bob.
  16. M

    Listbox Help

    Jack, I actually sent you a private message. Let me know if you didn't get it. I had another question for you. Thanks.
  17. M

    Listbox Troubles

    Thanks Bob... Here is the funny thing... I changed the join on the qry and now the form updates... however I still get the Runtime 2450 error saying it can't find the form. It updates the listbox okay but the error still appears... Any thoughts?
  18. M

    Listbox Help

    Wow... very impressive. Thanks jdraw. The more and more I use Access, its amazing how many different ways you can do the same task. Thanks again.
  19. M

    Listbox Troubles

    Yeah... its bound to the tblEntitlements. the form just has the EntitlementID (which is an Autonumber) and the Entitlement Name... I was just trying to create a new record from it. Should I be doing something different?
  20. M

    Listbox Troubles

    I was one step ahead... (for once). I added the correct form name and it didn't work.
Top Bottom