Another Stupid DB Q

[Dayo312]

Grr..
Another error.

Umm.. Ok I Wrote ..

SQL = "select * from categories where description like " & Chr(34) & Text1.Text & Chr(42) & Chr(34)
Data1.RecordSource = SQL
Data1.Refresh

And It said
"The Microsoft jet engine cannot find input table or query. Make sure it exists and the name spelled correct."

The Dbsourse is called "General"

Whats wrong??

[jritchie]

So whats with all the char characters?

Try something like

Dim rRecord as Recordset
SQL = "SELECT * FROM Categories WHERE Description Like '" & Text1 & "'"

-> Categories must be a recordset name and Description must be a field in that recordset.

set rRecord = General.Open(SQL)

Any Help.

[gravyboy]

Try



sSQL="SELECT * FROM sometable WHERE sometable.somefield='" & Chr(34) & Text1.Text & Chr(42) & Chr(34) & "';"

Data1.RecordSource=sSQL
Data1.Refresh




------------------
Matt G
Either mattg@gravyboy.fsnet.co.uk] or matt.graveston@centrica.co.uk

[kishore]

Basically the error is saying that it could not find the table or query name Categories in your database.

You should check and see if there is 'Categories' in your database.

Good luck.