Delete Query Message disappeared

[Guest]

I have a 'Delete' query that used to display a message box saying 'You are
about to delete 95 records. Do you want to continue' - Yes/No -- But now
the delete query runs and deletes the records but the message box does not
display. Is there a simple way to get the warning message back? Thanks

 

[Roger Carlson]

Two questions:

1) how are you running the query? Manually (from the Access GUI) or from
code?
2) Do you have any SetWarning commands anywhere in the application?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I am running the qry manually from Access qry window - the msgs appear to be
on now. Not sure why they were off before? Maybe something cleared and came
back on when I exited and re opened the db. There is some VBA coded modules
in the db. But I always run the delete queries manually from the access
window.
Thanks for your quick reply.

 

[Roger Carlson]

Good. Look through the modules for a line that looks like this:

Set Warnings False

This will turn off all of those dialog warning boxes. Usually, these are
followed by:

Set Warnings True

which turns them back on. But if the code gets interrupted for some reason,
and they don't get turned back on, they'll stay off until you close and
re-open the database. Since that's what cleared it, I suspect that's your
problem. Nothing you really need to fix, just something to be aware of.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger,

Thanks for the tip(s). I found the SetWarnings False statement and
commented it out for the time being. I am modifying a process/program and
there is a line of code such as .... getplayer_number 'Add playernumber and
name from UniquePlayer qry'

Can you decifer what this line of code does? Let me know if I should start
a new post in a different category.
Thanks