Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA: Dynamically change the .ListFillRange of a ComboBox
You could do something like this in the AutoOpen function: Dim rowCtr As Integer 'will be used to find the last row Dim column As Integer 'used to easily change the column instead of editing the code column = 1 'Set the column the data is in rowCtr = 1 'Set the row to...- Tarwn
- Post #2
- Forum: Microsoft VBA - Visual Basic for Applications
-
Data Report, how to filter data from Access at runtime
How are you receiving the data from your database? If you are using a recordset to open a table (ADO objects) weith either a connection or command object, you can use SQL to place limitations on the data received (qualifiers and matches on specified fields in the data) so that you will only...- Tarwn
- Post #2
- Forum: Microsoft Visual Basic
