I am having the same problem, but clicking on the 'Show All Actions' button
changes nothing. I assume another field should appear in the Action Arguments
section, but nothing happens when the 'Show All Action' button is selected.
This file is in a trusted location, so I'm not sure what the problem is. Any
ideas?
I have a database that was created in Access 2000. I am now working on it in
Access 2007. The database is in a trusted location.
I created a macro that runs a series of simple update queries. When each
query opens, I am prompted to allow the query to update data in the table - I
click "YES." I am then prompted to allow the query to update however the
number of rows the update applies to - I click "YES." This continues for each
query in the macro.
The only action arguments are Query Name, View and Data Mode. There is
nothing about the Set Warning. When I select Show All Actions in the Design
tool bar, nothing happens. I want this macro to run the queries without
prompting me for each one.
Okay, color my face several shades of red! I tried to do this at the
beginning, and I must have overlooked the setwarnings action in the list,
because I didn't see it and thought it was no longer set here in the 2007
version of Access.
Thanks for setting me straight. Have a great week!
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.