Confirm action queries on a distributed application 
Author Message
 Confirm action queries on a distributed application

Quote:

>I made an application on Access97 and I distribute it to people who does not
>have Access on their machine by using the ODE tools. They are all NT4.0
>clients.

>The application works fine, but anytime the user tries to make something
>that runs in the background a piece of code that makes a change on some
>table, s/he has to confirm a message such as "You are about to update 12
>rows from the specified table... Are you  sure?..." e.g. , as if the
>Tools/Options/Edit-Find/Confirm/Action Queries is checked. (BTW, I mostly
>use docmd.runsql to run sql statements that make changes on my tables).

I prefer currentdb.execute strSQL,dbfailonerror as this doesn't give
you those messages.

You can put a docmd.setwarnings false statement in but make very, very
sure you put in the docmd.setwarnings true in afterwards including in
any error handling.  Otherwise various defaults will be applied to
messages which you didn't want taken.

Tony
----
Message posted to newsgroup and, if appropriate, emailed.
Tony Toews, Independent Computer Consultant
Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.*-*-*.com/
VolStar http://www.*-*-*.com/ Manage hundreds or
   thousands of volunteers for special events.



Sun, 12 May 2002 03:00:00 GMT  
 Confirm action queries on a distributed application
Alternatively run
Docmd.SetWarnings False
before your code and
Docmd.SetWarnings True
after your code.

Sam Judson


Quote:

> >I made an application on Access97 and I distribute it to people who does
not
> >have Access on their machine by using the ODE tools. They are all NT4.0
> >clients.

> >The application works fine, but anytime the user tries to make something
> >that runs in the background a piece of code that makes a change on some
> >table, s/he has to confirm a message such as "You are about to update 12
> >rows from the specified table... Are you  sure?..." e.g. , as if the
> >Tools/Options/Edit-Find/Confirm/Action Queries is checked. (BTW, I mostly
> >use docmd.runsql to run sql statements that make changes on my tables).

> I prefer currentdb.execute strSQL,dbfailonerror as this doesn't give
> you those messages.

> You can put a docmd.setwarnings false statement in but make very, very
> sure you put in the docmd.setwarnings true in afterwards including in
> any error handling.  Otherwise various defaults will be applied to
> messages which you didn't want taken.

> Tony
> ----
> Message posted to newsgroup and, if appropriate, emailed.
> Tony Toews, Independent Computer Consultant
> Microsoft Access Links, Hints, Tips & Accounting Systems at
>    http://www.granite.ab.ca/accsmstr.htm
> VolStar http://www.volstar.com Manage hundreds or
>    thousands of volunteers for special events.



Mon, 20 May 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Action Query without prompt to confirm action??

2. Confirm Action Queries Unreliable

3. Changing the Confirm Action Queries property

4. switch of action query confirm from vb

5. Disable Confirm Action Query message in ACCESS RunTime

6. Confirm Action Query default setting

7. Turn Off Action Query Confirm

8. Confirming action queries

9. How to Use VBA to uncheck Tools | Options | Confirm Action Queries

10. Turn off confirm action Queries


 
Powered by phpBB® Forum Software © phpBB Group