Microsoft KB Archive/168881: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 107: | Line 107: | ||
# On the Records menu, point to Filter, and then click Filter By Form.<br /> | # On the Records menu, point to Filter, and then click Filter By Form.<br /> | ||
<br /> | <br /> | ||
Note that you receive the message | Note that you receive the message "There are too many controls on the form to allow Filter By Form." | ||
# Click OK to clear the message. | # Click OK to clear the message. | ||
# In the CustomerID combo box, select | # In the CustomerID combo box, select "ALFKI." | ||
# On the Filter menu, click Apply Filter/Sort.<br /> | # On the Filter menu, click Apply Filter/Sort.<br /> | ||
<br /> | <br /> |
Latest revision as of 11:03, 21 July 2020
Article ID: 168881
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q168881
SYMPTOMS
When you use the Filter By Form command to filter a form that contains a linked subform, you may receive the following error message:
Upon applying the filter, you receive the error message:
When you click the Details button, you receive the following message:
MSACCESS caused an invalid page fault in module KERNEL32.DLL. -or- MSACCESS caused an invalid page fault in module MSACCESS.EXE.
CAUSE
The subform is based on either a totals query or a crosstab query and is linked to the main form.
RESOLUTION
There are two possible ways to work around this behavior:
- Set the subform's RecordSource property to a temporary table created with a make-table query based on the original totals query or crosstab query.
- Use the form's other filtering capabilities to filter the data, such as Filter By Selection, or Advanced Filter/Sort.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 2000.
MORE INFORMATION
Steps to Reproduce Problem
WARNING: Following these steps will cause an invalid page fault on your computer. Make sure you save and close any open work on your computer before following these steps.
- Open the sample database Northwind.mdb.
- Open the Quarterly Orders form in Form view.
- On the Records menu, point to Filter, and then click Filter By Form.
Note that you receive the message "There are too many controls on the form to allow Filter By Form."
- Click OK to clear the message.
- In the CustomerID combo box, select "ALFKI."
- On the Filter menu, click Apply Filter/Sort.
Note that you receive the error:
This program has performed an illegal operation and will be shut down. If the problem persists, contact the program vendor.
When you click the Details button, you receive the following message:
MSACCESS caused an invalid page fault in module KERNEL32.DLL. -or- MSACCESS caused an invalid page fault in module MSACCESS.EXE.
Keywords: kbbug kbusage KB168881