Like Operator

  • Thread starter Thread starter vanessa
  • Start date Start date
V

vanessa

I would like to use the like operator in the following
sql statement:

strsql = strsql + "WHERE fldfrom = " & Chr$(34) & Me!
txtfind & Chr$(34)

You see right now users have to fill in the exact string
value for the field fldfrom to find a matching record.
How can this be done?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting form thru code 1
Need help in printing vba code 0
Correct syntax for using Print #() function to write all fields 3
Timing problem??? 4
Remove Quotes within Data Values 1
how can I correctly build the UPDATE action query? 1
Access 2007, Passing parameters over to a query 4
Incorrect syntax for dynamic Update query 1

Back
Top