[AccessD] How to handle orphaned group header / footer

[Stuart McLachlan]

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
>