does this exist?

[JonatABS]

I have a VERY VERY messy database. After looking over some code I think I need to revise the names of the fields so I can follow them better through out the code.

INstead of starting from scratch. Is there a tool or program out that will list ALL the variables and such of your database and let you change them.

once you change the variable, it would be nice to be able to have it change all them references as well in the code?

 

[mission2java_78]

I have a VERY VERY messy database. After looking over some code I think I need to revise the names of the fields so I can follow them better through out the code.

INstead of starting from scratch. Is there a tool or program out that will list ALL the variables and such of your database and let you change them.

once you change the variable, it would be nice to be able to have it change all them references as well in the code?

This is very error prone.

However there is a tool that does rename ALL of your variables to the leszynski naming convention. i.e: lbl, txt, cbo, lst, etc.

Do a search on leszynski naming convertor in access
or something to that effect.

 

[mission2java_78]

Actually it renames your controls not your variables.

Jon

 

[MattS]

Check out rogersaccesslibrary

I think theres a Find and Replace add-in tool there. Never used it, but heard good things about it.

 

[Kevin_S]

Check out the website utteraccess.com - If you search in the free code archieve there is a link to a program that was built as an add-on to MS Access and it will do a sort of "find and replace" on object names for you... its pretty slick and it also comes with a bunch of other goodies for developers like additional button images, advanced SQL editor, and the like - best of all is that it is totally FREE....

HTH,
Kev