 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Simple Query Wizard hangs
I am using Access 2003 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 ? TIA JM 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/browse_frm /thread/287b312d799c6739/2543458dbca8ddde and http://alexdyb.blogspot.com/2006/02/be-careful-with-kaspersky-anti-virus.html 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 MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > I am using Access 2003 > [quoted text clipped - 21 lines] > > JM WOW! That was fast and comprehensive I forgot to mention that this only happens when I use the "New" Icon, as opposed to selecting "Create a query using wizard" Does this matter ? Many Thanks JM > Hi Jimbo, > [quoted text clipped - 85 lines] >> >> JM Hi Jim, > WOW! That was fast and comprehensive The copy and paste technique at work, when answering questions! <smile> > Does this matter ? I don't know. Give the directions a try, and please report back what you found out. Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > WOW! That was fast and comprehensive > [quoted text clipped - 6 lines] > > JM U is Da Man !!! The first fix did it Many Thanks again (See you next time - there will be one !!) > Hi Jim, > [quoted text clipped - 23 lines] >> >> JM Hi Jim, You're very welcome. Glad I could be of help. By the way, this tip is shown on page 5 of my "Access Links.doc" Word document. You can download a zipped copy from here if you'd like: http://home.comcast.net/~tutorme2/samples/accesslinks.zip Tom Wickerath Microsoft Access MVP https://mvp.support.microsoft.com/profile/Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > U is Da Man !!! > [quoted text clipped - 3 lines] > > (See you next time - there will be one !!) I'm just curious-- why ADO 1.5? 2.5 ships with Windows 2000.. 2.6 with Windows XP > 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. [quoted text clipped - 72 lines] > > - Show quoted text - Access MDB randomly craps out-- I'd move to SQL Server > I am using Access 2003 > [quoted text clipped - 21 lines] > > JM |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.