G
Guest
I hope someone has done this - I thought it would be a smooth task but I'm
just stuck.. I have several large forms (Access 2000) which display over 200
bound text box controls along with many others unbound for user entry. By
necessity the bound data sources have the year referenced in their variable
names: VariableName_Month04
I need to copy the form with each of these controls bound to new variables
with the "04" replaced with "05". I'm trying to write a VB function to
reference the controls collection on each new form, and replace the last
character in each data source name with a "5". I can't name each variable to
be set or updated, but I thought I could reference the entire controls
collection where the criterion is that the data source ends in "04". That
way the VB function could be applied to many forms for efficient updating.
How would I do this? Thanks for any help.
just stuck.. I have several large forms (Access 2000) which display over 200
bound text box controls along with many others unbound for user entry. By
necessity the bound data sources have the year referenced in their variable
names: VariableName_Month04
I need to copy the form with each of these controls bound to new variables
with the "04" replaced with "05". I'm trying to write a VB function to
reference the controls collection on each new form, and replace the last
character in each data source name with a "5". I can't name each variable to
be set or updated, but I thought I could reference the entire controls
collection where the criterion is that the data source ends in "04". That
way the VB function could be applied to many forms for efficient updating.
How would I do this? Thanks for any help.