Microsoft KB Archive/224930

ACC2000: Stored Procedures Not Listed in New Form/Report Dialog

PSS ID Number: Q224930 Article last modified on 06-02-1999

WINDOWS:2000

WINDOWS

================================================================ ==

The information in this article applies to:

 == Microsoft Access 2000 == 

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

= SYMPTOMS =

When you create a new form or report, stored procedures in your database are not listed as a possible data source.

= RESOLUTION =

Create the form or report without specifying a record source, and then in Design view of the object, type the stored procedure’s name in the RecordSource property of the form or report.

Follow these steps to create a report that uses a stored procedure as its record source:

CAUTION: Following the steps in this example will modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and perform these steps on a copy of the project.


 * 1) Open the sample project, NorthwindCS.adp.
 * 2) In the Database window, click Reports under Objects.
 * 3) In the New Report dialog box, click Design view, leave the Record Source drop-down box empty and click OK.
 * 4) On the View menu, click Properties.
 * 5) In the Properties dialog box, click the Data tab.
 * 6) In the RecordSource property, type “Ten Most Expensive Products” (without the quotation marks).
 * 7) On the View menu, click Field List. The Field List window should appear.
 * 8) Drag the TenMostExpensiveProducts and UnitPrice columns from the field list, and drop them in the Details section of your report.
 * 9) On the View menu, click Print Preview.

= MORE INFORMATION =

For more information about stored procedures, follow these steps:


 * 1) Click Microsoft Access Help on the Help menu.
 * 2) Click the Contents tab.
 * 3) Click Working with Microsoft Access Projects.
 * 4) Click Comparing Access Projects to Access Databases.
 * 5) Click to view the Comparison of database objects between a Microsoft Access database and a Microsoft Access Project topic.

Additional query words: prb

=
========================================================= Keywords : kbdta AccessCS Version : WINDOWS:2000 Platform : WINDOWS Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1999.