If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 Wizard fails
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? |
#2
|
|||
|
|||
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.) "Jo" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |
access 97 and access 2000 problem/question... | warpman | General Discussion | 5 | June 20th, 2004 03:16 AM |
Problem running Access 2003 and Access 2000 apps on same machine. | Rathtap | General Discussion | 3 | June 13th, 2004 01:30 AM |
Access 2000 Crashes when creating a query using the wizard | Dale Hobbs | Running & Setting Up Queries | 1 | June 3rd, 2004 08:23 AM |