Show header and footer on Continuous Subform

[hk1]

I understand that you can't show headers and footers on datasheet view subforms but I have a subform that is a continuous form and no matter what I try I still can't get it to show the header or footer.

I'm using Access 2007 by the way and I think I have the latest service packs installed.

What could I be doing wrong?

 

[David Eagar]

Can you post your database?

 

[hk1]

I don't mean to be a jerk but I won't be able to post it here without a lot of modification. It has too much proprietary code and a variety of other things that make it quite complicated.

 

[David Eagar]

No problem - Can you describe the problem in more detail? What is preventing the header & footer on the subform?

 

[David Eagar]

I am using 2003 at the moment (don't have 2007 at work here, so I might need to test again tonight if we can't get your problem sorted before then).

Works in 2007 - I have many forms with this type of setup

 

[hk1]

No problem - Can you describe the problem in more detail? What is preventing the header & footer on the subform?

By granny, I wish I knew. I've changed their colors and placed controls on them and they still don't show up. No error message. Have ran compact and repair on the db frequently and there are no problems. It's a fairly small db with only 1 forms/subforms, 6 linked tables, several modules, and 1 report.

 

[David Eagar]

Does this example work for you?

 

[hk1]

That sample works and it brings to mind an issue that could be causing this problem. I'm still using an old file format for the backend and the frontent. Not sure whether it's 2000 or 2003 and not sure how to check. My application needs to be compatible with older versions of Access. I wonder if this could be causing the problem.

 

[hk1]

Here's the requested screenshots. The black "header" on top is on the main form, not the subform. I've had to resort to it for the time being since my headers and footers aren't working. Let me know if any other screenshots might be helpful.

I noticed that it looks like my screenshots got damaged, no... compressed, no... both, when I uploaded them. Sigh...

 

[hk1]

I guess I should also mention that the subform does not relate to the main form. The main form is not bound to anything. Can't see how that would make any difference.

 

[hk1]

Your right. Sorry about that. Here's the properties for the subform.

 

[samuelm99]

Just had the same problem... finally realised my header was in page header instead of form header, switched it and solved the problem

 

[Simon_MT]

You could try using a Continuous Form based starting from the SubForm information and including the Parent information. Put the ex-Parent Header info at the top of the Header and ex-Subform Header underneath.

Simon

 

[shizekopf]

Use Form Headers for forms, Page Headers for reports.

 

[gemma-the-husky]

this is 3 years old!