quote:
Originally posted by CookieRevised
1) A nice trick to do if you don't know enough about SQL is to do this with a query inside Access itself: Build up the query (using the wizards, help function, etc..) and after you have the correct query of your likings, view the "SQL-code" of that query (top-left button in the buttonbar where you can select "query-view", "result-view", "SQL-view")
2) Dunno... maybe the method "SendKeys" will do it for you (although very crappy thing to use in almost all cases)... or maybe there is an API for it... just guessing here...
I do know how to write SQL code myself, i'm just not sure how to get it to search for something that is similar rather than identical to an entry in my database. Is this possible?
RileyM