1

Topic: Why the question on removal of records is not disconnected

DoCmd. SetWarnings False
' we CLEAR FORMER GIVEN to Delete medicines
DoCmd. OpenQuery "MEDICAMENTI_PODBOR_UDALENIE_VSEGO_QUE"

Then there is a code on adding

Do Until RST.EOF
DoCmd. RunSQL "Insert into PACIENT_DOGOVOR_MES_PODBOR_TBL" _
.........
DoCmd. SetWarnings True

Both on removal and on each record of adding jumps out a question on acknowledgement of actions.
Access Runtime 2007
In basis adjustments there is a tick acknowledgement of removal of documents.
------------------------------------------------------------------------
Thanks for the answer.

2

Re: Why the question on removal of records is not disconnected

;
In that ccess 2007 in which I write the program - questions it is not set, all does .
And here on check in Runtime 2007 - questions jump out.
Here in what .

3

Re: Why the question on removal of records is not disconnected

So why in runtime switch-off of acknowledgement of performance of append query can not work?

DoCmd. SetWarnings False
DoCmd. RunSQL...
DoCmd. SetWarnings True

4

Re: Why the question on removal of records is not disconnected

;
I left from usage.
Then all becomes uncontrollable.
:-(

5

Re: Why the question on removal of records is not disconnected

58 wrote:

... Then all becomes uncontrollable.

And unless the code not is written by you? smile))

6

Re: Why the question on removal of records is not disconnected

58 wrote:

I left from usage.
Then all becomes uncontrollable.

How it?? Here is how time with RunSQL it is uncontrollable: it is impossible to look, how many lines are processed, if suddenly somewhere because of an error did not include the warning, it is possible to heap up in basis casually much that - all system ceases to ask acknowledgement, for example, on saving of changes in object.
I normally always remove all RunSQL in any program which to me gets to hands.
At RunSQL before Execute I do not know advantages.

7

Re: Why the question on removal of records is not disconnected

MrShin, well, but
At me a problem another.
sewarning False
And all the same asks acknowledgement...
:-(

8

Re: Why the question on removal of records is not disconnected

58;
And  Execute?

9

Re: Why the question on removal of records is not disconnected

sdku;
.
That effect.
Something with basis.
With a program something.

10

Re: Why the question on removal of records is not disconnected

58 wrote:

sdku;
.
That effect.
something with basis.
With a program something.

you answered the question (and the reasons can be much)

11

Re: Why the question on removal of records is not disconnected

58 wrote:

In basis adjustments there is a tick acknowledgement of removal of documents.

And it is necessary that it was not...
It is possible to deliver 2007 , to remove a tick, then to delete , on idea now and  will work without a tick, at least on 2003 m so rolled
And generally search where this  is written to the register and for 2007
At me it is all was for what office in what branch of that and as, but I can not find...

12

Re: Why the question on removal of records is not disconnected

58;
More shortly here an insertion in the register after which rt2007 should not swear on change of records and requests;
You can glance at first that there now in the register costs (open a file a notepad you will look branches)

13

Re: Why the question on removal of records is not disconnected

vmag;
on other computer, there where the program will work.
Checked up on two computers, even not  swears.
Something with a program file not that.
Imported in pure, created mde - all the same asks acknowledgement on change.
In the table 27 records will be added...
And acknowledgement of each record asks...
More shortly not .

14

Re: Why the question on removal of records is not disconnected

sdku;
Thanks for .

15

Re: Why the question on removal of records is not disconnected

58 wrote:

checked up on two computers, even not  swears.

Screen show, who swears that?
You can not that treat, there is  + still what a thread , treat one, another swears, for certain on that computer there is an office is higher 2007

16

Re: Why the question on removal of records is not disconnected

vmag;
Yes.
The office is more adult swears.
And  native if one current costs, too asks:
You are assured, your mother, or are not assured....
==============================
And on my computer where Access2007 costs - that does not ask...
Type the floor rubbed Gates.

17

Re: Why the question on removal of records is not disconnected

58;
Well also what you want?
- At office is more adult disconnect ticks (if he swears then the program in it and is fulfilled,  2007 it is not necessary here generally).
- On bare  at you by default these ticks stand, my file should help to import editing to the register;
For these editings only for 2007, the senior they on a drum...
- On the computer you removed these ticks hands, on it does not swear

18

Re: Why the question on removal of records is not disconnected

vmag;
DoCmd. SetWarnings
Use value True (-1) to include display system messages and value False (0), to disconnect it.
I use False (0)
DoCmd. SetWarnings False
Should not it is deduced messages, and they are deduced.
Estimate.

19

Re: Why the question on removal of records is not disconnected

58 wrote:

should not it is deduced messages, and they are deduced.

In Open_Form the start form interpose here it

Application. SetOption "Confirm Record Changes", False ' acknowledgement of requests about change
Application. SetOption "Confirm Document Deletions", False ' acknowledgement of removal of documents
Application. SetOption "Confirm Action Queries", False ' acknowledgement of action of requests

20

Re: Why the question on removal of records is not disconnected

vmag;
Thanks.
Interposed already.
To the program on figs.

21

Re: Why the question on removal of records is not disconnected

58, if the problem does not dare - means, you either not that, or not so or not there solve wink In total that three variants)
Aforementioned commands
Application. SetOption "Confirm Record Changes", False ' acknowledgement of requests about change
Application. SetOption "Confirm Document Deletions", False ' acknowledgement of removal of documents
Application. SetOption "Confirm Action Queries", False ' acknowledgement of action of requests
- I use, and all works only in a way.
Unless on specific errors of the message .
Therefore - I first of all would understand your case, under which jacket (the version of Aksa, ) your application is launched. And further already already to rummage a search method in these directions.
To walk on jacket adjustments (if it not , )
Then to check up your application.
To make empty basis, to make in it pair of tables, the start form, in it for loading to hang up aforementioned "", to make the form with pair buttons, to hang up on them commands on removal/addition, even to tire out in mde. And further it is simple: if the new basis behaves normally, not  - means, in your application business. Probably, in one of forms / a macro there are commands which include acknowledgement.
If the new basis  - means, it is necessary to climb in adjustments of the jacket.

22

Re: Why the question on removal of records is not disconnected

Tarasios;
Thanks.
In it also I am engaged.

23

Re: Why the question on removal of records is not disconnected

58, I re-read a branch and couples me  overcome.
Judging by your words, you want that acknowledgement  on adding, removal, change only would not be displayed. Thus, by your words:
1. In basis adjustments there is a tick acknowledgement of removal of documents.
2. You suppress included by you (those ticks) acknowledgement of system by a method "generally any messages".
3. There and then, after some procedures, include all messages of system
Such sensation that or you were tangled, that want, or try to delete tonsils a method through one place wink)
If you need to save possibility  to produce an error message that happens it is useful, and at the same time to remove irritating questions on removal/adding/change at all do not touch  DoCmd. SetWarnings True/False
Simply in most  remove ticks from acknowledgement on removal/adding/change (irritating Trinity), plus on the principal form in loading fasten duplication same "the removed ticks" a program method - about normal usage under .
Again in this branch will already hang))))
Application. SetOption "Confirm Record Changes", False ' acknowledgement of requests about change
Application. SetOption "Confirm Document Deletions", False ' acknowledgement of removal of documents
Application. SetOption "Confirm Action Queries", False ' acknowledgement of action of requests
Also there will be to you a happiness)

24

Re: Why the question on removal of records is not disconnected

Tarasios;
Thanks.

25

Re: Why the question on removal of records is not disconnected

58;

CurrentDb. Execute "delete... from... where..."

make and you will not have any messages (only the request text, instead of his name)