473,837 Members | 1,561 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Confirm deletions

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
5 4904
Did you turn SetWarnings off? Try:
DoCmd.SetWarnin gs 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.mega newsservers.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
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.SetWarnin gs 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*********@Se eSig.Invalid> wrote in message
news:41******** **************@ per-qv1-newsreader-01.iinet.net.au ...
Did you turn SetWarnings off? Try:
DoCmd.SetWarnin gs 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.mega newsservers.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
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.SetWarnin gs False somewhere without a balancing DoCmd.SetWarnin gs
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad. net> wrote in message
news:69******** *************** ****@msgid.mega newsservers.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.SetWarnin gs 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*********@Se eSig.Invalid> wrote in message
news:41******** **************@ per-qv1-newsreader-01.iinet.net.au ...
Did you turn SetWarnings off? Try:
DoCmd.SetWarnin gs 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.mega newsservers.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
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.megan ewsservers.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.SetWarnin gs False somewhere without a balancing DoCmd.SetWarnin gs
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad. net> wrote in message
news:69******** *************** ****@msgid.mega newsservers.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.SetWarnin gs 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*********@Se eSig.Invalid> wrote in message
news:41******** **************@ per-qv1-newsreader-01.iinet.net.au ...
> Did you turn SetWarnings off? Try:
> DoCmd.SetWarnin gs True
>
> "Squirrel" <wi*****@covad. net> wrote in message
> news:91******** *************** ****@msgid.mega newsservers.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
Allen,

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

Linda
"Allen Browne" <Al*********@Se eSig.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.megan ewsservers.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.SetWarnin gs False somewhere without a balancing DoCmd.SetWarnin gs
True? Would that state persist and exist in different databases?

Chagrined Squirrel.

"Squirrel" <wi*****@covad. net> wrote in message
news:69******** *************** ****@msgid.mega newsservers.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.SetWarnin gs 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*********@Se eSig.Invalid> wrote in message
news:41******** **************@ per-qv1-newsreader-01.iinet.net.au ...
> Did you turn SetWarnings off? Try:
> DoCmd.SetWarnin gs True
>
> "Squirrel" <wi*****@covad. net> wrote in message
> news:91******** *************** ****@msgid.mega newsservers.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1093
by: vishnu mahendra | last post by:
hello to all, there are two databases named A and B. One database contains employee id as primary I have another project database which includes that employee id as foreign key. How can I reflect my updations,deletions thank you in advance, vishnu
5
8990
by: Logger | last post by:
Help, I’m trying to implement a confirm button on an asp.net page. I have it attached to a asp:button control. In the button1 click event I call the CreateConfirmBox subroutine. The Box comes up with the yes/No option ok. My problem or question is: How do I determine which button was pressed? Below are the 2 routines I’m using. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...
1
1906
by: Will | last post by:
In Access 97 under options/edit find/Confirm - Record Changes, Document Deletions, Action Queries. Can someone tell me if these options are specific per each MDB file or are set by each PC's copy of Access? Thanks
0
1589
by: Joe Finsterwald | last post by:
Recently I needed to add a confirm to a LinkButton that called a JavaScript function on success, and did nothing on failure. I found documentation on adding a confirm, but not on how to place a confirm in a conditional. In any case, I've found the answer and I thought I'd share. In VB.NET (in the code behind in VS.NET) Adding just a confirm...
4
10027
by: tfsmag | last post by:
Okay, I have a project management app i'm writing and in the left hand menu i have a treeview control that is populated with each project... in child nodes under each project node I have an "edit" and a "delete" node. I have the functionality of the edit and delete working fine, my issue is now however that I cannot seem to find a way to add an "onclick" event that fires a confirm box. I've tried this method.. treenode.Text = "<a...
8
4037
by: rn5a | last post by:
I have gone through a no. of posts in this NewsGroup regarding my problem but alas, couldn't come across one which would have helped me in resolving the issue. My problem is this: An ASPX Form has a Button. When the Button is clicked, I want a JavaScript confirm dialog to pop-up with the options 'OK' & 'Cancel'. I have done this using the following code: Sub Page_Load(....) btnClick.Attributes.Add("OnClick", "javascript:return...
3
2144
by: blakerrr | last post by:
Hello World! I'm a rookie with access and my green skin needs a little help. I have two tables, one called BOM and one called Junction. BOM contains parts and assemblies and subassemblies info and has ModID as the primary key. Junction has three fields: ID (autonumbered primary key), Parents (related to ModID as one-to-many) and Children (related to parents as one-to-many). I need to have cascade update and cascade delete capability for...
8
4022
by: BASSPU03 | last post by:
I'm using Access 2003 on a Windows XP O/S. I've made two copies of Form1 so that there're are 3 forms: 1) Form1 2) Form2 3) Form3 Essentially, they all write to the same Table1.
1
1233
by: poonam jaiswal | last post by:
I m developing an application in asp.net(c#)with msaccess as back end. selection query is working properly but deletions and insertions are givig an following errors: operation must use an updateable query . please give me solution, its urgent.
0
9844
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
9683
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10883
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10578
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9409
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7813
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7006
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5670
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4477
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.