RecordSource Query Help

[pshaw]

Hello,
I'm new to Access, and am learning it on the job. I'm working wit
Access 2002.

I recently took the forms from one database and paired them with th
tables from another. It was mostly seamless, but when I open
particular form, I get an error dialog box stating:

"The Record Source '<SQL STATEMENT>' specified on this form or repor
does not exist."

The thing is, I can't find this SQL Statement anywhere. I've trie
viewing the RecordSource field (in Properties) for every Form in m
database, and it's not present in any of them. I also searched throug
the VB code -- again I couldn't find this particular SQL statement.
So.... how do I find it? is there a way I can do a global Find on m
entire database, to find this text string? Or is there some other wa
to track it down?

Unfortunately the error prompt only shows the first 100 or s
characters of the SQL statement (out of 1000+ characters), so I can'
necessarily use it to find the problem that triggered the error in th
first place....

Thanks,
Patric

 

[Jeff Boyce]

What is the record source for the form for which this happens?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pshaw]

The Form name is "Source Requirements", and the RecordSource is mappe
to a Query by the same name. However, I looked at the SQL View of th
Query and its not the cause of the error prompt. In addition,
checked the RecordSources for each of the subforms, and none of the
are the problem, either.

Is there some way I can search for a specific text string in ALL of th
Database Objects

 

[Jeff Boyce]

Yes. (simple answer)

No (not with the tools that come with Access).

You'll need to look into documentation software. There are commercial
products (I've used FMS, Inc's Total Access Analyzer and Black Moshannon's
Speed Ferret). There are free/low cost offerings. See MVP Jeff Conrad's
website for an extensive list:
http://home.bendbroadband.com/conradsystems/accessjunkie/doctable.html

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pshaw]

Thanks for the info. I actually needed to find the query right away, s
I made a copy of the database binary file, renamed it to *.txt, opene
it, and searched for the text string. Sure enough, I found it.

Not the most elegant solution, but it worked in a pinch.

Pa

 

[Jeff Boyce]

Ooooh! Gotta remember that trick!

Thanks

Jeff