Confirmation Messages

[doran_doran]

confirmation messages on :::: Not working

Hi everyone,

For some reason my confirmation messages on is not working.

I am using Access 97,

1 On the Tools menu, click Options.
2 Click the Edit/Find tab.
3 Under Confirm, select or clear the appropriate check boxes.

It has been working all this time but all the sudden it not prompting when I deleted some records using query.

Any help will be appreciated.

 

[Mile-O]

Are you using code or a macro that sets Warnings to false that either: does not have an opposite setting the Warnings to True OR an error occurs before the Warnings are reset to True?

 

[doran_doran]

simple delete query...

I used to get a prompt "are you sure about this delete" or have you when i did a simple deletion query using microsoft access build in query. No macro or code.

Or find and replace does not prompt me either.

hmm. i dont know. someone posted ealier (lala) that she just has to restart her pc to get this to work.

 

[doran_doran]

I got it....

One of my other database has setwarning set to false and i was using that database before opening this database. and the setwarning was sitting in the memory.

How do I clear memory when exiting a database? That way my user get all the prompts.

 

[Pat Hartman]

Rather than trying to control a global setting on exit, it is better to control it on entry. So in the Open event of your main form, set the warnings on. In your own databases, make sure you trun warnings back on ASAP if you ever turn them off with code.

 

[AnnPhil]

turn off confirmation in SQL server

Hello Pat,

I have a similar problem but mine is with msproject frontend and SQL backend. How can i turn off the confirmations? In Access i could turn it off in the tools, option but with MSProject it is not available. My guess is that i will have to write code? or is there a place in SQL Enterprise Manager to do this?

Thanks for your help