Different Page Headers
By Richard Rost
3 years ago
Different Page Header for the First Page of a Report
In this Microsoft Access Tutorial, I'm going to teach you how to set a different first page header for your reports. Technically you could use this technique to set the header for whatever pages you want, but traditionally you want a different header on the first page.
Robert from Poughkeepsie, New York (a Platinum Member) asks: I like to put my company logo real big on the first page of a report, and then a smaller one on each following page. I know how to do this in Microsoft Word. Is it possible in Access?
Members
Members will learn how to create different even and odd page headers for the rest of the report with a little VBA magic.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!
Prerequisites
Keywords
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Different first page header, Different Header for First Page, Page header on second page, different even odd header footer
Intro In this video, we will talk about how to set up different page headers in Microsoft Access reports, similar to the way you can have a unique first-page header in Microsoft Word. I will show you how to display a large logo or custom header on the first page of a report and a different, smaller version on subsequent pages, all without using VBA code. If you want your Access invoices or reports to look more professional with varying headers, this video will walk you through the basics step by step.Transcript Welcome to another TechHelp video brought to you by AccessLearningZone.com. I am your instructor, Richard Rost. Today, we are going to talk about different page headers. You have seen this in Microsoft Word, where you can have a different header on page one as opposed to the rest of the document. Today, we are going to see how to do that in Microsoft Access.
Later on, in the extended cut for the members, we are going to see how to do different even and odd page headers.
Today's question comes from Robert in Poughkeepsie, New York, one of my platinum members. Robert says, I like to put my company logo real big on the first page of a report. Of course, who does not? And a smaller one on each following page. I know this is possible in Microsoft Word. Can you do it in Access?
Of course you can. The good news is, back in the day, it was a Tuesday. When I was learning Access, we had to do this with VBA. But recently, I think in 2007 or 2010, they added it as an option. Now it is a beginner thing you can do with just beginner stuff. Let's take a look and see how we can do it.
Prerequisite: I am going to be using my invoicing database. If you want to learn how I built this database, go watch this video first. We are going to put a different logo on the first page. If you have a two or three page invoice, we will put a different logo on pages two and three and so on. This is free. It is on my website. It is on my YouTube channel. You can find a link down below. You can click, go watch this first, and come on back.
Here I am in the TechHelp free template. This is a free database. You can download it off my website if you want to. I have got customers, and every customer can have orders. For each order, you can print out an invoice. There it is, nice and pretty. We are going to put a logo up here real big on the first page.
First, we have to add enough line items so this thing spills over onto pages two and three. I am going to go over here and just copy these line items and copy, then click, and then paste, and then paste again. Let's do that one more time. Copy them all, Control+C, click on the last one, Control+V, and one more time, Control+V. Boom. All right. So we should get a bunch of line items on here. Let's see what we got.
There is page one and page two. I am going to do one more for page three. Come on down here. Give me a bunch of pages. Let's see what we got. Page two. Page three. Beautiful.
Now, if you look at the way I designed this invoice, what I did was this is all in the report header. This shows up once at the top of the entire report. You do not want this on every page. The order ID, the order date, the customer's information, that just goes once at the very top.
But this stuff here is in the page header: the product, quantity, basically the column headers. So when you look at this, there is the page header right there, and there is the report header. It is weird because on page one, the report header goes first followed by the page header. If you go to page two, you will see the page header is on top.
The trick here is that I am going to not display the page header with the report header, and we are going to make a copy of this in the report header itself. That is going to be the trick.
First, let's throw a logo up here. Design view. It makes more sense when you can actually see the logo too. I am going to slide this under here, and we are just going to move this stuff down like that. Move you over here. I have got a logo in this database already. It is sitting on the main menu. We will just use this guy. This is an image right here. Copy him, close that, come back over here, and paste you into there. Slide you over there. There it is. Let's make this really big and obnoxious. Let's go that big, and we will have to change the zoom.
Let's see here. Size mode, clip. We are going to change that to zoom. Now let's go stretch. OK. That is nice and big. I am going to rename this. It is ALZ. We are going to call this one ALZ big. Why? Because we are going to put a small one on the page header, and we are going to stick it right down in here.
Let me maximize this. Reports. I usually find reports are easiest to work with when you maximize. I am going to slide the page header section down, then grab all of this stuff and slide this down as well. Make some room. Maybe a little more. Little bit more. Just a little bit.
Let's take this guy. Copy. Paste. Make this one small now. It actually kept the original one. Take this one. This will be our logo for the other pages. I will put it right there.
Let's get rid of this extra space. Looks good. Save it. I am going to close it and reopen it. Give it a nice, fresh open.
Now this is my report header, and I can see the real big logo there. This is the page header, and I can see the little guy there.
Let's take a look at the successive pages now. Page two. Page three. Page two and three look good. That is exactly what I want. I want the page header with a little logo there.
Now, how do I get rid of it here? I do not want to see the page header on page one. This is where we used to have to use some VBA, and I will talk about that in the extended cut. But now, in Access, there is an option.
If you go into the report properties, I am down on the Format tab. Scroll down, and it says right here page header, page footer. Pick page header, and instead of all pages, you are going to say not with report header. There is also not with report footer, and there is not with both of them. I am going to just pick this one. I do not want the page header to appear with the report header on page one.
Save it now. Close it. Open it back up again. Now we are getting somewhere. Now I do not see that page header on page one, but it still shows up on pages two and three.
Now the trick is, all we have to do is just duplicate or make a copy of - that is the technical term - duplicate this stuff in the report header. Yeah, I know you are duplicating a few objects, but this is the easiest way to do it. Just make a little more room up here. Copy these guys. Click up here. Paste them up here. Now, do not do anything. Just grab it and slide it down. Line it up right with that one. If I can get it exactly, there you go. Now this will duplicate in the report header as well, and this will show up on every other page.
Save it. Close it. Open it. There we go. There it is in the report header, not showing the other one, not showing the logo. If I go to page two, there it is, same. Page three. Now you are getting the page header up here but the report header on this one.
That is it. That is how you do it. Like I said, back in the day when I was a kid, when I was young, you just had to do a little bit of code. Now you do not have to. Now it is a beginner thing.
Now, if you want to get cool with this stuff, I am going to teach you in the extended cut how to do even and odd page headers. This is great if you are going to print a booklet. Maybe not for invoices, but if you are going to print out a booklet, you have left and right. We are going to do even and odd pages with different headers. Is that not neat? Again, this is easy to do in Word. But in Access, you need a little tiny bit of code, like five lines tops. That will be covered in the extended cut for the members.
Silver members and up get access to all of my extended cut videos - all of them. There are hundreds of them now. Well worth your membership. Gold members can download these databases and get access to my code vault. Lots of cool stuff in there.
That is going to be your TechHelp video for today. I hope you learned something.
Live long and prosper, my friends. I will see you next time.Quiz Q1. What is the primary goal of the video tutorial?
A. To show how to create an Access query
B. To demonstrate how to use VBA code in Access reports
C. To show how to create different page headers in Microsoft Access reports
D. To explain how to import data into Access from Excel
Q2. What common feature in Microsoft Word is being recreated in Microsoft Access in the video?
A. Mail merge functionality
B. Different headers on pages (such as a unique header for the first page)
C. Table of contents
D. Page numbering
Q3. According to the tutorial, where should the large company logo be placed for the report?
A. In the page footer
B. In the report header
C. In each detail section
D. In the group header
Q4. Where is the smaller version of the company logo placed for the following pages?
A. In the page header
B. In the detail section
C. In the report footer
D. Only on page one
Q5. What section of the report contains column headers such as product and quantity?
A. Report footer
B. Report header
C. Page header
D. Detail section
Q6. What Access feature allows you to prevent the page header from displaying on the first page with the report header?
A. Use a VBA macro to hide the page header
B. Set the report setting: Page header - Not with report header
C. Delete the page header for page one manually
D. Adjust the detail section properties
Q7. How does the tutorial suggest you duplicate elements from the page header to the report header?
A. Write VBA code to move them at runtime
B. Copy and paste the desired controls into the report header
C. Use a macro to control their visibility
D. Only use conditional formatting
Q8. In the current version of Access discussed in the video, what extra skill is NOT necessary for basic different page headers?
A. Copying and pasting controls
B. Beginner Access report formatting
C. Advanced VBA programming
D. Modifying report properties
Q9. What future (extended cut) topic is mentioned as requiring a bit of code?
A. Creating subreports
B. Even and odd page headers for booklets
C. Filtering data in a query
D. Exporting reports to PDF
Q10. If you want the page header to appear on all pages except where the report header is shown, what must you select in the report's Format property?
A. All pages
B. Not with report header
C. Not with report footer
D. Never show page header
Q11. Why is the duplicate of headers in both report header and page header necessary in this approach?
A. So that the headers always appear at the top of every page
B. Because Access does not allow images in page headers
C. Because only report headers can contain logos
D. To control the different appearance between page one and the rest
Q12. What is the instructor's recommended method for viewing and adjusting report sections while designing?
A. Use datasheet view
B. Maximize the report window for easier section movement
C. Work only in print preview
D. Always use code to adjust sections
Q13. What is the main benefit now compared to "back in the day," according to the instructor?
A. Reports are displayed in color by default
B. No need for VBA code to handle different page headers
C. Access reports can store audio
D. There are more font options in Access reports
Answers: 1-C; 2-B; 3-B; 4-A; 5-C; 6-B; 7-B; 8-C; 9-B; 10-B; 11-D; 12-B; 13-B
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary Today's TechHelp tutorial from Access Learning Zone covers how to create different page headers in Microsoft Access reports. Many of you are probably familiar with this feature in Microsoft Word, where you can set a unique header for the first page and a different one for the remaining pages. Today, I'll show you how you can accomplish this in Access, which is especially helpful if you want to highlight your company's logo on the first page and use a smaller version on subsequent pages.
This question actually comes from one of our members, who wanted to use a large company logo on the first page of his invoice report and a smaller one elsewhere. If you've ever worked in Word, you know this is simple, but the good news is that Access makes this task straightforward now as well. Years ago, you had to use VBA code to accomplish this in Access, but starting with versions around 2007 or 2010, Microsoft made this easy to do with standard reporting tools.
For today's lesson, I'm working with my invoicing database. If you want to follow along, I recommend checking out my previous video on building this database, which is available for free on my website and YouTube channel. The example involves printing invoices that may stretch across multiple pages, so we'll work with a report that can display a large logo on the first page and then a smaller version on pages two and three.
To get started, I use my TechHelp free template database, which you can download from my site. This database tracks customers, their orders, and allows you to print out nice-looking invoices. The invoice report initially displays all of the customer and order information in the report header, which only appears at the very top of the first page. Column headers for products and quantities are displayed in the page header, which normally appears at the top of every page.
What's important to note is that on the first page, the report header appears first, followed by the page header. On page two, you only see the page header. Our main challenge is to avoid showing the page header on the first page, so only the large logo appears up top. The column headings and smaller logo should show up just on the remaining pages.
Here's how the process works. First, I add a large logo image to the report header, making sure it stands out just as you'd like on the first page. I simply copy the image from the main menu of the database, paste it into the report header, and enlarge it for emphasis. I usually rename this image something like "ALZ big" because I'll be adding a smaller version later.
Next, I add a smaller logo to the page header. After making some room in the section, I place the reduced logo image in the page header where I want it to appear for pages two and beyond.
By default, Access shows the page header on every page, including the first. However, Access reports provide a setting that lets you choose when the page header should be displayed. In the report properties, on the format tab, there is a property for the page header. By changing it from "all pages" to "not with report header," the page header will not appear on the first page if the report header is shown. This is exactly what we need for our layout.
Once you save and reopen your report, you should see the large logo and report header details only on the first page, while the subsequent pages show just the smaller logo in the page header.
One finishing touch is to copy the table column headers you had in the page header and place them in the report header as well. This way, the first page shows both the big logo and appropriate headings, and the rest of the pages display the smaller logo and repeat the column headers for readability.
With these steps, Access handles the layout automatically. There's no longer a need for any VBA code to achieve different headers on the first and subsequent pages, making it a simple task for any Access user.
For those who want to go even further, in today's Extended Cut, I'll explain how to create different headers for even and odd pages. This can be really useful for producing printed booklets where you want headers to alternate sides. For this, you'll need a small amount of VBA, which I'll cover specifically for members in the extended portion.
Remember, Silver members and above have complete access to all my extended cut videos, while Gold members can also download the sample databases and access my code vault for even more productivity.
You can find the complete video tutorial with all of the step-by-step instructions for everything discussed here on my website at the link below.
Live long and prosper, my friends.Topic List Adding a different header on the first page of an Access report
Setting a large logo on the first page of a report
Displaying a smaller logo on subsequent pages
Understanding the difference between report header and page header
Duplicating line items to test multi-page reports
Copying and resizing images for different header sections
Configuring the 'Page Header' property to hide it with the report header
Manually duplicating column headers in the report header
Aligning header elements for consistent appearance across pages |
