473,699 Members | 2,424 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Unbound Nested Subform Simulating Continuous Form

Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag property
for each option button, check box or text field has the value of the key
field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob
Jan 2 '06 #1
20 10817
Why use an unbound form, when you want to save the values into a table?

Why go to the trouble of trying to simlate an unbound continuous form when a
bound one is handed to you on a platter and requires next to effort to
develop?

The "best way" will be to use a bound continuous subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert" <ro*******@bigp ond.com> wrote in message
news:vj******** ***********@new s-server.bigpond. net.au...
Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag property
for each option button, check box or text field has the value of the key
field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob

Jan 2 '06 #2
Allen,

Started with a bound subform but switched to using an unbound subform for
better error control, more control over saving records (single button on
parent subform) and for more user friendly data capture (option buttons &
check boxes rather than combo boxes on continuous subform).

Parent subform has "Project" (one) details and nested subform has (many)
"Products" that can be selected via option buttons or check boxes and layout
of the form is not on a one record (Product) per row basis.

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:43******** **************@ per-qv1-newsreader-01.iinet.net.au ...
Why use an unbound form, when you want to save the values into a table?

Why go to the trouble of trying to simlate an unbound continuous form when
a bound one is handed to you on a platter and requires next to effort to
develop?

The "best way" will be to use a bound continuous subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert" <ro*******@bigp ond.com> wrote in message
news:vj******** ***********@new s-server.bigpond. net.au...
Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for
the record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag
property for each option button, check box or text field has the value of
the key field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob


Jan 2 '06 #3
What's your question?
You want to save some values?
And you don't want to do it the Access way?

You, of course, are way better than those stiffs who designed Access on
the one hand, but on the other hand, you don't know how to solve this
simple problem? Fabulous! Congratulations !

So save them. Use an INSERT INTO query if they're new. Use an UPDATE
query if they're not.
What's the problem?

Jan 2 '06 #4
If you do come up with a better design that the one Access gives you for
free, please let us know.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert" <ro*******@bigp ond.com> wrote in message
news:1S******** ************@ne ws-server.bigpond. net.au...
Allen,

Started with a bound subform but switched to using an unbound subform for
better error control, more control over saving records (single button on
parent subform) and for more user friendly data capture (option buttons &
check boxes rather than combo boxes on continuous subform).

Parent subform has "Project" (one) details and nested subform has (many)
"Products" that can be selected via option buttons or check boxes and
layout of the form is not on a one record (Product) per row basis.

"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:43******** **************@ per-qv1-newsreader-01.iinet.net.au ...
Why use an unbound form, when you want to save the values into a table?

Why go to the trouble of trying to simlate an unbound continuous form
when a bound one is handed to you on a platter and requires next to
effort to develop?

The "best way" will be to use a bound continuous subform.
"Robert" <ro*******@bigp ond.com> wrote in message
news:vj******** ***********@new s-server.bigpond. net.au...
Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for
the record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag
property for each option button, check box or text field has the value
of the key field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Jan 2 '06 #5
Lyle,

Sorry new at access, am using a currentdb.execu te "insert into...statemen t
for new records being added. Have product number (unique identifier) in the
tag property of each control which allows grouping controls into records.
Just not sure on how to read through all the controls of the nested subform
and group them into records using the tag property including for each record
specifyig which control is to be saved to which feld before using the insert
into query.

"Lyle Fairfield" <ly***********@ aim.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .
What's your question?
You want to save some values?
And you don't want to do it the Access way?

You, of course, are way better than those stiffs who designed Access on
the one hand, but on the other hand, you don't know how to solve this
simple problem? Fabulous! Congratulations !

So save them. Use an INSERT INTO query if they're new. Use an UPDATE
query if they're not.
What's the problem?

Jan 2 '06 #6
Probably how to read through would depend on how you created them in
the first place. You say your nested subform simulates a continuous
form? How? Is the initial data (that is displayed) part of a recordset?
Where does it come from? How many rows are on this simulated continous
form? How is this number decided? What happens when the user wants to
create a new row? What happens when the user wants to delete a row? If
you use recordset is it a DAO or ADO recordset? etc. etc etc.

Jan 2 '06 #7
Lyle,

Nested subform appears to user as as a single form containing a number of
option buttons (4), a number of text boxes (12) and check boxes (11).

Each pair of the option buttons (not option group) represents an either/or
product choice

Each check box represents a product choice.

The text boxes are some additional fields used for additional info that
relate to 6 of the product choices (option buttons/checkboxes)

Subform is being used for initial data entry (same methodology will be used
to edit existing records but via a separate view/edit form). During initial
data entry user can include/exclude products by selecting/unselecting the
optionbuttons/checkboxes.

User enters details for a single project on the parent subform and selects
one or more products (multiple) on the nested subform.

Am using ADO to add record on the ubound parent subform and using
CurrentDB.Execu te "Insert Into... to add each product record in the unbound
nested subform to the related (many) table using ProjectNr and ProductNr as
key fields. The Tag property for each option button/check box has the
ProductNr in it. The Textboxes also have the ProuctNr in the Tag property to
allow these to be associated with the relevant Product
(Optionbutton/Checkbox).

Have been trying to write code to use the TAG info and convert the info
loaded in the nested product subform by using the Insert Into query in a
loop to add the (multiple) product records to the underlying
tblProjectProdu cts. Not sure if using an array is necessary?
"Lyle Fairfield" <ly***********@ aim.com> wrote in message
news:11******** *************@g 49g2000cwa.goog legroups.com...
Probably how to read through would depend on how you created them in
the first place. You say your nested subform simulates a continuous
form? How? Is the initial data (that is displayed) part of a recordset?
Where does it come from? How many rows are on this simulated continous
form? How is this number decided? What happens when the user wants to
create a new row? What happens when the user wants to delete a row? If
you use recordset is it a DAO or ADO recordset? etc. etc etc.

Jan 2 '06 #8
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in
news:43******** **************@ per-qv1-newsreader-01.iinet.net.au :
If you do come up with a better design that the one Access gives
you for free, please let us know.


I don't believe in using editable continuous forms, except in very
specific situations.

If I want to edit data presented in a continuous form, I use a
detail form that can be bound or unbound. This makes the continuous
form like a very elaborate listbox with lots of extra features, and
with the detail form populated in the OnCurrent event of the list
form.

Going unbound gives control over certain things, but also takes away
any number of extremely useful features (such as the .Dirty
property). I've only implemented this kind of thing very, very
seldom.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 2 '06 #9
Bri

Robert wrote:
Allen,

Started with a bound subform but switched to using an unbound subform for
better error control, more control over saving records (single button on
parent subform) and for more user friendly data capture (option buttons &
check boxes rather than combo boxes on continuous subform).

Parent subform has "Project" (one) details and nested subform has (many)
"Products" that can be selected via option buttons or check boxes and layout
of the form is not on a one record (Product) per row basis.


I understand your issue and I have a different approach to solving it. I
create a temp table (in a temp database - linked) that I then use in the
bound subform. The Save button then does an Update query that moves the
data from the temp table to the permanent table. This gives me the
flexablility that a bound form gives with the ability to save all the
changes or none of the changes (like a transaction commit or rollback
but in a form rather than in code).

--
Bri

Jan 2 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3777
by: Dos Lil | last post by:
I have a unbound field in the subform(for calculating the datediff) which has the control property ==DateDiff("n",,). I have another unbound field in the main form which is for displaying the datediff from the subform.I have set the controls source = .Form! FRM- TimeSheet Subform is the name of the subform and TXTTtalHoursworked is the name of the unbound field in the subform.
2
3675
by: Simon P | last post by:
Hello group, I'm in desperate need of help. Here goes : I have the following tables : CONTACTS (ContactID, FirstName, LastName, Company, etc.), SHOWS (ShowID, ShowDescription) and SHOWDETAILS (links the previous tables together so not to have a many-to-many relationship -- has the ContactID and ShowID fields). I have a main form with a couple of listboxes which are used for querying the CONTACTS table. The results populate bound fields...
4
7014
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the user enters the last qualifying field on the main form. In one case this works fine, the subform shows the data the user wants to update -- which means showing all the data put in previously (ie showing this via the requery and the continuous...
1
2935
by: gavo | last post by:
Hello everyone! Using A2K i have a form(a) with a subform(b) and within the subform there is a continuous subform(c). in the subform (b) there is a command button used to call a public function
4
2714
by: Robert | last post by:
Have main form with an unbound subform1 which is used for data entry. Subform1 has a nested continuous unbound subform (subform2) which is used to enter multiple records related to the record being entered in subform1. Am using DAO method to save the records entered into subform1 & 2 into the underlying tables (table1 & table2). Record being entered in subform1 only gets its unique identifier when saved to underlying table (primary key...
3
2752
by: google | last post by:
I'm developing an application for use within my company in Access 2003. I'm new to '03, the application I did for my former employer was in '97. The two applications have similar functionality (we're sales offices, and I'm doing things such as associate directories, commission calculations, order tracking, etc.). 2003 seems to have a few extra features, but I seem to continually run in to oddities that seem like they SHOULD work, but...
8
8323
by: Robert | last post by:
I have a form (Worksheet) that works fine by itself. I have now created a seperate form (MainForm) that has a command button in the header and an unbound subform (FormFrame) in the Detail section. when the user clicks the command button, Worksheet is loaded into the subform control. At this point, some of the functions do not work. The user is prompted to enter a Parameter Value. Why wouldn't that form (Worksheet) work the same as a sub...
6
4869
by: Greg Strong | last post by:
Hello All, Is is possible to use an ADO recordset to populate an unbound continuous Subform? I've done some Googling without much luck, so this maybe impossible, but let me try to explain why. I've been exploring using Access as a front end to both SQL MSDE and Oracle XE. I'm in the process of writing a class to handle the basics of the ADO connection and recordsets. The basic relationships are as follows:
11
5176
by: jwessner | last post by:
I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command button will open a new form (Form2). Form2 has two subforms. Both are embedded in the main form. (Subform2 is NOT embedded in subform1.) Subform1 displays records as a continuous form based on the Primary ID of the main form and lists the...
0
8623
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9184
Oralloy
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9048
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6539
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5878
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4386
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4635
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3064
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2014
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.