Access 2000 Wizard fails

[Guest]

I've recently had Access installed and have encountered two problems:
1. When creating a command button on a form I get the error "Object variable
or With block variable not set" - result: the wizard cannot continue
2. When creating a Combo Box on a form, I get the error "You can only run
one instance of the Combo Box Wizard at a time" - result: the wizard cannot
continue.

I have tried booting my PC, restarting Access, and certainly cannot find a
second wizard anywhere else. Does anyone have a clue what is wrong here?

 

['69 Camaro]

Hi, Jo.

It sounds like your application has another instance of the Access Control
Wizards running, most likely from an earlier version of Access.

Check to ensure that your application isn't using the Access Control Wizards
as a referenced library. Open a module in the VB Editor. Select Tools
menu -> References... to open the References dialog window. Make sure that
acwzmain (from the acwzmain.mde file for Access 2K and newer versions) and
wzmain80 (WZMAIN80.MDE for Access 97) libraries aren't checked. (I don't
know the names of the files or projects for earlier versions of Access, but
if you've ever had those versions loaded on your computer, you may want to
research and find out for yourself.) If your database has any library
databases checked in the current database's References, then also look at
the References for those libraries, too.

If neither of these Wizard libraries are checked in the References, then
search the code modules for the strings "acwzmain.mde" and "wzmain80.mde" to
determine whether either of these file names are being used in a VBA
procedure. If you can't find these file names in the code, then look for
the following two function names: bw_Entry and cmb_Entry.

If you can't find either the file names or their Wizard entry points in a
VBA procedure, then you need to hunt through the properties of the database
objects for these strings. Use the Documentor to create a report, then save
the report in an Excel spreadsheet. Search through the spreadsheet's cells
for these two file names and entry point function names.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)