Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database name and path in a report footer 2

Status
Not open for further replies.

Razor1

IS-IT--Management
Nov 21, 2002
81
US
How do I display a path and database in the footer of a report?

Thanks in advance for the help.
 
Put the following in a text field: CurrentProject.Path
that will give you the path.

-Pete
 
I'm sorry forgot the equals sign. Also if you know the name of your database you can do something like this in the text field:
=CurrentProject.Path & "databasename.mdb"


-Pete
 
Thanks. You pointed me in the right direction.
In place of =CurrentProject.Path & "databasename.mdb" This worked =CurrentProject.Path & CurrentProject.Name returns both path and mdb name.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top