hi Jim,
you can run the code here to get SQL for queries (Run_Word_CreateDocumention_SQL), and RecordSources for reports(Run_Word_CreateDocumention_Reports). There will be a Microsoft Word document created for each procedure. You then have 2 documents you can search for the field(s) you are looking for.
Document Query SQL, Form and Report RecordSources
have an awesome day,
crystal
No easy solution.� I use the database documenter.
Duane
On April 10, 2018, at 6:24 PM, "luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Hello all,
My boss just asked me to find all reports with a certain field. I was trying to get the source like I do with the SQL queries. like below. But I am unable to change the objects to Reports instead of queries. Is there a quick way of doing this? I tried Crystals Analyzer but it would be easier to run a query to get the sources instead of the other reports.
Thank you
Jim Wagner
SELECT msysObjects.Name, GetSQL([Name]) AS [SQL], Left([SQL],(InStr(1,[SQL]," ")-1)) AS [Query Type], "PeopleSoft Datawarehouse" AS [Database Name]
FROM msysObjects
WHERE (((msysObjects.Name) Not Like '~*') AND ((msysObjects.type)=5));
and the function is like this
Option Compare Database
Public Function GetSQL(strQueryName As String)
��� GetSQL = CurrentDb.QueryDefs(strQueryName).SQL
End Function
Posted by: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar