[AccessD] How to handle orphaned group header / footer
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
> 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
> 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?
> AccessD mailing list
> AccessD at databaseadvisors.com
> Website: http://www.databaseadvisors.com
More information about the AccessD