Recent content by fred90

I found the problem. I have to add another loop. access-programmers.co.uk/forums/showthread.php?t=228146

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])...

Thanks for the help. :)

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