[AccessD] How to handle orphaned group header / footer

[Borge Hansen]

Well, what I did was to change the report record source back to using
the original table name instead of the table alias. This enabled me to
remove the group header and footer from the Group/Sort dialog list.
Then changing the sql record source back to using the table alias I
inserted the group header and footer this time reflecting the table
alias (two joins to the same table therefore the need for the table /
alias prefix).
/borge

On Mon, Nov 29, 2021 at 5:07 PM Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
>
> Have you tried changing the report Recordsource to a different query and then changing it
> back again (saving between changes)  That should refresh the  Group/Sort dialog field list.
>
> The old Group fieldname may be changed  to "Expression:", but you should be able to
> update that to the new field name.
>
> On 29 Nov 2021 at 14:46, Borge Hansen 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com