If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Cascade" field and table name changes
Hi all,
Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in conjunction with Access, I have to use different naming conventions, plus would like to use my own names for tables and fields. I know that in queries, forms, etc., that are already set up, Access will be looking for the original names. Is there any way that I can, not too painfully, "cascade" my field and table name changes? Thank you. -- Thanks! Dee |
#2
|
|||
|
|||
"Cascade" field and table name changes
Rich Fisher's excellent Find and Replace is just the ticket.
http://www.rickworld.com/ If you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's a good way to find orphans. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dee" wrote: Hi all, Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in conjunction with Access, I have to use different naming conventions, plus would like to use my own names for tables and fields. I know that in queries, forms, etc., that are already set up, Access will be looking for the original names. Is there any way that I can, not too painfully, "cascade" my field and table name changes? Thank you. -- Thanks! Dee |
#3
|
|||
|
|||
"Cascade" field and table name changes
Thanks for the advice. I'll check it out and see how it works!
-- Thanks! Dee "Jerry Whittle" wrote: Rich Fisher's excellent Find and Replace is just the ticket. http://www.rickworld.com/ If you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's a good way to find orphans. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dee" wrote: Hi all, Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in conjunction with Access, I have to use different naming conventions, plus would like to use my own names for tables and fields. I know that in queries, forms, etc., that are already set up, Access will be looking for the original names. Is there any way that I can, not too painfully, "cascade" my field and table name changes? Thank you. -- Thanks! Dee |
#4
|
|||
|
|||
"Cascade" field and table name changes
What can I say - THANK YOU!!! What a great add-in. You just saved me days
of work! You're a saint! :-) -- Thanks! Dee "Jerry Whittle" wrote: Rich Fisher's excellent Find and Replace is just the ticket. http://www.rickworld.com/ If you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's a good way to find orphans. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dee" wrote: Hi all, Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in conjunction with Access, I have to use different naming conventions, plus would like to use my own names for tables and fields. I know that in queries, forms, etc., that are already set up, Access will be looking for the original names. Is there any way that I can, not too painfully, "cascade" my field and table name changes? Thank you. -- Thanks! Dee |
#5
|
|||
|
|||
"Cascade" field and table name changes
The praise belongs to Rick Fisher. Please consider registering the program.
-- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dee" wrote: What can I say - THANK YOU!!! What a great add-in. You just saved me days of work! You're a saint! :-) -- Thanks! Dee "Jerry Whittle" wrote: Rich Fisher's excellent Find and Replace is just the ticket. http://www.rickworld.com/ If you register it (one of the best $37 I've ever spent), the cross-reference report can find what queries use which reports and forms. It's a good way to find orphans. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "dee" wrote: Hi all, Am working with AYS database, trying to take the ideas and re-work them to fit my own needs. Because of another software I will be using in conjunction with Access, I have to use different naming conventions, plus would like to use my own names for tables and fields. I know that in queries, forms, etc., that are already set up, Access will be looking for the original names. Is there any way that I can, not too painfully, "cascade" my field and table name changes? Thank you. -- Thanks! Dee |
Thread Tools | |
Display Modes | |
|
|