ps
you can also make a query from the Analyzer results.
This query shows report name, record source, control names, control sources, and control types:
SELECT R.DbID, R.r_Name, R.R_Caption, R.r_RecordSource, C.c_Name, C.c_ControlSource, cTy.sControlType
FROM (a_Reports1 AS R INNER JOIN a_Ctrlz1 AS C ON R.RptID = C.RptID) LEFT JOIN a_ControlType AS cTy ON C.c_ControlType = cTy.CtrlTypB
WHERE (((C.c_ControlSource) Is Not Null))
ORDER BY R.r_Name, C.c_Name;
if there is more than one database analysis in the Analyzer, you can add criteria for DbID
This query will give also you RowSources::
SELECT R.DbID, R.r_Name, R.R_Caption, R.r_RecordSource, C.c_Name, C.c_ControlSource, a_Sql.q_RowSource
FROM (a_Reports1 AS R INNER JOIN a_Ctrlz1 AS C ON R.RptID = C.RptID) INNER JOIN a_Sql ON C.CtLID = a_Sql.CtLID
WHERE (((C.c_ControlSource) Is Not Null))
ORDER BY R.r_Name, C.c_Name;
have an awesome day,
crystal
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
On 4/10/18 6:58 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] wrote:
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: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar