Search results

The code works only for tables and not query. Can someone tell me what I have to change in my code?: Dim dbs As DAO.Database Dim rsQuery As DAO.Recordset Set dbs = CurrentDb Set rsQuery = dbs.OpenRecordset("myQuery") Set rsImage = rsQuery.Fields("Images").Value While Not rsImage.EOF...

I have query that filters my list in Access. The list can be filtered in different ways(like using a combobox). This is the criteria of the query for the field Title of the table Book: Like IIf([Forms]![frmName]![cmbSearch].[OnClick];"*" & [Forms]![frmName]![txtSearchBar] & "*"; [Book]![Title])...

My data consists of questions and answers. It also shows what the version number is of the answer and shows which persons changed which Answer. Its possible that some questions have the same answer. Table looks like this: questionID Question answerID Answer VersionNr...