set docmd warning to false and still get message

[frenchy62]

When the unit works with a delete query or append a query
an error message keeps appearing. We went in the program and set the docmd.set warning to false. It works fine on our machine, but it still gives the warning on the other users pc. in the unit. How can I get this to work?

 

[flyover789]

assuming you have a startup for in your DB

in the on_open even of the startup form
enter

docmd.setwarnings false

HTH,
fly

Martin Serra Jr.

http://www.mserrasystems.de

 

[scriverb]

If you have a front-end(FE) and back-end(BE) database design you must put the code in the FE application code and then redistribute the code to all other users. If you all using the same application off of a server then any code you place in the app should be available to all user that logon and use the database. So, I am a little confused about your database structure.

Please advise.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[flyover789]

typo, meant to write

assuming you have a startup form in your DB

Martin Serra Jr.

http://www.mserrasystems.de