Confirm deletions

[Squirrel]

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

[Allen Browne]

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

[Squirrel]

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

[Squirrel]

Well I don't understand how I achieved that state but have recovered from it
via rebooting.
Any insight would be appreciated. Is it possible that I have a
DoCmd.SetWarnings False somewhere without a balancing DoCmd.SetWarnings
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad.net> wrote in message
news:69***************************@msgid.meganewss ervers.com...

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

[Allen Browne]

Good 'ol rebooting, eh? Solves many things.
Kinda like the newspaper heading, "Something went wrong in plane crash,
expert says." :-)

SetWarnings should only apply to the current instance of Access, as you
already understand, I think.

--
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:75**************************@msgid.meganewsse rvers.com...

Well I don't understand how I achieved that state but have recovered from
it
via rebooting.
Any insight would be appreciated. Is it possible that I have a
DoCmd.SetWarnings False somewhere without a balancing DoCmd.SetWarnings
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad.net> wrote in message
news:69***************************@msgid.meganewss ervers.com...

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
>
> "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

[Squirrel]

Allen,

thx for your advice. It's really good of you to share your knowledge so
generously.

Linda
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:41**********************@per-qv1-newsreader-01.iinet.net.au...

Good 'ol rebooting, eh? Solves many things.
Kinda like the newspaper heading, "Something went wrong in plane crash,
expert says." :-)

SetWarnings should only apply to the current instance of Access, as you
already understand, I think.

--
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:75**************************@msgid.meganewsse rvers.com...

Well I don't understand how I achieved that state but have recovered from it
via rebooting.
Any insight would be appreciated. Is it possible that I have a
DoCmd.SetWarnings False somewhere without a balancing DoCmd.SetWarnings
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad.net> wrote in message
news:69***************************@msgid.meganewss ervers.com...

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
>
> "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