"Simon Hayes" <sq*@hayes.ch> wrote in message
news:40**********@news.bluewin.ch...
"Not Me" <No****@faker.fake.fa.kee> wrote in message
news:c6*********@ucsnew1.ncl.ac.uk... Hi,
Is it possible to create some SQL in VBA, 'run it' then view as a datasheet the results?
I'm trying to throw together a fairly large search form, and VBA seems
the best way to parse the parameters.
Yes - you could use the ADO COM objects, then return results to your
client and format/present them there. If you need a more precise answer, then it
would help to have some more detail about what you're trying to do and
what tools you're using (eg. Access, Excel etc.).
Thanks for the reply.
In the past, I have been able to pre-write a query in Access, (i.e. have it
saved in the queries list) and use docmd.openquery in VBA to have it
displayed on screen.
I have also been able to create queries 'on the fly' in VBA, and be able to
iterate through them/work on them in the same program.
What I'd like to do is sort of combine the above, so create a query in VBA
and have it displayed in a datasheet view. So the user in an ADE would
select from a few comboboxes, press go and up would pop the resulting query.
Cheers,
Chris