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

No confirm delete on first deletion from form

P: n/a
My application has a form based on a parent table with a subform based
on a child table. The relationship is Cascade Delete. The first
record displayed when the form opens has five child records. The form
allows this record to be deleted without a prompt, though SetWarnings
is set to True. When you try to delete other records, you do get a
prompt.

The problem isn't the relationship or the tables, because a test form/
subform using the same tables does prompt before deleting that first
record.

I've tried SaveAsText/LoadFromText on the form/subform to handle
corruption, but the results are the same.

1) Any suggestions on where to look in the forms for solutions?

2) How likely is it that the form(s) may still be corrupted? I've had
good results with SAT/LFT in the past. I saved as text, deleted teh
forms, then loaded from text (subform first) to the same database.

TIA

The environment is Win XP / A2003, both at SP2.

Nov 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ARC
Not sure why it wouldn't prompt, but it certainly should. You could place
code on the "Before Delete Confirm" event, such as:
dim resp as integer
resp = msgbox("Are you sure you wish to delete the curren
record?",vbYesNo+vbQuestion+vbDefaultButton2,"Dele te?")
if resp = vbNo then
cancel = -1
end if
<br********@comcast.netwrote in message
news:11**********************@v65g2000hsc.googlegr oups.com...
My application has a form based on a parent table with a subform based
on a child table. The relationship is Cascade Delete. The first
record displayed when the form opens has five child records. The form
allows this record to be deleted without a prompt, though SetWarnings
is set to True. When you try to delete other records, you do get a
prompt.

The problem isn't the relationship or the tables, because a test form/
subform using the same tables does prompt before deleting that first
record.

I've tried SaveAsText/LoadFromText on the form/subform to handle
corruption, but the results are the same.

1) Any suggestions on where to look in the forms for solutions?

2) How likely is it that the form(s) may still be corrupted? I've had
good results with SAT/LFT in the past. I saved as text, deleted teh
forms, then loaded from text (subform first) to the same database.

TIA

The environment is Win XP / A2003, both at SP2.
Nov 14 '07 #2

P: n/a
On Nov 14, 5:13 pm, "ARC" <PCES...@PCESoft.invalidwrote:
Not sure why it wouldn't prompt, but it certainly should. You could place
code on the "Before Delete Confirm" event, such as:

dim resp as integer
resp = msgbox("Are you sure you wish to delete the curren
record?",vbYesNo+vbQuestion+vbDefaultButton2,"Dele te?")
if resp = vbNo then
cancel = -1
end if

<brucedo...@comcast.netwrote in message

news:11**********************@v65g2000hsc.googlegr oups.com...
My application has a form based on a parent table with a subform based
on a child table. The relationship is Cascade Delete. The first
record displayed when the form opens has five child records. The form
allows this record to be deleted without a prompt, though SetWarnings
is set to True. When you try to delete other records, you do get a
prompt.
The problem isn't the relationship or the tables, because a test form/
subform using the same tables does prompt before deleting that first
record.
I've tried SaveAsText/LoadFromText on the form/subform to handle
corruption, but the results are the same.
1) Any suggestions on where to look in the forms for solutions?
2) How likely is it that the form(s) may still be corrupted? I've had
good results with SAT/LFT in the past. I saved as text, deleted teh
forms, then loaded from text (subform first) to the same database.
TIA
The environment is Win XP / A2003, both at SP2.
BeforeDeleteConfirm doesn't fire for this record.

Nov 14 '07 #3

P: n/a
On Nov 14, 4:26 pm, brucedo...@comcast.net wrote:
My application has a form based on a parent table with a subform based
on a child table. The relationship is Cascade Delete. The first
record displayed when the form opens has five child records. The form
allows this record to be deleted without a prompt, though SetWarnings
is set to True. When you try to delete other records, you do get a
prompt.

The problem isn't the relationship or the tables, because a test form/
subform using the same tables does prompt before deleting that first
record.

I've tried SaveAsText/LoadFromText on the form/subform to handle
corruption, but the results are the same.

1) Any suggestions on where to look in the forms for solutions?

2) How likely is it that the form(s) may still be corrupted? I've had
good results with SAT/LFT in the past. I saved as text, deleted teh
forms, then loaded from text (subform first) to the same database.

TIA

The environment is Win XP / A2003, both at SP2.
I found that when I made a copy of the database, deleted the first
record and its related records from it, then appended the same records
from the original, the problem went away. I don't know why this
worked. I'm still a little concerned about corruption. Any further
suggestions would be appreciated.
Nov 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.