Changing Form Object Properties

[jj]

This Access Db has >250 Forms. Most have an item with a specific descriptive
named object that is no longer necessary and needs to be replaced with a
different descriptive name.(i.e. "pagerNo" to "eMail"). This can be easily
done in the vba code objects attached to each form with a Find/ReplaceAll in
the code.

Is there a way of Find/ReplaceAll within the DBs All Forms object
properties? (i.e. ReplaceAll properties within all form objects with "eMail"
where they are named or designated "pagerNo". Now, I tab to such named
objects within a form and manually rename each. There has to be a faster
way..similiar to changing within 5000 lines of vba code (Find/ReplaceAll) in
an instant?

 

[Allen Browne]

You can write code to do it.

Loop through each AccessObject in CurrentProject.AllForms to get the Name of
each one. You can then OpenForm in design view (hidden if you like), and
loop through each Control to see if its ControlSource (and Name?) is one
that needs changing.

Here's an example that does that kind of looping and identifies them (but
not change them):
Where is a field used?
at:
http://allenbrowne.com/ser-73.html

 

[Dale Fye]

What version of Access are you using?

If you are using a version prior to 2003, or still have either 2000 or 2002
installed on your system, then you could use Speed Ferret. It is a great
tool that will search all of the objects in your database (or only those that
you select), and will present those to you in a user friendly interface.

Unfortunately, it has not been updated in a couple of years, although they
keep talking about a Version #5. It's current price is $199, but it is well
worth the price. Saved me several days of work when a client asked me to
change a couple of field names.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[MARTIN CUAMATZI MUÑOZ]

En (e-mail address removed) del 09/09/08 10:09 p.m., "Allen

You can write code to do it.

Loop through each AccessObject in CurrentProject.AllForms to get the Name of
each one. You can then OpenForm in design view (hidden if you like), and
loop through each Control to see if its ControlSource (and Name?) is one
that needs changing.

Here's an example that does that kind of looping and identifies them (but
not change them):
Where is a field used?
at:
http://allenbrowne.com/ser-73.html

NO PUEDO USAR EL PROGRAMA COMO LE PUEDO HACER