When you change the name of each textbox do the number of textbox and/or their position on the from/report change?
No the position on the form doesn't change. This sounds similiar to what I was looking for. Something to loop through and change the control source to the new year.
SSH1223
Last Activity: Nov 5 '15, 09:58 PM
Joined: Jun 30 '15
Location:
-
Thank you for the input on normalizing the database; however, What I was looking for was a way to use VBA or a macro to update the form. The field I am trying to update is the name field in the property sheet. I was hoping there would be a way to have that field on all the text boxes to update when I update one.Leave a comment:
-
For us it does. The rules of how a certain piece of data is used changes year to year. Sometimes we need to run it under the old rules. But thank you for the suggestion.Leave a comment:
-
The data changes every year so we have a "new" database each year so when needed we can go back to the conditions of a certain year.Leave a comment:
-
Update multiple text box names at once
I have an Access database form that has 160 text boxes that the name needs to be updated every year. The name is looks like "xxxxxx2015 " "xxxxxx2014 " and continues. Each year you have to go in and update the year at the end of each text box name. Is there a way to have it update the name in the text box based on what is entered in another box? -
How to debug access 'enter parameter'
I have one command button that starts a procedure to fill out a couple different forms. One of those things is to print a page of a report that goes with the selected object. HOwever the report only applies to some of the objects, so when the command button is hit for ones that do not apply the 'Enter Parameter' button pops up. How do I get it to simply not print the form when the form does not apply?
No activity results to display
Leave a comment: