[AccessD] How to handle orphaned group header / footer

Rocky Smolin rockysmolin2 at gmail.com
Mon Nov 29 00:02:20 CST 2021

Borge: Would it be quicker to import the objects into a new form, and copy
and paste the BVA from the old form?


On Sun, Nov 28, 2021 at 8:46 PM Borge Hansen <pcs.accessd at gmail.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list