Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2008
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database name in a report footer

    I want to put the name (and if possible path) of my database in the footer of my report. I currently put the title of the report in the footer using =[Name] but I can't find the equivalent for the database and I can't work out what words to use in a search in order to find out for myself.

    Any help gratefully received.

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Minnesota
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Try using =GetDataPath("tablename")
    “My father says almost the whole world’s asleep. Everybody you know, everybody you see, everybody you talk to. He says only a few people are awake. And they live in a state of constant total amazement.”

    “ From the Movie ‘Joe Vs The Volcano’

  3. #3
    Lounger
    Join Date
    May 2008
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts
    No, that doesn't work. I am typing this into the ControlSource section of Properties. It just doesn't recognise GetDataPath. Did you intend me to put the actual name of the report in between the quotation marks? I tried both ways but to no avail.

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    CurrentProject.FullName returns the name and path of the file you are using.

    If you use it as the control source for a control on a report, you need to put = at the start.

    If the database is split, it returns the Front End, but not the Back End.
    Last edited by johnhutchison; 2011-02-10 at 16:41.
    Regards
    John



  5. #5
    Lounger
    Join Date
    May 2008
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hope I haven't posted this twice, but thank you very much - it works brilliantly and has given me ideas about how to sort out some other niggles I had.

Posting Permissions

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