billsch said:
If reptN is Report Name I can insert Report Name in a
footer with =Reports!reptN.Name.
That kind of defeats the purpose of it, try using:
=Report.Name
How do do I do the same for database File Name and
Database Properties?
Depends on your version of Access. In A97, all you can get
is the full path to the mdb file using
=CurrentDb.Name
but that can be parsed to get whatever part you may want.
AXP has an additional object with properties to get just the
path
=CurrentProject.Path
or just the mdb file name:
=CurrentProject.Name
For the common database properties:
=CurrentDb.Properties("propertyname")
Other properties are in various Documents:
=CurrentDb.Containers("Databases").Documents("UserDefined").Properties("propertyname")
And then how do I make it volatile so I can copy and
rename?
Not sure what you mean here. The name and path properties
return the name, whatever it is. The db properties are what
they are and trying to rename them doesn't make sense.
