{"id":78,"date":"2007-11-01T17:55:38","date_gmt":"2007-11-01T21:55:38","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-access\/78\/use-access-menus-to-add-page-numbers-dates-and-times-to-your-reports\/"},"modified":"2007-11-01T17:55:38","modified_gmt":"2007-11-01T21:55:38","slug":"use-access-menus-to-add-page-numbers-dates-and-times-to-your-reports","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=78","title":{"rendered":"Use Access menus to add page numbers, dates, and times to your reports"},"content":{"rendered":"\n<!-- ALL ADSENSE ADS DISABLED -->\n<p><!--StartFragment--> <\/p>\n<ul>\n<li><strong><font>Date: October 30th, 2007<\/font><\/strong>: October 30th, 2007<\/li>\n<li><strong><font>Author: Mary Ann Richardson<\/font><\/strong>: Mary Ann Richardson<\/li>\n<li><strong><font>Category: <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=5\">Microsoft <a href=\"http:\/\/www.coastalrock.com\/\">cialis dosage options<\/a>  Office<\/a>, <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=7\">Access<\/a>, <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=17\">Tips<\/a><\/font><\/strong>: <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=5\">Microsoft Office<\/a>, <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=7\">Access<\/a>, <a href=\"http:\/\/blogs.techrepublic.com.com\/msoffice\/?cat=17\">Tips<\/a><\/li>\n<\/ul>\n<p align=\"justify\"><font>While the Report Wizard automatically adds page numbers to your Access report, it does not add a date and time stamp. And, if you create a report in Design view, you have to add the controls for the page numbers as well. Access provides menus so that you don&rsquo;t have to know the code for setting these controls.<\/font><\/p>\n<p align=\"justify\"><font>For example, to add page numbers to the bottom of your report, follow these steps:<\/font><\/p>\n<ol>\n<li>\n<div align=\"justify\"><font>Open your report in Design view.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Go to Insert | Page Numbers.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Click Page N Of M under Format.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Click Bottom Of Page [Footer] under Position.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Click the drop-down arrow under Alignment and select Center. Click OK.<\/font><\/div>\n<\/li>\n<\/ol>\n<p align=\"justify\"><font>If the first page of your report is a title page and you do not want the number to appear on that page, clear the Show Number On First Page check box before clicking OK in step 5.<\/font><\/p>\n<p align=\"justify\"><font>The Page Numbers dialog box gives you a number of options for positioning the number in the header and footer. For example, if you are printing the report on both sides of the paper, you can select Inside or Outside in step 4.<\/font><\/p>\n<p align=\"justify\"><font>To use the menus to insert a date and time stamp in your report&rsquo;s footer, follow these steps:<\/font><\/p>\n<ol>\n<li>\n<div align=\"justify\"><font>Open your report in Design view.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Go to Insert | Date And Time.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Select the Date format you want to display under Include Date.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Select the Time format you want to display under Include Time. Click OK.<\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font>Drag the Time And Date fields to where you want to position them in the page footer section.<\/font><\/div>\n<\/li>\n<\/ol>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d78').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d78\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d78').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d78').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"excerpt":{"rendered":"<p>Date: October 30th, 2007: October 30th, 2007 Author: Mary Ann Richardson: Mary Ann Richardson Category: Microsoft cialis dosage options Office, Access, Tips: Microsoft Office, Access, Tips While the Report Wizard automatically adds page numbers to your Access report, it does not add a date and time stamp. And, if you create a report in Design [&hellip;]<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d78').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d78\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d78').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d78').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[19],"tags":[],"_links":{"self":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/78"}],"collection":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":0,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"wp:attachment":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}