Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fields in footers (2000)

    Does anyone know the syntax to insert the full path and name of the database into a report footer

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Fields in footers (2000)

    Darsha,

    Set an unbound text box's equal to: =currentproject.name

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fields in footers (2000)

    Or you can use CurrentDb.Name, which returns the full name and path as well, but only works on ADPs if you establish a permanent reference to the DAO 3.6 object library. It will work on MDBs regardless.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database path in controls (2000)

    Darsha,

    The following can be used as a data source for a text box to show the file path and database name for a report:

    =CurrentProject.FullName

    For earlier versions of Access, or for Access 2000 with a reference set to the DAO 3.6 library, you can use CurrentDb.Name to accomplish the same thing.

    Preston

    Edited by Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •