Remove Access Prompts

[wazza]

REMOVE ACCESS PROMPTS i.e. want to import?

hI

i have automated a process where data is imported by the click of a button.

I have achieved this... but one thing which i find annoying is a prompt from access - 'Would you like to append 126 rows?' I would rather the user didnt see this!

is there some way to remove the prompt using vb - so i can simply use my own user-friendly message....

Rgrds

 

[FoFa]

Either a macro or VBA SETWARNING off or false. If in VBA use DOCMD

 

[John.Woody]

Use Set Warnings i.e

Docmd.setwarnings false

Run your query and msgbox then

Docmd.setwarnings true


Don't forget the last line to turn the warnings back on otherwise you will not receive any other warnings which you may wish to receive

 

[wazza]

Excellant!

 

[WayneRyan]

wazza,

Tools --> Options --> Edit/Find

Confirm (Record changes, document deletions, Action queries)

Wayne