Search for control name through all objects in Access 2007

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Search for control name through all objects in Access 2007

Post by Pat »

How do I do this, I have a control on a form and wish to know where it is used in queries or forms. I have searched all VBA to no avail.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Search for control name through all objects in Access 20

Post by HansV »

I use Rick Fisher's add-in Find and Replace for this purpose. It is not free, but more than worth its modest price. You can try it out for free for 30 days, after that the add-in will cease to operate unless you register it.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Search for control name through all objects in Access 20

Post by Pat »

Thanks Hans, I thought there may have been an Access option.

I had bought that many years ago and as I upgraded to Access 2007 it stopped working.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Search for control name through all objects in Access 20

Post by HansV »

The latest release (9.00k) supports Access 2007 and later. If you already have a license for version 9.0, you should be able to download, install and register this release.
If you have the version for Access 97 (i.e. version 8.0), you can upgrade to the current version for a reduced price.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Search for control name through all objects in Access 20

Post by Pat »

Thanks I will look into that.

Mark L
3StarLounger
Posts: 331
Joined: 11 Feb 2010, 03:55
Location: Land O Lakes, FL

Re: Search for control name through all objects in Access 20

Post by Mark L »

I use "Find and Replace" even with Access2010.
Mark Liquorman
Land O Lakes, FL
see my website http://www.liquorman.net for Access Tips and Tricks, and for my Liquorman Utilities.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Search for control name through all objects in Access 20

Post by HansV »

Mark L wrote:I use "Find and Replace" even with Access2010.
Yes, I do too. It works fine there.
Best wishes,
Hans