A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2000 Wizard fails



 
 
Thread Tools Display Modes
  #1  
Old September 8th, 2004, 01:13 PM
Jo
external usenet poster
 
Posts: n/a
Default 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  
Old September 8th, 2004, 08:15 PM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.