Print The DB Path in Reports

[Bill Phillips]

I have just installed Access 2003 and am having a report
problem. In my old version (MS Access 2000) I placed an
text box with the following code in my footer to display
the file path: =[CurrentDb].[Name] When I run such a
report in 2003 it now opens a dialog box asking for the
value of CurrentDb. All my references are consistent
between my old version and new version. Any help would be
appreciated.

Thanks

 

[Bruce M. Thompson]

I have just installed Access 2003 and am having a report

problem. In my old version (MS Access 2000) I placed an
text box with the following code in my footer to display
the file path: =[CurrentDb].[Name] When I run such a
report in 2003 it now opens a dialog box asking for the
value of CurrentDb. All my references are consistent
between my old version and new version. Any help would be
appreciated.

Try:

=CurrentDb().Name

.... and if that doesn't work, try:

=currentproject.Path & "\" & currentproject.Name

I suspect that you might still have a references issue, so you might want to see
the following page at Doug Steele's website for a quick fix (and, if you're
interested, the page includes more than you'll ever likely want to know about
references <g>):

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html