Very Computer

by **Avery Peric** » Wed, 09 Jun 1999 04:00:00

Every time that I try to use DAO with a database that I created in MS
Access 97 and try to use FindFirst, FindLast, FindNext, FindPrevious
statements, I get a message that says "Runtime Error 3077: Syntax error
(missing operator) in expression." I don't know what it is that I am
missing as this code worked great with the Northwind database that came
with VB6. Here is my code:

Private Sub Command1_Click()
Data1.Recordset.FindNext ("Buyer = " & Text4.Text)
End Sub

Someone please tell me what I am doing wrong! Thank you!

by **Tony Fountai** » Thu, 10 Jun 1999 04:00:00

First, what's the value of Text4.Text? Are there any quotes or anything?
Secondly, you need to surround string values with quotes.

--

Later,
Tony Fountain, MCP
===================================================
Please do not email me directly, my wife already clutters up my inbox
===================================================

Quote:> Every time that I try to use DAO with a database that I created in MS
> Access 97 and try to use FindFirst, FindLast, FindNext, FindPrevious
> statements, I get a message that says "Runtime Error 3077: Syntax error
> (missing operator) in expression." I don't know what it is that I am
> missing as this code worked great with the Northwind database that came
> with VB6. Here is my code:

> Private Sub Command1_Click()
> Data1.Recordset.FindNext ("Buyer = " & Text4.Text)
> End Sub

> Someone please tell me what I am doing wrong! Thank you!

Very Computer

Runtime Error 3077: Syntax error (missing operator)

Runtime Error 3077: Syntax error (missing operator)

Runtime Error 3077: Syntax error (missing operator)