Remove "You are about to append 1 row(s)" msgbox

[SimonFinn]

Hi Guys

Im executing a data definition statement from Access/VBA and was wondering if i can disable the "You are about to append 1 row(s)" msgboxs perminently (or temporeraly if i have to) in access?

Thanks Si

 

[Trendsetter]

Prior to executing your query put:

Set Warnings False ... turn them off

once the job is done

Set Warnings True ... turn them on again!

 

[SimonFinn]

Hi Trendsetter

Could i do this on form_load and switch off on exit or would that cause problems?

Does it affect, errors, error handleing and code created msgbox's?

Thanks Si

 

[dongal]

You can perminently stop warnings in Access by going to the Tools menu and selecting options.
On the Edit/Find tab you will find a box called confirm.
Unchecking actions queries will remove all messages for queries.
Unchecking record changes removes messages for appending or deleting any records.

Dongal

 

[BeginnerProgrammer]

I usually do this by running all my queries with a macro. In the macro I turn warnings off and then back on.

Hope this helps