MOD2000: Filter By Form Is Not Available in Run-Time Applications (262094)


The information in this article applies to:

  • Microsoft Office 2000 Developer
  • Microsoft Access 2000
This article was previously published under Q262094
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

For a Microsoft Office XP Developer Edition version of this article, see 306361.

SYMPTOMS

If you programmatically open a form in Filter-by-Form view in a Microsoft Access 2000 run-time application, you may receive the following error message:
Execution of this application has stopped due to a run-time error. The application can't continue and will be shut down.

CAUSE

The Filter-by-Form commands are not available in a Microsoft Access 2000 run-time application.

RESOLUTION

For additional information about simulating Filter-by-Form in a run-time application, click the article number below to view the article in the Microsoft Knowledge Base:

262099 ACC2000: Filter-by-Form Example for Run-Time Applications Available in the Download Center

MORE INFORMATION

Steps to Reproduce the Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. In the sample database Northwind.mdb, open the Customers form in Design view.
  2. Add a command button to the form.
  3. Change the Name property of the command button to btnFilter.
  4. Place the following code in the OnClick event of the command button:
    Private Sub btnFilter_Click()
  DoCmd.RunCommand acCmdFilterByForm
End Sub
  5. Save the form, and then close it.
  6. On the Tools menu, click Startup.
  7. Under Display Form, click Customers in the list, and then click OK.
  8. Click Start, click Run, and then type the following command in the Open box.

    NOTE: In the following sample, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when typing this command.

    NOTE: If Microsoft Office is not installed in the default location of C:\Program Files\Microsoft Office\Office\, change the following path to where Msaccess.exe is located on your hard disk.

    "C:\Program Files\Microsoft Office\Office\Msaccess.exe" _
    "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" _
    /Runtime

  9. When the Customers form opens, click the command button that you created in step 2.

    Note that the Filter-by-Form view does not appear and that you receive the error message mentioned in the "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kberrmsg kbnofix kbPDWizard kbprb KB262094
©2004 Microsoft Corporation. All rights reserved.