R
RSharp
I am trying to create a combo box that will list the column names (headings)
from a particular table. I've found ways to query the column names with other
products but have not discovered a way to do it with access yet.
I am trying to code a sql statement via VBA that will insert the column name
selected from the combo box.
ex. strSQL = "SELECT Column1, Column2, " & cmbColumn3 & ", Column4 FROM ..."
However, I would like to try to keep from having to type each column name
into the combo box list because new columns get added each year or so (not my
design) and I would have to go back and add new column names to the combo box
each time. So if I can create a query or something that I can use to populate
the combo box with the column names from the table, that would be ideal. Does
anyone know how I can pull this off?
from a particular table. I've found ways to query the column names with other
products but have not discovered a way to do it with access yet.
I am trying to code a sql statement via VBA that will insert the column name
selected from the combo box.
ex. strSQL = "SELECT Column1, Column2, " & cmbColumn3 & ", Column4 FROM ..."
However, I would like to try to keep from having to type each column name
into the combo box list because new columns get added each year or so (not my
design) and I would have to go back and add new column names to the combo box
each time. So if I can create a query or something that I can use to populate
the combo box with the column names from the table, that would be ideal. Does
anyone know how I can pull this off?