{"id":531,"date":"2013-01-26T23:24:28","date_gmt":"2013-01-26T23:24:28","guid":{"rendered":"http:\/\/regina-whipp.com\/blog\/?p=531"},"modified":"2016-01-01T16:13:34","modified_gmt":"2016-01-01T21:13:34","slug":"add-your-report-name-to-page-footer","status":"publish","type":"post","link":"https:\/\/regina-whipp.com\/blog\/?p=531","title":{"rendered":"Add your Report Name to Page Footer…"},"content":{"rendered":"

Put the TEXT box on the Report and in the Control Source put…<\/p>\n

\r\n=[Name]\r\n<\/pre>\n
OR to get the Report Name and the Date\/Time<\/p>\n
\r\n=[Name] & "\u00a0 Printed on\u00a0" & Now()\r\n<\/pre>\n
OR to get the Report Name and the Date<\/p>\n
\r\n=[Name] & "\u00a0\u00a0Printed on\u00a0" & Date()\r\n<\/pre>\n
…now if you change the Name of the Report you don’t have to worry about updating a LABEL, it will do it for you.<\/p>\n
Courtesy of Bob Larson<\/a>, Access MVP (2008, 2009 & 2011)<\/p>\n
…<\/span><\/p>\n
In addition, you can also add the RecordSource of your Report…
\n(This only works if you use a Naming Convention!)<\/p>\n
\r\n='(Based on ' & IIf(Left([RecordSource],3)="tbl","Table","Query") & ':\u00a0 "' & [RecordSource] & '")'\r\n<\/pre>\n
And another way that takes more then just Tables and Queries into account…<\/p>\n
\r\nFunction ObjectType(Source As String) As String\r\n'Courtesy of Hans V Access MVP  from http:\/\/www.eileenslounge.com\/\r\n'Posted in Microsoft Answers on 8.9.2013 http:\/\/answers.microsoft.com\/en-us\/office\/forum\/office_2010-access\/any-code-to-reference-source-of-report-ie-query\/be4a9d5a-cf0f-4f0e-9b8b-01c89b26f70c\r\n     \r\n    Dim varType As Variant<\/strong>\r\n \r\n\u00a0\u00a0\u00a0 varType = DLookup("Type", "MSysObjects", "Name='" & Source & "'")\r\n\u00a0\u00a0\u00a0 \r\n    If IsNull(varType) Then\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ObjectType = "Error!"\r\n\u00a0\u00a0\u00a0 Else\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select Case varType\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Case 1, 4, 6\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ObjectType = "Table"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Case 5\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ObjectType = "Query"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Case Else\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ObjectType = "Other"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Select\r\n\u00a0\u00a0\u00a0 End If\r\nEnd Function\r\n<\/pre>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Put the TEXT box on the Report and in the Control Source put…<\/p>\n
 =[Name] <\/p>\n
OR to get the Report Name and the Date\/Time<\/p>\n
 =[Name] & " Printed on " & Now() <\/p>\n
OR to get the Report Name and the Date<\/p>\n
 =[Name] & " Printed on " & Date() <\/p>\n
…now if you change the Name of […]<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,63],"tags":[64,30],"class_list":["post-531","post","type-post","status-publish","format-standard","hentry","category-access-tips","category-database-design","tag-access-tips","tag-reports","odd"],"_links":{"self":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=531"}],"version-history":[{"count":14,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":1129,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/531\/revisions\/1129"}],"wp:attachment":[{"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regina-whipp.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}