I need to generate/run a query based on a form input with VB

[joelindquist]

Here's the deal. I am building a knowledge base for my employer. One of the requirements is that it has a Boolean search tool (term1 and term2 or term3 not term4). I've successfully coded a function in PERL which parses the input, and generates a SQL query from the input string.

With help from MichaelRed, I've got the VB pretty much done, I am just stumped by getting the input string from form VBKEY, and by executing the dynamically created query. I will then need to populate a combo box with the query results.

It's probably pretty simple, but I am just learning VB.

Thanks for any advice, Joe

 

[joelindquist]

OK. All I really need to do now is execute a query contained in a string. After reading the help files contained with Microsoft Access, I was thinking that I could use the DAO function QueryDef, but I get an unknown object type error when I compile the module. I also get this error when I use Dib dbs As Database. Database being the unrecognized type. I would find it funny if These are not a feature of Access 97, since I found them in its help files.

Thanks again, Joe