How to print report's path and file name in footer of MS Access report
On MS Access 2007 report, can I add &[path] and &[File] controls to print in footer (like we do on Excel)? This doesn't seem to work. Do have to type each report name into a label, or is there an expression to use in a control? Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
<ot Marcus ... your 'OTF' solution appears to be quite workable ... running tests on A2003/A2010 ... mdb vs accdb, etc ... will report back soon via email /ot>
mx
mx
ASKER
Thanks
I was a little confused by 'report's path' ...
mx
mx
ASKER
All I needed was "=report.Name" to print the name of the Access report in the footer.
Sorry I confused by including the term 'path' in my question; was trying to use spreadsheet examples to explain what I needed.
Thanks to all who responded.
Sorry I confused by including the term 'path' in my question; was trying to use spreadsheet examples to explain what I needed.
Thanks to all who responded.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
=CurrentProject.FullName
in a Text Box in the Report Footer, it will return something like this:
C:\Documents and Settings\Administrator\Des
mx