Queries have stopped displaying error messages

[Gillian]

Hi

I have an access 2000 format database running on Access 2003.

The delete/append/update queries have stopped displaying warning messages
when they are run either by double clicking on the query or by running in
query via the ! button.

I do frequently use the docmd.setwarnings false command in code but i
haven't in this application.

In fact the application is so new that there are only queries and tables no
forms or code.

Any help would be greatly appreciated.

Thanks

 

[MGFoster]

Hi

I have an access 2000 format database running on Access 2003.

The delete/append/update queries have stopped displaying warning messages
when they are run either by double clicking on the query or by running in
query via the ! button.

I do frequently use the docmd.setwarnings false command in code but i
haven't in this application.

In fact the application is so new that there are only queries and tables no
forms or code.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the Database menu bar select Tools > Options. Under the Edit/Find
tab in the Confirm area check the check boxes for "Record changes" and
"Action queries."

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdJaboechKqOuFEgEQKd7ACgm6VdUmWiqq1XHZjFQMEPcYW5gToAoJxO
wIzt17i8roMkrfgb1l8uo3im
=H6ms
-----END PGP SIGNATURE-----

 

[Gillian]

Thanks that fixed it.

Gillian

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

In the Database menu bar select Tools > Options. Under the Edit/Find
tab in the Confirm area check the check boxes for "Record changes" and
"Action queries."

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdJaboechKqOuFEgEQKd7ACgm6VdUmWiqq1XHZjFQMEPcYW5gToAoJxO
wIzt17i8roMkrfgb1l8uo3im
=H6ms
-----END PGP SIGNATURE-----