By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

Confirm deletions

P: n/a
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


Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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


Nov 13 '05 #3

P: n/a
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



Nov 13 '05 #4

P: n/a
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

Nov 13 '05 #5

P: n/a
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


Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.