DuncanMcCloud
Last Activity: Dec 9 '11, 09:13 AM
Joined: Oct 20 '11
Location:
-
Thank you for the tips :) -
Thanks for the tip Stewart. It is something I would have to get used to :)Leave a comment:
-
Thanks Stewart.
I have the following to add:
User:
check your bracketing
just guessing qu is a variable defiend as ' or ".. you...Code:Dim name As String dim strSQL as string name = "Site Establishment Dismantle" strSQL = "SELECT Description from BOQ WHERE Description='" & name & "'" Set rs1 = db1.OpenRecordset(strSQL, DB_OPEN_DYNASET)
Leave a comment:
-
Syntax error (missing operator) in query expression...
Hi All,
I am getting the following MS Access error:
Syntax error (missing operator) in query expression '(((BOQ.Descrip tion) =Site Establishment Dismantle))'
For the following VBA statement:
...Code:Dim name As String name = "Site Establishment Dismantle" Set rs1 = db1.OpenRecordset("select BOQ.Description from BOQ where " & " (((BOQ.Description) ="
No activity results to display
Leave a comment: