473,563 Members | 2,697 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Continuous forms with subforms

Hi NG

I need some help with a problem on my forms.

If I have 2 related tables, for instance companies and employees, and want
to display all companies on a continuous form with their employees on a sub
form as another continuous form, as shown below

Northwind

Carl Jensen

Dave Smith

Eastwind

Paul Allen

Susan Vincent

Brit Anderson

Southwind

Peter Simson

But as the number of employees varies on the companies, I would like the
subform to have the proper size to contain the number of employees on each
company.

So I got 2 problems, first, is there a way to simulate the property CanGrow
in form view? Maybe individually resizing the subform control on each
continuous form?

And secondly, resize each continuous form to fit the size of the subform.

Hope this makes sense, I will appreciate any input

And please bear with me for any incorrect language J

Best regards

Stef
Nov 6 '08 #1
8 11636
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

"Steffen Beck" <sb@nospamsrd.d kwrote in message
news:49******** *************** @dtext01.news.t ele.dk...
Hi NG

I need some help with a problem on my forms.

If I have 2 related tables, for instance companies and employees, and want
to display all companies on a continuous form with their employees on a
sub form as another continuous form, as shown below

Northwind

Carl Jensen

Dave Smith

Eastwind

Paul Allen

Susan Vincent

Brit Anderson

Southwind

Peter Simson

But as the number of employees varies on the companies, I would like the
subform to have the proper size to contain the number of employees on each
company.

So I got 2 problems, first, is there a way to simulate the property
CanGrow in form view? Maybe individually resizing the subform control on
each continuous form?

And secondly, resize each continuous form to fit the size of the subform.

Hope this makes sense, I will appreciate any input

And please bear with me for any incorrect language J

Best regards

Stef


Nov 7 '08 #2

"bcap" <bc**@nospam.no whereskrev i en meddelelse
news:49******** *************** @news.zen.co.uk ...
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as report

Best regards
Stef
Nov 7 '08 #3

"Steffen Beck" <sb@nospamsrd.d kwrote in message
news:49******** *************** @dtext01.news.t ele.dk...
>
"bcap" <bc**@nospam.no whereskrev i en meddelelse
news:49******** *************** @news.zen.co.uk ...
>You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.


Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as
report

Best regards
Stef

As I said, you could use a datasheet/sub-datasheet set-up. Or open a report
in preview...
Nov 7 '08 #4
On Nov 7, 5:43*am, "Steffen Beck" <s...@nospamsrd .dkwrote:
"bcap" <b...@nospam.no whereskrev i en meddelelsenews: 49************* **********@news .zen.co.uk...
You can't have subforms on a continuous form, period.
If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks

But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, *almost just displayed as report

Best regards
Stef
For the past ten years or so I have rarely used subforms. Instead I
create and use my own "child" forms.

I open and place my own child form on my main form's opening, often
just to the right of my main form, which I place at (0,0).
I update my child form's recordsource and requery it in the OnCurrent
Event Code of my main form.
I close my child form on my main form's closing.

There are many reasons. One is the topic of this discussion.

I discuss this a bit more fully in
http://groups.google.com/group/comp....bc13deac192275

Nov 7 '08 #5

"Steffen Beck" <sb@nospamsrd.d kskrev i en meddelelse
news:49******** *************** @dtext01.news.t ele.dk...
>
"bcap" <bc**@nospam.no whereskrev i en meddelelse
news:49******** *************** @news.zen.co.uk ...
>You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.
Thanks for your suggestions, I will take a closer look, but it seems like
there is no way I can get exactly what I want

Best regards

Stef
Nov 7 '08 #6

"Steffen Beck" <sb@nospamsrd.d kwrote in message
news:49******** *************** @dtext01.news.t ele.dk...
>
"bcap" <bc**@nospam.no whereskrev i en meddelelse
news:49******** *************** @news.zen.co.uk ...
You can't have subforms on a continuous form, period.

If you can tolerate the limitations of the view, you could use a form in
datasheet view; the subform would then become a sub-datasheet.

Wow

I've been working with Access since version 1.1, and it's the first time I
realized this limitation
You never stop learning something new :-) Thanks
But, isn't there some sort of work around? Any ideas?
I don't want any funcionality on the form, almost just displayed as
report
>
Best regards
Stef

Place the fields in the main form on a subform then create a unbound main
form to hold both subforms. When you select new records on the primary
subfrom, update the recordsource on the 2nd subfrom. Depending on the
layout, you may need to place the subforms in different section of the main
form.
Nov 7 '08 #7
On Nov 7, 6:58*pm, "bcap" <b...@nospam.no wherewrote:
You can't have subforms on a continuous form, period.
You can have subforms in the footer of a continuous form.
Nov 8 '08 #8
Steffen Beck wrote:
Thanks for your suggestions, I will take a closer look, but it seems like
there is no way I can get exactly what I want
There is almost always a way to do something; you just have to weight
the cost/benefit.

You could create your own unbound form with as many controls as you like
but you'll have to handle the coding to make it all work.

--
'--------------------------
' John Mishefske
' UtterAccess Editor
' Microsoft MVP 2007, 2008
'--------------------------
Nov 9 '08 #9

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

Similar topics

5
2190
by: Armando | last post by:
I recently saw the tail end of a "Continuous forms" discussion, but not enough was available to see if this will be a PITA repeat question. Sorry if it is. On a form with its Default View set to Continuous Forms, I need to catch the event when the repeating section iterates for each record in the underlying table. I have buttons on...
6
2596
by: Rose | last post by:
I have set my form's default view property to continuous forms and have added a field for the table columns I wish to view. What do I need to do to allow more than one record to show at the same time... like in a list?
3
6652
by: Richard Hollenbeck | last post by:
I have the following query in my form's code: Private Function Get_Data(fieldNum As Integer) Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset strSQL = "SELECT & "", "" & AS Student, activities.activityDescription, studentScores.score FROM groups INNER JOIN (students INNER JOIN (activities INNER JOIN studentScores ON
9
6747
by: Edwinah63 | last post by:
Hi everyone, Please let there be someone out there who can help. I have two BOUND combo boxes on a continuous form, the second being dependent on the first. I have no problem getting the second combo to change depending on what values the user selects in the first box, it's just that every time the user changes the first combobox, the...
1
10890
by: blueheelers | last post by:
I have been researching for several hours on the best way to display images in continous forms in Access 2003. For example, I want to display employee name, email, phone, and picture for each record in the recordset. I can have the pictures converted to any usable format, use OLE or linking, whatever needs to be done. So far, the 3...
3
7474
by: Steve Antrobus | last post by:
Hello all, I've seen many discussions regarding continuous forms in Access and how to highlight individual rows and they all seem to suggest conditional formatting as the only way. This is fine, but I am struggling to understand if it will solve my problem. I have two subforms on a main form that contain many rows of data. What I want to...
1
3233
by: rpboll | last post by:
I am looking for the best way to accomplish the following continuous forms concept. There are Five Groups: A, B, C, D, E Each group has eight Members: a, b, c, d, e, f, g, h Each Member is seen as a row in a continuous form like:
7
3301
by: Dave | last post by:
Hello All, These one may be a bit tricky, and what I'd like to do may not even be possible. I would love to hear any ideas you guys have for solving this. Here is the situation: I have a form that displays the high-level data for a set of records in continuous forms mode. I have a simple command button that will open another form with...
0
1149
by: BillE | last post by:
I'm wondering how others have addressed UI requirements for Access-style continuous forms and sub-forms in a windows forms application (besides third-party products). Thanks Bill
5
4055
by: grahamib | last post by:
I have a form running in access 2003. The forms property is set to continuous forms so that all records from an underlying query can be diaplayed. On the form are 12 sets of fields from .......to..... In the header of the form is a single unbound field that is populated with a date picker and a command button. The idea is that when a date is...
0
7659
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8103
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...
0
7945
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6244
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5481
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...
0
3634
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...
0
3618
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2079
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
0
916
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...

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.