Hi all, thanks for reading!
I'm creating a form for someone to map incoming tables against a standardized one. The idea is that the incoming table will have any number of columns with any sort of naming conventions the data originator gave it. What I'm trying to get done is a set of text boxes (or labels, or whatever) populated with the varied column names of the original table and the standardized table column names in a drop down list. Then the correct columns can be assigned, and a button on the form can update the standardized table.
What I don't know how to do is (1) get at the Access metadata and (2) iterate through it to populate each textbox.
One perfectly acceptable solution would be to drop that metadata into it's own little access table and populate the boxes values from that.. or if there's something so easy I will kick myself to learn it, like assigning the value
!Column(0..n) .. but easy seems to have taken the last bus out of town..
Thanks for any advice you can give
I'm creating a form for someone to map incoming tables against a standardized one. The idea is that the incoming table will have any number of columns with any sort of naming conventions the data originator gave it. What I'm trying to get done is a set of text boxes (or labels, or whatever) populated with the varied column names of the original table and the standardized table column names in a drop down list. Then the correct columns can be assigned, and a button on the form can update the standardized table.
What I don't know how to do is (1) get at the Access metadata and (2) iterate through it to populate each textbox.
One perfectly acceptable solution would be to drop that metadata into it's own little access table and populate the boxes values from that.. or if there's something so easy I will kick myself to learn it, like assigning the value
Thanks for any advice you can give
