[RESOLVED]Behind the Scenes Query

Hi,

I was wondering if there is a way in VBA of running an Access query but NOT showing the datasheet result. I need to run it on a button press but not display because im going to manipulate the results of the query later.

Thanks in advance.

Dave

Sure You can. In fact it's harde to show the data (unbound) then to retriev it

make sure you have a reference to DAO (since it's acces) or if you want to upscale to other databases in the futere to ADO

search this site for opening a connectiont to an Access database (*there are plenty examples.

modify the SQL Query to your need.

and the recordset wil contain the data you want to have but not to show :)