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
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