General discussion

Locked

Access 2000 and SQL INSERT statement

By AJD ·
How do I stop Access 2000 asking "Are you sure you want to ..." after each SQL INSERT statement. I have attached a macro to a combo box that runs a SQL INSERT every time a new value is selected. I want this to be transparent and not be prompted every time.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 and SQL INSERT statement

by whyong In reply to Access 2000 and SQL INSER ...

before your sql statement, select "setwarnings" in the action tab, then set the "warnings on" to "No".
after runsql action, you can set the warnings on to "yes" again if you want to.

hope that this is what you want... happy coding.

Collapse -

Access 2000 and SQL INSERT statement

by AJD In reply to Access 2000 and SQL INSER ...

This is exactly what I needed - thank you very much.

Collapse -

Access 2000 and SQL INSERT statement

by Bob Sellman In reply to Access 2000 and SQL INSER ...

Go to Tools, Options.
Select the Edit/Find tab.
In the confirm box, uncheck Action Queries.
You can also, if you want, uncheck the confirmation of record changes and/or document deletions.

This also works in Access 97.

Collapse -

Access 2000 and SQL INSERT statement

by AJD In reply to Access 2000 and SQL INSER ...

Thanks for the tip but I wanted a solution that I didn't have to configure on every workstation.

Collapse -

Access 2000 and SQL INSERT statement

by AJD In reply to Access 2000 and SQL INSER ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums