Microsoft KB Archive/306326

= ACC2000: BUG: AutoReport Results in &quot;Subscript Out of Range&quot; Error =

Article ID: 306326

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q306326



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

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



SYMPTOMS
When you click the AutoReport: Columnar wizard in the New Report dialog box to create a report that is based on a query, you receive the following error message:

Subscript Out Of Range Error



RESOLUTION
Instead of the AutoReport: Columnar wizard, use the Report Wizard to create the report. To do so, follow these steps:
 * 1) Start Microsoft Access, and then open the database that you want to use.
 * 2) In the Database window, click Reports under Objects, and then click New.
 * 3) In the New Report dialog box, click Report Wizard, click the query that you want to base the report on in the Choose the table or query where the object's data comes from box, and then click OK.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft product listed at the beginning of this article.



Steps to Reproduce the Behavior
 Start Microsoft Access, and then open the sample database Northwind.mdb. In the Database window, click Reports under Objects, and then click New. In the New Report dialog box, click AutoReport: Columnar, click Alphabetical List of Products query in the Choose the table or query where the object's data comes from box, and then click OK.

Note that you receive the following error message:

Subscript Out Of Range Error



Additional query words: tabular, columnar

Keywords: kberrmsg kbbug kbfix KB306326

-

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

© Microsoft Corporation. All rights reserved.