Can you search in queries???

[Dan]

Hi -

I inherited this UUUUGGGLLLYYY database from someone that has over 200 macro
and 150 query objects in it. He didn't do any coding. Because of that, I am
finding it very hard to troubleshoot. Is there a way you can search for a
table, form or query object referenced in a macro, like you could if it was
written in a VBA module? Also, is there a way to identify all the queries
that references a given table? I'd like to eliminate all non-essential
macros and queries to clean things up but don't know a quick way to do that.

Thanks so much for any help!

Dan

 

[John W. Vinson]

Hi -

I inherited this UUUUGGGLLLYYY database from someone that has over 200 macro
and 150 query objects in it. He didn't do any coding. Because of that, I am
finding it very hard to troubleshoot. Is there a way you can search for a
table, form or query object referenced in a macro, like you could if it was
written in a VBA module? Also, is there a way to identify all the queries
that references a given table? I'd like to eliminate all non-essential
macros and queries to clean things up but don't know a quick way to do that.

Thanks so much for any help!

Dan

There are some good third-party tools to do so:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

I particularly like Speed Ferret for this kind of work.

John W. Vinson [MVP]

 

[Larry Linson]

John's response is probably simpler, but by converting your date/time into a
"whole number", say long integer, you might use the built-in Partition
function which appears to me to be well-explained in VBA Help. (It's a shame
that function wasn't made just a little more general.)

Larry Linson
Microsoft Office Access MVP