How do I report what I believe is a bug?

[Guest]

Hourglass and following error produced when trying to begin Simple Query
Wizard, if cursor is on “Make Table†type Query when entering the Simple
Query Wizard. The error is "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."

To duplicate:

Place cursor on a make table query.
Click “Query†in Objects
Click “Newâ€
Click “Simple Query Wizardâ€
(“Make Query†appears in box – normally Simple Query Wizard hides them).
Click down arrow
Get error and an hourglass (expect neither)
Click another database or query listed
You can proceed but the hourglass remains. You must cancel and close Access
to get rid of the hourglass.


Have installed Office 2003 Service Pack 1.

 

[Joan Wild]

Hourglass and following error produced when trying to begin Simple Query
Wizard, if cursor is on "Make Table" type Query when entering the Simple
Query Wizard. The error is "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."

To duplicate:

Place cursor on a make table query.
Click "Query" in Objects
Click "New"
Click "Simple Query Wizard"
("Make Query" appears in box - normally Simple Query Wizard hides them).
Click down arrow
Get error and an hourglass (expect neither)
Click another database or query listed
You can proceed but the hourglass remains. You must cancel and close
Access
to get rid of the hourglass.


Have installed Office 2003 Service Pack 1.

Well I am able to reproduce following your steps. By the way, you don't
have to close Access to get rid of the hourglass. Just hit Ctrl-G and type
Docmd.Hourglass False and hit enter.

If you want to use the Simple Query Wizard, don't go to 'New' and then
choose it, just double click 'Create query by using wizard' (that way it
won't matter what object you have selected in the window).

But still, it is a bug. I believe you can report bugs via PSS
http://support.microsoft.com/oas/default.aspx?&gprid=25099&, but I will
report it.

 

[Guest]

Thank you for reporting the bug for me. I discovered it before installing
SP1, and I believe it would not let me proceed with my work. So I installed
SP1 to make sure it hadn't been fixed and then wrote. It threw me for a loop
for an hour or so.

I tried your instructions to remove the hourglass, and got a Visual Basic
box with "Immediate" written above it. However, whatever I type does not
show up, and it didn't remove the hourglass. Perhaps this is because I do
not have Visual Basic installed?

I checked out the site you mentioned. I do not have paid support (am a home
user of Access), and could see no way to report bugs in Access through the
avenues open to me there.

 

[Joan Wild]

I tried your instructions to remove the hourglass, and got a Visual Basic
box with "Immediate" written above it. However, whatever I type does not
show up, and it didn't remove the hourglass. Perhaps this is because I do
not have Visual Basic installed?

No with Access, you have Visual Basic for Applications installed (VBA).
Perhaps the focus is somewhere else. In that 'Iimmediate' window click once
to ensure your cursor is focused there. Then type Docmd.Hourglass False and
hit enter.

 

[Guest]

No with Access, you have Visual Basic for Applications installed (VBA).
Perhaps the focus is somewhere else. In that 'Iimmediate' window click once
to ensure your cursor is focused there. Then type Docmd.Hourglass False and
hit enter.

 

[Guest]

I see now. I have say "OK" to the error, chose another query or database
(than the default make DB query), cancel out of Simple Query Wizard, then I
can do the CTRL-G and enter Docmd.Hourglass False command.

If I don't chose another query upon getting the error, I can't get out of
Simple Query Wizard at all - which is what originally made life difficult for
me.

I'll use your other method of entering Simple Query Wizard from now on.

If I should ever encounter another bug - do I report it through here?

 

[Joan Wild]

If I should ever encounter another bug - do I report it through here?

It's a good idea to post here, because quite often people think they've
found a bug, but it isn't one. By posting here you can get others to see if
they can reproduce it.