ACC2000: Cannot View Records When Both Group Header and Group Footer Properties Are Set to No (225898)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q225898
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you open a grouped data access page in Page view or in Microsoft Internet Explorer 5, and both the GroupHeader and GroupFooter properties are set to No, the page is displayed with only a record navigation control. You do not see any of the related child records, even though these fields appear in Design view.

RESOLUTION

The GroupHeader or the GroupFooter property (or both) should be set to Yes at all times.

MORE INFORMATION

The page is grouped, but you have hidden the parent's group header and footer. Because these sections are not visible, you can only view or access the records in the child group in Design view.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb or the sample Microsoft Access project NorthwindCS.adp.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click Page Wizard, and then click OK.
  4. In the Table/Queries list, click Table: Categories.
  5. Click the >> button to move all the fields from the Available Fields box to the Selected Fields box.
  6. In the Table/Queries list, click Table: Products.
  7. Click the >> button to move all the fields from the Available Fields box to the Selected Fields box, and then click Next.
  8. When prompted if you want to add a group, click Categories.CategoryID, click the > button, and then click Finish.
  9. On the View menu, click Sorting and Grouping.
  10. In the Sorting and Grouping dialog box, set the ExpandedByDefault property to Yes for Products-Categories_CategoryID.
  11. On the File menu, click Save, and in the Save As Data Access Page dialog box, type TestPage.htm in the File name box, and then click Save.
  12. On the View menu, click Page View.

    Note that you can move through the child records for each particular group of records.
  13. On the View menu, click Design View.
  14. In the Sorting and Grouping dialog box, set the Group Header and Group Footer properties to No for Products-Categories_CategoryID.
  15. Click Yes when the following message appears:

    You are about to delete this section.

    If you click Yes, the controls you placed in this section will be deleted and you won't be able to undo this operation. Are you sure you want to delete these controls?

  16. On the View menu, click Page View.

    Note that the page contains only a record navigation control.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbpending KB225898
©2004 Microsoft Corporation. All rights reserved.