Display the results of a select query. (VB)

[Rashers]

Hi all,
I'm sure there is a simple solution to this, I just can't find it.

What I want to do is to build an SQL Select query based on a number of inputs gotten from a user. In other words, build a string, execute it as an SQL statment and display the result to the user.

The closest I've come to this is DoCmd.runSQL(), but that doesn't seem to allow Select statements.

Any ideas or comments would be much appreciated.

Regards,
Andrew

 

[Dugantrain]

I suppose it could be simple or very complex depending on what level of flexibility you're wanting to allow for the construction of your SQL. I actually just built a Pass-Through query builder which allows users to access an external data source without having to actually know SQL. It's very complex as I had to allow for any number of field headings, Criteria, etc. and I had to build a Results subform on the fly as there is no way to tell ahead of time how many fields will be in the result set. Like I said, it's really complex and may just confuse you, but if you think it'll help, I can send you a scaled-down version (i.e. it won't actually access the server, but it will show you how to build dynamic SQL).

 

[Rashers]

Actually, I've discovered a workaround. It's kinda complex but it involves setting up a number of reports and then opening them in print preview view. Seems to be working, though I still have to iron out a few issues. Thanks for your help.