Hi Jimbo,
Here is my standard blurb on wizard-related problems:
Wizards not working
Try the following steps. You possibly have other wizards that are not
functional as well.
Replace three files on your hard drive, Acwzmain.mde, Acwzlib.mde and
Acwztool.mde, using the instructions shown in KB 303769. One or more of these
files may have become corrupted. Do this without Access running.
http://support.microsoft.com/?id=303769
http://support.microsoft.com/?id=833220 <--- Error in loading DLL
1.) Insert the Microsoft Office or Access compact disc.
2.) By using Windows Explorer, open the Pfiles\Msoffice\Office\1033
folder on your CD-ROM or DVD-ROM drive, and locate the
Acwzmain.mde, Acwzlib.mde and Acwztool.mde files.
3.) Select these files, and then click Copy on the Edit menu
4.) Open the folder that you installed Office into. The default folder is
C:\Program Files\Microsoft Office. Select the Office\1033 folder,
and then on the Edit menu, click Paste.
If that doesn't fix the problem, try re-registering the Accwiz.dll,
Msado15.dll and DAO360.dll files.
Click on Start > Run. Then enter the commands:
Regsvr32 Accwiz.dll
Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"
Wizard starts, but "No valid fields can be found" error message may be
related to overly aggressive settings on antivirus software:
http://groups.google.com/group/microsoft.public.access.tablesdbdesign...
and
http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-vi...
Access 2003 Users:
BUG: List of currently linked tables may not appear in
Linked Table Manager Wizard in a database in Access 2003
http://support.microsoft.com/?id=835519
Notes:
1. To find Accwiz.dll in Win. XP Professional, I had to make sure to place a
check on Advanced Options in the search dialog, with Search system folders
and Search Subfolders checked.
2. Although I received a message indicating success, when using regsvr32, I
found that the path was not updated. I had to manually update the value of
this key on my PC.
Tom Wickerath
Microsoft Access MVPhttps://mvp.support.microsoft.com/profile/Tomhttp://
www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
Jimbo said:
When I initiate the "Simple Query Wizard", I am presented with the first
screen - "What fields do you want in your query"
When I click on the pulldown list to select a table, I get the following
message:
"The expression On Get Focus you entered as the event property setting
produced the following error: the text you entered isn't an item in the list
* the expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro"
If I click on "OK", I am presented with the list, but if I select a table,
it "hangs" (hourglass)
The only waya out is to "cancel" and exit Access
Any help ?
JM- Hide quoted text -
- Show quoted text -
