Renaming control

[Mike Mueller]

Vista Business / Access 2007

I have a database with a table, about 40 simple select queries, and
associated reports. The table was created by importing a txt file- deleted
some fields and renamed another

In the past, I would just re-import that file (updated continuously) and
rename that field, or I could use NotePad and do a find/replace. It is a
critical field as it appears in all of my queries and on all of the reports.

To make my life easier (and to remove bloat), I am switching over to a
linked table, which now limits my options:
#1 Cannot rename the field, as it is a linked table.
#2 I could change all of the queries to 'myname:[control name]' as the field
source, which will fix the reports
#3 I could change the field name in the query and on the form to match the
actual field name from the text file

Option #3 seems to be the best choice, as it would be the smartest
programming, and this is what I want to do. My question to all of you with
superior knowledge is how to do automate the renaming process, as opposed to
opening each report and query and manually editing the control's source

 

[Douglas J. Steele]

Don't use the (usually) flaky Autocorrect feature to do this. Instead, look
at 3rd party products such as

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/

 

[Mike Mueller]

Thank you

Don't use the (usually) flaky Autocorrect feature to do this. Instead,
look at 3rd party products such as

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Vista Business / Access 2007

I have a database with a table, about 40 simple select queries, and
associated reports. The table was created by importing a txt file-
deleted some fields and renamed another

In the past, I would just re-import that file (updated continuously) and
rename that field, or I could use NotePad and do a find/replace. It is a
critical field as it appears in all of my queries and on all of the
reports.

To make my life easier (and to remove bloat), I am switching over to a
linked table, which now limits my options:
#1 Cannot rename the field, as it is a linked table.
#2 I could change all of the queries to 'myname:[control name]' as the
field source, which will fix the reports
#3 I could change the field name in the query and on the form to match
the actual field name from the text file

Option #3 seems to be the best choice, as it would be the smartest
programming, and this is what I want to do. My question to all of you
with superior knowledge is how to do automate the renaming process, as
opposed to opening each report and query and manually editing the
control's source