Running a query from vb without opening in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there a visual basic command/language to run a query without having it
open in access? What I am doing is picking items from a list box in a access
form, then "On Exit" calling an event procedure in vb that creates a query.
From this query I would then like to populate a second list box. The problem
is, I can't figure out how not to open the query in access, I would just like
to create it and run it. Right now, my vb procedure has an "OpenQuery"
command to in effect run the query. Is there a "RunQuery" type command that
won't open it as well??
 
forget it, I just figured out you don't even have to open it, it's 'creation'
is enough to populate the query. duh.
 

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

Filling query parameters from different forms without VB 4
Parameter Query Won't Run 0
open and run access query in excel 1
Access a query without opening Access 3
VB Functions not found 4
Multiple queries with same filter problem. 11
Turning off action query confirmation messages 1
Access #Error & Excel Pivot 0

Back
Top