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.
3  2408 
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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: neoconwannabe |
last post by:
Hi,
I have an html form with a number of checkboxes that can be checked
to delete
items. I want to have a javascript alert prompt box to pop up to
confirm the delete.
I am building my site with...
|
by: Squirrel |
last post by:
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...
|
by: TJS |
last post by:
javascript "confirm" fires after deletion instead of before deletion.
how do I get this to stop the processing ?
code
==================
Sub ShowAlert(ByVal s As string)...
|
by: R.Welz |
last post by:
Hello.
I want to discuss a problem I have with my database design becourse I
feel I cannot decide wheather I am on the right way of doing things.
First of all, I am writing a literature and...
|
by: morz |
last post by:
i just search for a while in c++ groups but cannot find good answer.
i have code like this:
int **ptr;
ptr = new char *;
ptr = new int(5);
ptr = new int(16);
|
by: rn5a |
last post by:
The .NET 2.0 documentation states the following:
When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove...
|
by: mamun |
last post by:
Hi All,
I have the following situation and am looking for answer in C#.
I have a datagrid and putting checkbox next to each record. In the
header I have a Delete button.
I want users to...
|
by: RN1 |
last post by:
I have a DataList which displays the first & last name of users as
links (LinkButtons). When the links are clicked, 2 textboxes appear -
one with the first name & the other with the last name - for...
|
by: matthewslyman |
last post by:
I have an unusual design and some very unusual issues with my code... I have forced Access to cooperate on everything except one issue - record deletion.
My form design involves a recursively...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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 project—planning, coding, testing,...
| |
