Allen,
I still don't have a fix but have another observation.
First I tried this:
' debugging loss of prompt before deletion
Public Function warningsOn() As Boolean
DoCmd.SetWarnings True
DoCmd.RunSQL "UPDATE junk SET junk.Type = 'hello';"
MsgBox "done"
End Function
It updates the table, indicates "done". No prompt.
Have also observed a different behaviour when opening a new query. ie. go
to the Query window, select the New option, design a query which defaults to
the name of Query1. The usual behaviour when I would close that query is
that I'd be prompted as to whether or not I wanted to save it; now what it's
doing is only offering me the Save As dialog. I can no longer choose not to
save the query. I have to save it as something i.e. Query1 then go and
delete it - deletion without the prompt of course.
What the hell have I done? Same behaviour in different databases so this
new behaviour does not belong to a specific database.
thx for your help.
Linda
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41**********************@per-qv1-newsreader-01.iinet.net.au...
Did you turn SetWarnings off? Try:
DoCmd.SetWarnings True
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Squirrel" <wi*****@covad.net> wrote in message
news:91***************************@msgid.meganewss ervers.com...I have an Access 2002 db and via Tools->Options->EditFind have checked
the checkboxes for Confirm Document Deletions and Confirm Action Queries but
get
no confirmation prompt when I e.g. delete a table or run an update
query.
Is there another setting I must use?
Thank you for any advice you can offer.
Linda