Hi there,

when i press delete button, i get built-in access confirmation msgbox "you are about to delete xx records" or smth like that. But on other computer i don't see it (if i use the same db)..... there should be somewhere in access where i could turn this on or off?

Where could i turnt it off

Thanks

you have probably either
run a macro and done something like "set warnings off"
OR
in your settings disabled warnings
HTH

Thanks, it was in options

For the love of god do not turn that off in options.

I use set warnings false and set warnings true. The second part is kind of important...

Well i have my own msg box for confirm deletion, so double msgboxes was annoying

Right... "setwarnings false" does a whole lot more than disable sql confirmation messages...

If you are that concerned, or insist on putting in your own message box, then consider turning warnings off in code immediately before the step that generates the message box, and off immediately after.

Failing to do that can cause serious problems with your applciations - precisley the sort of problems that are virtually impossible to debug by remote.

Me personally, I use:

SetOption "Confirm Action Queries", False

before I run an action query (delete, append, update)

and then

SetOption "Confirm Action Queries", True

I believe it is more specific than turning off all the warnings. The confirmation message will not appear using this command.

oooooooooooo.... aahhhhhhhhh....

good trick, that one gets filed in "Teddy's Bag O' Good Stuff".

Of course now I have to go rifling through docs to find out what else I can destroy using SetOption...