Hi, loungers.
Our user now requires us to change the name of a field in a table. This is currently used in lots of places.
Is there a reliable/safe/quick way to find every occurrence of the old field name in all the queries, forms, reports and VB modules, please?
Thanks
Silverback
Find all table names
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find all table names
Try Rick Fisher's Find and Replace for Microsoft Access. It's an extremely handy add-in; you can try it for free for 30 days, and it's well worth the modest price.
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 331
- Joined: 11 Feb 2010, 03:55
- Location: Land O Lakes, FL
Re: Find all table names
I second that suggestion! I consider "Find and Replace" to be a Must Have part of a developer's arsenal.
Mark Liquorman
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.
-
- 5StarLounger
- Posts: 780
- Joined: 29 Jan 2010, 13:30
Re: Find all table names
Thanks for the information.
Seems a little surprising that Access doesn't contain this facility, though.
Silverback
Seems a little surprising that Access doesn't contain this facility, though.
Silverback
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find all table names
It would have been a nice feature, but Microsoft prefers to concentrate on integrating Access with SharePoint.
Best wishes,
Hans
Hans