The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers. This article applies only to a Microsoft Access project (.adp). SYMPTOMSWhen you create a new form, report or data access page, the New Form, New Report and New Data Access Page dialog boxes do not list any of your Stored Procedures in the list of available data sources for the object. When you create these objects using a wizard, stored procedures are also not listed in the Tables/Views list within the wizard. CAUSEThe functionality for displaying stored procedures as potential record sources in the New <object> dialog box and in the wizards for forms, reports, and data access pages was not included in Microsoft Access 2000. RESOLUTIONIn Design view of the object, select a stored procedure as a record source. To do so, use one of the following methods. For Forms or ReportsIn Design view, on the View menu, click Properties. Click the Data tab, and type the stored procedure name in the RecordSource property box.For example:
For Data Access PagesIn Design view, if the field list is not visible, click Field List on the View menu. Click the plus sign (+) next to Stored Procedures. Click the stored procedure to use for this page.MORE INFORMATIONSteps to Reproduce Behavior
Additional query words: pra prb record source wizard stored procedure proc
Keywords : kbdta AccessCS |
Last Reviewed: July 12, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |