No warning when deleting records

[Phil Stanton]

My Ak2 databas has been running successfully for many years althogh it gets
upgraded regularly.

I now find on this, and other dbs, when I delete a record I no longer get
the message "You are about to delete 1 record.....".
What has gone wrong / got changed?

Thanks Phil

[Salad]

Re: No warning when deleting records

Phil Stanton wrote:

My Ak2 databas has been running successfully for many years althogh it gets
upgraded regularly.
>
I now find on this, and other dbs, when I delete a record I no longer get
the message "You are about to delete 1 record.....".
What has gone wrong / got changed?
>
Thanks Phil
>
>

Did you do something like
Docmd.SetWarnin gs = False
in your code and not reset it back to True?

[Phil Stanton]

Re: No warning when deleting records

Hi Salad,
I wondered that and there are a couple of places where that could happen,
but as far as I know, I have never used that bit of code

Anway before trying the delete on a table, I typed DoCmd.SetWarnin gs True in
the immediate window. Still have the problem

Thanks,
Phil
"Salad" <oil@vinegar.co mwrote in message
news:Ca-dnb8ml9K8BU_VnZ 2dnUVZ_qjinZ2d@ earthlink.com.. .

Phil Stanton wrote:
>

>My Ak2 databas has been running successfully for many years althogh it
>gets upgraded regularly.
>>
>I now find on this, and other dbs, when I delete a record I no longer get
>the message "You are about to delete 1 record.....".
>What has gone wrong / got changed?
>>
>Thanks Phil

Did you do something like
Docmd.SetWarnin gs = False
in your code and not reset it back to True?
>

[Salad]

Re: No warning when deleting records

Phil Stanton wrote:

Hi Salad,
I wondered that and there are a couple of places where that could happen,
but as far as I know, I have never used that bit of code
>
Anway before trying the delete on a table, I typed DoCmd.SetWarnin gs True in
the immediate window. Still have the problem
>
Thanks,
Phil
"Salad" <oil@vinegar.co mwrote in message
news:Ca-dnb8ml9K8BU_VnZ 2dnUVZ_qjinZ2d@ earthlink.com.. .
>

>>Phil Stanton wrote:
>>
>>

>>>My Ak2 databas has been running successfully for many years althogh it
>>>gets upgraded regularly.
>>>
>>>I now find on this, and other dbs, when I delete a record I no longer get
>>>the message "You are about to delete 1 record.....".
>>>What has gone wrong / got changed?
>>>
>>>Thanks Phil

>>
>>Did you do something like
>>Docmd.SetWarn ings = False
>>in your code and not reset it back to True?
>>

>

Let's try a test. Create a dummy table. Call it Junk or whatever.
Create 1 field and save the table and enter 4 or 5 records. Now CTRL+A
to select the records and press the Delete key. Do you get the
confirmation message? If so, then I'd add a couple more junk records
and create a temp form on that table and try to delete from the form.
If you don't get the message...time for Allen Browne.

[Phil Stanton]

Re: No warning when deleting records

Thanks for coming back, Salad

Created a new DB and Table
Deleted records as suggested and still no warning message.
Lets hope Allen spots this message. In the meantime I think I will remove
Access and reload it in case it has got corrupted..

Why is it I always seem to get unsolvable problems. For example on my Office
machine, running a copy of the same Db as on this machine, FE & BE
situation, I can see all the relationships as normal in the BE Db but
therelationship s of the linked tablesdon't show in the FE.. But at least the
warning message appears on that machine.

I suppose the more Dbs I use, the more problems appear

Thanks

Phil

"Salad" <oil@vinegar.co mwrote in message
news:cPqdnRzscY qcS0_VnZ2dnUVZ_ oTinZ2d@earthli nk.com...

Phil Stanton wrote:
>

>Hi Salad,
>I wondered that and there are a couple of places where that could happen,
>but as far as I know, I have never used that bit of code
>>
>Anway before trying the delete on a table, I typed DoCmd.SetWarnin gs True
>in the immediate window. Still have the problem
>>
>Thanks,
>Phil
>"Salad" <oil@vinegar.co mwrote in message
>news:Ca-dnb8ml9K8BU_VnZ 2dnUVZ_qjinZ2d@ earthlink.com.. .
>>

>>>Phil Stanton wrote:
>>>
>>>
>>>>My Ak2 databas has been running successfully for many years althogh it
>>>>gets upgraded regularly.
>>>>
>>>>I now find on this, and other dbs, when I delete a record I no longer
>>>>get the message "You are about to delete 1 record.....".
>>>>What has gone wrong / got changed?
>>>>
>>>>Thanks Phil
>>>
>>>Did you do something like
>>>Docmd.SetWar nings = False
>>>in your code and not reset it back to True?
>>>

>>

>
Let's try a test. Create a dummy table. Call it Junk or whatever. Create
1 field and save the table and enter 4 or 5 records. Now CTRL+A to select
the records and press the Delete key. Do you get the confirmation
message? If so, then I'd add a couple more junk records and create a temp
form on that table and try to delete from the form. If you don't get the
message...time for Allen Browne.
>
>

[AccessVandal via AccessMonster.com]

Re: No warning when deleting records

Go to Tools - Options - Edit/Find Tab - Confirm - check Record changes,
document deletions, Action queries.


Phil Stanton wrote:

>Thanks for coming back, Salad
>
>Created a new DB and Table
>Deleted records as suggested and still no warning message.
>Lets hope Allen spots this message. In the meantime I think I will remove
>Access and reload it in case it has got corrupted..
>
>Why is it I always seem to get unsolvable problems. For example on my Office
>machine, running a copy of the same Db as on this machine, FE & BE
>situation, I can see all the relationships as normal in the BE Db but
>therelationshi ps of the linked tablesdon't show in the FE.. But at least the
>warning message appears on that machine.
>
>I suppose the more Dbs I use, the more problems appear
>
>Thanks
>
>Phil
>

>>Hi Salad,
>>I wondered that and there are a couple of places where that could happen,

>[quoted text clipped - 25 lines]

>form on that table and try to delete from the form. If you don't get the
>message...ti me for Allen Browne.

--
Please Rate the posting if helps you

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200809/1

[Phil Stanton]

Re: No warning when deleting records

Brilliant. So simple. I should have kicked myself for not spotting it,
though how it got changed, I don't know

Thanks a lot

Phil


"AccessVand al via AccessMonster.c om" <u18947@uwewrot e in message
news:8a6b19c4f1 cf8@uwe...

Go to Tools - Options - Edit/Find Tab - Confirm - check Record changes,
document deletions, Action queries.
>
>
Phil Stanton wrote:

>>Thanks for coming back, Salad
>>
>>Created a new DB and Table
>>Deleted records as suggested and still no warning message.
>>Lets hope Allen spots this message. In the meantime I think I will remove
>>Access and reload it in case it has got corrupted..
>>
>>Why is it I always seem to get unsolvable problems. For example on my
>>Office
>>machine, running a copy of the same Db as on this machine, FE & BE
>>situation, I can see all the relationships as normal in the BE Db but
>>therelationsh ips of the linked tablesdon't show in the FE.. But at least
>>the
>>warning message appears on that machine.
>>
>>I suppose the more Dbs I use, the more problems appear
>>
>>Thanks
>>
>>Phil
>>

>>>Hi Salad,
>>>I wondered that and there are a couple of places where that could
>>>happen,

>>[quoted text clipped - 25 lines]

>>form on that table and try to delete from the form. If you don't get the
>>message...tim e for Allen Browne.

>
--
Please Rate the posting if helps you
>
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200809/1

>