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.

 

[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