Recent content by Access1981

  1. A

    Multiple Default Values in ComboBox

    Very new to Access, so I am not sure about what it is. I think ComboBox with multiple values. By clicking the field you get a list with tickboxes. Multiple boxes can be ticked. The ComboBox value options are based on another table. Property sheet reads: Selection type: Combo Box Row Source...
  2. A

    Multiple Default Values in ComboBox

    Thank you for the reply. Could you maybe provide a link that explains the "best practice" alternative to the lookup? Regarding the second part, I wanted to give additional detail but may have complicated things. Basically what I want is that if a new entry is created via the form, the lookup...
  3. A

    Multiple Default Values in ComboBox

    Hi, could somebody please explain how I can set multiple default values in a ComboBox in a form. The ComboBox is based on a table and my main table also uses the ComboBox. Example: Main table has a column "Brands". The ComboBox is based on another table which includes the following items...
  4. A

    Desperate: How to activate query criteria for multi-combo box via form

    Just in case somebody cares for the solution: - I built several queries, each checking one criterion - I wrote VBA code that builds the SQL code, by using a lot of IF(x,a,b) that write the string depending on which switches in the form are selected. - An important help was to write the SQL code...
  5. A

    Desperate: How to activate query criteria for multi-combo box via form

    Thanks for the reply and sorry for the confusion. I meant VBA, but am used to use the term macro interchangeably (which I am sure is incorrect). The reason why I was talking about combo boxes is that my main tables (hairdressers and customers) both use combo boxes. E.g...
  6. A

    Desperate: How to activate query criteria for multi-combo box via form

    Thank you for the link. Very helpful! Current plan on what I read: 1) Make a query for each criterion (e.g. budget of customer vs. price services, services wanted by customer vs. services offered by hairdresser) 2) Write a macro that uses IF( , ,) statements to write the SQL code that will...
  7. A

    Desperate: How to activate query criteria for multi-combo box via form

    Thank you for the reply and the "welcome". I am indeed new to access, but experienced with Excel and (some) VBA, so naturally I was looking into code that would "insert and join" certain tables in the query. No success though. Generally, the problem (enabling to activate query criteria via...
  8. A

    Desperate: How to activate query criteria for multi-combo box via form

    Hi, I am trying to make a form where the user can check/uncheck query criteria via several check boxes. The idea is that the user can start with many criteria and then deselect criteria if the search does not return enough results. I have been setting up several queries and thought I would...
See more
Back
Top Bottom