Command Button Wizard

[AccessTaxMan]

My database includes regular Select, Append and Delete Queries. On a form,
when creating a command button from the tool box with the wizard, after
choosing the Run Query Action, none of the Delete Queries are in the list.
The others are displayed, and can be chosen. An obvious way around this is
to write my own Click Event Procedure code. But, what's a wizard for blah
blah blah. Is anyone aware of some user level option or setting that may be
preventing the wizard from listing all queries?

 

[Dirk Goldgar]

My database includes regular Select, Append and Delete Queries. On a
form, when creating a command button from the tool box with the
wizard, after choosing the Run Query Action, none of the Delete
Queries are in the list. The others are displayed, and can be chosen.
An obvious way around this is to write my own Click Event Procedure
code. But, what's a wizard for blah blah blah. Is anyone aware of
some user level option or setting that may be preventing the wizard
from listing all queries?

I think this is a bug, probably related to the same underlying cause as
this:

http://support.microsoft.com/kb/888636/
Documenter does not display the DELETE query
in Microsoft Access

I didn't immediately find a KB article for your specific problem, but
they sound very similar. And I can reproduce your problem in my own
Access 2002 installation.

 

[AccessTaxMan]

Bingo. Solves my problem at the database level. Many thanks.

Hmmmmm? I wonder if I should notify our Tech Support staff?????