Search results

  1. T

    Access 2016: Updating table with subform

    In my database I have a main form view and a subform that allows each individual record/person to have various 'keywords' assigned with that person. Each Keyword can be assigned to multiple people and people can have more than one keyword so I have a junction table set up to model the...
  2. T

    Access 2016 Using combobox in SQL query

    I'm trying to create a query that uses the selection of a single combobox as part of the WHERE clause. The query: SELECT Database.Contact_ID, Database.[Full Name], Database.[Job Title], Institution.Institution, Database.Email, Database.[Email 2], Database.[Work phone]...
  3. T

    Run SQL query in VBA and store user input in variable

    I have a query that allows the user to input the parameter and returns records on that basis. This works fine and displays the results on a form. What I want is to display the user input on that form so if the user has multiple iterations of the form open they know which results set corresponds...
  4. T

    RecordsetClone: "Item not found in this collection" error

    I have a form that shows records that match the users input parameter. On this form I've created a button with the following VBA Sub: Private Sub Send_Email_Click() Dim rs As DAO.Recordset Dim bcc As String Set rs = Forms!KeywordSearch.RecordsetClone...
Top Bottom