Remove Message 1

[Tom123456]

In my application I have a button that executes a Macro that runs a SQL query. The SQL query is an insert and generate a message in Access that says "Acces is about to insert records..." or somthing similiar. I have a swedish version so I don´t know if that is the correct words. How do I remove this message??

Help me!

- Tom

 

[Steve101]

In the macro, add a SetWarnings action, with the WarningsOn parameter set to No. After the query has finished running, you might want to set the WarningsOn parameter to Yes. Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[Tom123456]

Thanks a lot Steve. Simple but effective!

- Tom