D
Dale Fye
I'm working on a program that will compare the values in
identical tables in two different databases, and highlight
the differences. Since the table being compared will
vary, I've created a procedure that will create a table at
runtime that contains all of the fields from each of the
tables.
To view this, I create a form on the fly (CreateForm) and
add controls to it for each of the fields in this table.
I then set the forms default and views allowed to
datasheet. I would like to give these controls names that
correlate with the data field they come from but have not
been able to do that yet. (ctrl.Name = "txt_" &
strSomeValue ) does not work, even though the form is in
design view.
Also. I'd like to add some code behind a checkbox control
that is on the form, but have not figured out how to do
this. Any help would be greatly appreciated.
Thanks in advance!
identical tables in two different databases, and highlight
the differences. Since the table being compared will
vary, I've created a procedure that will create a table at
runtime that contains all of the fields from each of the
tables.
To view this, I create a form on the fly (CreateForm) and
add controls to it for each of the fields in this table.
I then set the forms default and views allowed to
datasheet. I would like to give these controls names that
correlate with the data field they come from but have not
been able to do that yet. (ctrl.Name = "txt_" &
strSomeValue ) does not work, even though the form is in
design view.
Also. I'd like to add some code behind a checkbox control
that is on the form, but have not figured out how to do
this. Any help would be greatly appreciated.
Thanks in advance!