Displaying fullpath filename and query name on reports

[pewilson]

I would like to display the fullpath of the file name where the report is located and on some reports I would like to show the query name on my report footers. Can someone show me how to achieve this?

Thanks in advance.

Paul

 

[JoeMiller]

Show query in an unbound control by setting ControlSource to this:

=[Reports]![MyReportName].[RecordSource]

Show path and file name of Access database containing the report currently being processed:

=[CurrentDB].[Name]

Show path of Access database containing the report currently being processed:

=CurDir()

HTH Joe Miller
joe.miller@flotech.net

 

[pewilson]

Joe,
I want to thank you for your quick response, but when I tried =[Reports]![MyReportName].[RecordSource]
(typed in exactly what you wrote) in the control source all that was displayed was #name?. Should I be typing something else as well?

 

[JoeMiller]

You need to change MyReportName to the name of the report that you are placing the code in. IE: your reports name is rptOrders in the database window, then the code is:

=[Report]![rptOrders].[RecordSource]

Joe Miller
joe.miller@flotech.net

 

[pewilson]

Joe,
Thank you for the clarification. I wasn't thinking to thoroughly about what you had wrote. But thank you for your help.

Paul

 

[MichaelRed]

pewilson,

When I 'stamp' reports for Identification I include the parameters for the recordsource query and usually generate a validation value (checksum type info). this makes it quite easy to 'authenticate' the reoirt after it may have been 'passed around' a few times. Another item of info which is useful - for secured data abses is the User Id, Machine Id and date/time stamp.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over