Search results

Force of Habit It's a force of habit. I define my sql strings in variables because I use the same variable/sql string over and over. Saves me on typing in the long run. Not only that, I can read my code easier. :)

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...

Listbox /ComboBox Rowsource: I'll tell you what. I don't know what that code is supposed to be, but if you're trying to change the rowsource property for a combo/listbox here is some sample code: Keep in mind this is just a generic sample. Hope This Helps! :eek: Private Sub...

Thank you. Thank you tremendously. This is a HUGE time saver. --Cly

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...