Advertisement

07.25.2008 at 04:40AM PDT, ID: 23595103
[x]
Attachment Details

How to display column headings at the top of new pages in MS Access 2007 Reports?

Asked by colinasad in Access Reports

Tags: Microsoft, Access 2007, 2007

I have produced an MS Access 2007 "report" based on an SQL-Server Express "view" of supplier orders and related tables.
My view pretty much pulls out every order, and by using a "where" argument with the "DoCmd.OpenReport" function, I can print the report for a single order. I would like to re-display my column headings (not my full order headings) when my "Detail" section spills over onto a new page, but am struggling to do this. I have tried adding additional "Groupings" to my report using a specially introduced field whose value remains constant down all the detial items (and is not "visible" in the report) and placing my column headings into that group's "header section" and asking to "keep header and first record together on one page", but to no avail.
Is there something pretty obvious that I'm missing, or some neat "trick" that can be described to me?
Thanks in anticipation.Start Free Trial
[+][-]07.25.2008 at 06:45AM PDT, ID: 22088490

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Reports
Tags: Microsoft, Access 2007, 2007
Sign Up Now!
Solution Provided By: jimhorn
Participating Experts: 2
Solution Grade: B
 
 
[+][-]07.25.2008 at 08:19AM PDT, ID: 22089329

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 11:22AM PDT, ID: 22091045

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.26.2008 at 12:38PM PDT, ID: 22095989

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.26.2008 at 02:09PM PDT, ID: 22096223

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.27.2008 at 07:45AM PDT, ID: 22098613

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.29.2008 at 03:41AM PDT, ID: 22110156

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628