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

The information in this article applies to:

• Microsoft Access version 1.1
• Microsoft Access Distribution Kit version 1.1

• 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.

1. Rename the MSACCESS.INI file to MSACCESS.BAK.
2. 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
   

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