Microsoft KB Archive/109933

PRB: Report Wizard or Form Wizard List Box Empty in ADK

Article ID: Q109933
Creation Date: 10-JAN-1994
Revision Date: 05-FEB-1996 The information in this article applies to:

Microsoft Access version 1.1
Microsoft Access Distribution Kit version 1.1

SYMPTOMS

The list box to select a Report Wizard or Form Wizard is empty when you are running a Microsoft Access Development Kit (ADK) database application.

CAUSE

The list box to select a Report Wizard or Form Wizard is filled by a subprocedure in the WIZARD.MDA file that references the MSACCESS.INI file instead of the application's custom .INI file. Computers that do not have a full retail version of Microsoft Access installed do not have an MSACCESS.INI file.

RESOLUTION

There are two ways to resolve this problem:

Distribute a file named MSACCESS.INI with your custom application. This file must be located in the Windows directory, and must contain a [Form Wizards] and a [Report Wizards] section as follows:

      [Form Wizards]
      Single-Column=zwInitWizard, 1
      Tabular=zwInitWizard, 2
      Graph=zwInitWizard, 6
      Main/Subform=zwInitWizard, 7

      [Report Wizards]
      Single-Column=zwInitWizard, 3
      Groups/Totals=zwInitWizard, 4
      Mailing Label=zwInitWizard, 5

Change the GetWizards subprocedure in the WIZARD.MDA library to point to your application's custom .INI file.

You must unload the WIZARD.MDA database before you can edit it. To do this, Quit Microsoft Access, and edit the [Libraries] section of the MSACCESS.INI file. Comment out the Wizard entry in the file, and then save and close the file. Restart Microsoft Access and open the WIZARD.MDA database. Locate the GetWizards subprocedure and then modify it to be as follows.

NOTE: This article assumes that you are familiar with Access Basic and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information on Access Basic, please refer to the "Introduction to Programming" manual.

NOTE: In the following sample code, an underscore (_) is used as a line- continuation character. Remove the underscore at the end of the line when re-creating this code in Access Basic.
```
      Private Sub GetWizards (szWizSect As String, _
         cWizards As Integer, rgszWizards() As String, _
         rgszLpfn() As String, rgszArg() As String)
         Const szIni = "MyApp.INI"
```
After making these changes, Quit Microsoft Access and edit the [Libraries] section of the MSACCESS.INI file. Remove the semicolon from the beginning of the Wizard entry, and then save and close the file.

More Information

Steps to Reproduce Behavior

Rename the MSACCESS.INI file to MSACCESS.BAK.

Create the following new macro:

      Macro Name          Actions
      ------------------------------
      Macro1              SendKeys
                          DoMenuItem

      Macro1 Actions
      ---------------------------
      SendKeys
         Keystrokes: Suppliers %w
         Wait: No
      DoMenuItem
         Menu Bar: Database
         Menu Name: File
         Command: New
         Subcommand: Report

Add a command button to a form to run Macro1.
Run your application in the ADK environment.
Run the macro. Note that the Report Wizard starts, but the list box is empty.

REFERENCES

Microsoft Access "Introduction to Programming," version 1.1, Chapter 1-5

Microsoft Access "The Secrets of AccessWizards," version 1.1, Chapter 1

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Additional reference words: 1.10
KBCategory: kbusage
KBSubcategory: WzOthr