Microsoft KB Archive/245467

= ACC2000: When You Sort Parameter Query Results You Are Prompted for Parameters Again =

Article ID: 245467

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q245467



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 287432.



SYMPTOMS
In Access 2000, each time that you sort a query that has parameters, the query prompts you for the parameters again. This behavior does not occur in Access 97.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this problem, create a form to hold the parameters, and then have the query refer to that form. To see how this works, follow these steps:  Open the sample database Northwind.mdb. In the Database window, click Queries, and then click New. In the New Query dialog box, click Design, and then click OK. In the Show Table dialog box, click the Orders table, and then click OK.  Add the following fields to the query design grid:   Field: OrderID Table: Orders

Field: CustomerID Table: Orders

Field: OrderDate Table: Orders Criteria: Is Not Null And Between [Forms]![frmOrdersByDate]![StartDate] And [Forms]![frmOrdersByDate]![EndDate]  On the Query menu, click Parameters.</li> Type the following parameters, and select the following data types: </li> Save the query as OrdersByDate, and then close it.</li>  Create the following new form: <pre class="fixed_text">  Form: frmOrdersByDate -  Caption: TestForm

Command button -  Name: Button0 Caption: Show Records

TextBox ---  Name: StartDate

TextBox --  Name: EndDate </li>  Set the OnClick property of the command button to the following event procedure: Private Sub OK_Click DoCmd.OpenQuery "OrdersByDate" End Sub </li> Save the form as frmOrdersByDate, and then open the form in Form view.</li>  For the parameters, enter the following: <pre class="fixed_text">  StartDate: 1/1/1997 EndDate:  12/31/1997 </li> Click the Show Records button. The query results are displayed.</li> On the Records menu, point to Sort, and then click Sort Ascending.</li></ol>

Note that the data is sorted, and that you are not prompted for the parameters again.

<div class="status_section">

STATUS
This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

<div class="moreinformation_section">

Steps to Reproduce Behavior
<ol> Open the sample database Northwind.mdb.</li> Run the "Sales by Year" query.</li>  For the parameters, enter the following:

<pre class="fixed_text">  StartDate: 1/1/1997 EndDate:  12/31/1997 The query results are displayed. </li> On the Records menu, point to Sort, and then click Sort Ascending.</li></ol>

Note that you are prompted for the parameters again.

Additional query words: prb

Keywords: kbfix kbdta kbprb KB245467

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.