Search results

I'm having some trouble with list boxes. What I am trying to do is run a series of queries against each item in a list box. The problem being, after the queries are ran, I want to export the specific results to an excel sheet in different rows all linear . The problem I am having is that I can...

I am new to Access VBA. I am having a problem passing values from an aggregate function query, ( Select Count([ID]) from tblWhatever) ) and I can't seem to figure out how to pipe the data to an array. I.E. dim sql as string dim rst as adodb.recordset dim cnn as adodb.connection dim...