confirm messages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Access 2000 Confirm Messages - 18 May 2005 21:05 GMT

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

Reply to this Message

Dylan Moran - 19 May 2005 05:49 GMT

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.

Signature

I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

> 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

Reply to this Message