Form and subform, parent and children in a transaction


HOME ยป Access

I have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: http://www.access-programmers.co.uk/...d.php?t=261029
If you have done something like that would you mind sharing the code?

Related to : Form and subform, parent and children in a transaction
form parent and children
Access
form parent and children
 
Hi.
Im new to access and VB. I would like to create 2 forms when one is the parent of the other.
I have already created the 2 forms, and I would like to set one form as the parent of the other.
The first form retrieves datas with control (text boxes, combobox) and the second form displays the result of the sql query with these data. So I would like to make the result form as the child of the first form.
Anybody can help me, its urgent.
Thanks.
Sev2004

Preferred Method - Parent Referenced by Children vs Parent Containing Children
Access
Hey guys. Im just wondering about the preferred method in the following situation.
Say I have a set of categories, with indefinite sub-category levels, for example:
Code:
Category no parent with children yes parent without children
Access
Hi,
(Im sorry for the summary but Ive not other idea)
Ive this table with a few data example
PHP Code:
How to refer to a subform within a subform from the parent form
Access
I am trying to refer to a subform within a subform from my parent form how do i do this? Also i want to refer to my parent form from my subform and the subform within the subform.
Any suggestion would help!!!!

Create duplicate sets of data for parent with children and childrens children
Access
I have the following tables in my Access database.
A < B < C < D
(The "<" represents a one to many relationship.)
A given row in table A can have up to 4 children (stages) in table B (stages 1 to 4).
The other one to many relationships do not have any limitations as far as the number of children are concerned.
All tables have AutoNumber primary keys.
When the user clicks a button in a form, I want to:
Copy all data in the current stage (current row) in table B (corresponding to a given parent row in table A), to the next stage in table B.
All data in chil
Form and subform, parent and children in a transaction
Access
I have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: http://www.access-programmers.co.uk/...d.php?t=261029
If you have done something like that would you mind sharing the code?


Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .