Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

SimonFinn

Programmer
Mar 13, 2003
130
GB
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
 
Prior to executing your query put:

Set Warnings False ... turn them off

once the job is done

Set Warnings True ... turn them on again!
 
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top