[AccessD] How to handle orphaned group header / footer
Borge Hansen
pcs.accessd at gmail.com
Sun Nov 28 22:46:22 CST 2021
Hello everyone,
This relates to a report that was created way back in Access2003.
I have since changed the underlying query table aliases for the report query.
The report used to handle this group header / footer (referred to in
the property sheet as GroupHeader2 and GroupFooter4):
tblContactWasReferredBy.FullNameSorting Header / Footer
After having changed the report query table aliases we are now dealing with:
crb.FullNameSorting Header / Footer
Because I changed the table alias to crb, the group old header /
footer does not appear in the "Grouping Dialog Box" ... and I cannot
delete the header/footer from within the "Grouping Dialog Box".
I can't find a way to remove this "orphaned" group header and footer,
other than revert the report query to the original table name instead
of the table alias.
Is there a way - through VBA - to remove such 'orphaned' group headers
and footers as these "GroupHeader2" and "GroupFooter4" or whatever the
case may be?
/borge
More information about the AccessD
mailing list