Access XP simple query wizard error

B

Bob Kang

I have what appears to be a bug in Access XP. Has anyone else seen this
and/or found

a fix?

Environment(s):
Windows 2000 Pro SP2
Windows 2000 Pro SP3
Windows XP Pro SP1
Office XP(2002) SP3 (Clean install)

Steps to recreate:
1. Create a new database
2. Create/import any table
3. Create a new *update* query in design view to update the table in step
2
4. Now create a new query with the simple query wizard
5. In the simple query wizard dialogue, select a table or query from the
drop down

list of database objects

Results:
When we do this, we get an error--
"The expression On Got 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."

Also, the cursor turns to an hourglass, and will not return to the normal
pointer

cursor unless you close the database and reopen it.

Notes:
This seems to be specific to the case where the cursor happens to be on
an *update*

query when you start the simple query wizard. It does not seem to happen
if the

cursor is on a Select, Crosstab, or Delete query when starting the
simple query

wizard.

I searched the knowledge base and did not find any references to this
error

TIA,

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top