confirm messages

[Guest]

Developed a program in Access 2000. Turned off confirm messages for queries
in tools options. Works fine when installed on Win 98 or Win 2000. Confirm
messages return when installed on Win XP. How can I prevent this, other than
redeveloping in Access 2003.

Thanks

 

[Guest]

If it is a networked database, and you distribute the front end to end users
workstations, these settings don't go with the front end. These settings are
controlled at an individual workstation level. I suggest controlling the
warnings at an individual procedure level.

At an individual procedure level you can set the warnings to off and back on
again in VBA.

' Set update warnings to off
DoCmd.SetWarnings (WarningsOff)

' Then run action queries

' Set update warnings back on
DoCmd.SetWarnings (WarningsOn)

' If you are not familiar with VBA, you can do the same via macros
' and apply the macro to whereever necessary.