Recent content by Rye Roxley

No Just Option Compare Database I don't get any errors just no match.

fldSiteName = '"Rye Roxley''s"' This matched with the record that contains "Rye Roxley's" (including the opening and closing double quote). Only if I use Set rsSites = db.OpenRecordset("tblSites", dbReadOnly) I get no match if I use: Set rsSites = db.OpenRecordset("tblSites", dbOpenDynaset)

Thanks for the help and suggestions I have made some progress! This works: Sub doublequote() Dim rsSites As DAO.Recordset Dim findcriteria As String Dim db As DAO.Database Set db = CurrentDb Set rsSites = db.OpenRecordset("tblSites", dbReadOnly) 'Quote = "Rye Roxley"...

Can someone help me find this, please? Currently, I am using this but there must be a more elegant way: Sub Test() Dim rsSites As DAO.Recordset Dim Quote As String Dim findcriteria As String Set db = CurrentDb Set rsSites = db.OpenRecordset("tblSites", dbOpenDynaset)...

Many Thanks all I will try your suggestions later. Yep, some of the data has double quotes and there is nothing I can do about it! It is how it is imported and then how it needs to be exported later! No it's a typo!

Hi I know escaping double quotes has been covered but I just cannot understand it in my situation. I wish to search through a record set with rs.FindFirst. The entry I wish to find is already within double quotes e.g. "Street Name" So I set a variable Address1 = """Street Name""" escapedAddress1...