A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subform help for a case management database



 
 
Thread Tools Display Modes
  #1  
Old March 3rd, 2010, 05:51 AM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default Subform help for a case management database

Hi

I have a case management database where there is one main form and a subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.





  #2  
Old March 3rd, 2010, 07:04 PM posted to microsoft.public.access.gettingstarted
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Subform help for a case management database

Hello,

It sounds like your underlying problem is tables that are not correctly
designed. At least you should have the design reviewed. You can post your
tables here or if you would rather work with someone off-line, I can help
you. I provide help with Access, Excel and Word applications for a small
fee. My fee to look at the design of your tables would be very modest. Let
me look at your tables and then we can go from there.

Steve



"forest8" wrote in message
...
Hi

I have a case management database where there is one main form and a
subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected
for
Student01 (aka John Smith), when I navigate through the subform, only
John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the
tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within
the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This
is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.







  #3  
Old March 3rd, 2010, 07:17 PM posted to microsoft.public.access.gettingstarted
John... Visio MVP
external usenet poster
 
Posts: 900
Default Subform help for a case management database

"Steve" wrote in message
...
You can post your tables here or if you would rather work with some loser
off-line, I can help you. I provide help with Access, Excel and Word
applications for a small fee. My fee to look at the design of your tables
would be very modest. Let me look at your tables and then we can go from
there.

Steve



Stevie, you are such a loser. You have no idea about ethics or software
design.



Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP

  #4  
Old March 3rd, 2010, 08:17 PM posted to microsoft.public.access.gettingstarted
Stop$teve
external usenet poster
 
Posts: 76
Default Subform help for a case management database


"Steve" schreef in bericht ...
Hello,

It sounds like your underlying problem is tables that are not correctly designed. At least you should have the design reviewed.
You can post your tables here or if you would rather work with someone off-line, I can help you. I provide help with Access, Excel
and Word applications for a small fee. My fee to look at the design of your tables would be very modest. Let me look at your
tables and then we can go from there.


--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


  #5  
Old March 4th, 2010, 05:51 AM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default Subform help for a case management database

Hi.

So is there an answer for me?

Thanks

"Stop$teve" wrote:


"Steve" schreef in bericht ...
Hello,

It sounds like your underlying problem is tables that are not correctly designed. At least you should have the design reviewed.
You can post your tables here or if you would rather work with someone off-line, I can help you. I provide help with Access, Excel
and Word applications for a small fee. My fee to look at the design of your tables would be very modest. Let me look at your
tables and then we can go from there.


--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


.

  #6  
Old March 4th, 2010, 06:32 AM posted to microsoft.public.access.gettingstarted
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Subform help for a case management database

forest8,

After reading and REreading your post I am not sure what the real
question(s) is(are). However, from what I can tell we're going to need some
table information and relationship information.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" wrote in message
...
Hi

I have a case management database where there is one main form and a
subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.






  #7  
Old March 4th, 2010, 07:15 AM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default Subform help for a case management database

Hello Gina

I will repost this question with more details.

Thank you.



"Gina Whipp" wrote:

forest8,

After reading and REreading your post I am not sure what the real
question(s) is(are). However, from what I can tell we're going to need some
table information and relationship information.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" wrote in message
...
Hi

I have a case management database where there is one main form and a
subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.






.

  #8  
Old March 4th, 2010, 07:37 AM posted to microsoft.public.access.gettingstarted
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Subform help for a case management database

Thank you!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" wrote in message
...
Hello Gina

I will repost this question with more details.

Thank you.



"Gina Whipp" wrote:

forest8,

After reading and REreading your post I am not sure what the real
question(s) is(are). However, from what I can tell we're going to need
some
table information and relationship information.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" wrote in message
...
Hi

I have a case management database where there is one main form and a
subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected
for
Student01 (aka John Smith), when I navigate through the subform, only
John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the
tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within
the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This
is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.






.



  #9  
Old March 4th, 2010, 02:20 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Subform help for a case management database

I can think of several things to try. Some of these are speculation on my part.

You can try manually setting the values for Link Child Fields and Link Master
Fields. The values don't have to be a field.

Assumptions:
== each of the sub-subforms has a StudentID field
== there is a control on the Master form that contains the current StudentID
field

Link Child Fields: [StudentID]
Master Link Fields: [Forms]![Name of Master Form]![Name of StudentID CONTROL]

Next thing to try. Make sure each subform has a record source that has the
studentid and the Master form and subform are linked on the StudentID fields.

Now try setting up the links between the subform and the sub-subform based on
the studentID fields in the subform and sub-subform. Again you can refer to
a control on the subform in the Master Link Fields property. I have done this
and I only had to use [Name of StudentID Control] as the reference.

IF neither of these work, I would try setting up the underlying queries of the
sub-subforms to reference a control on the Master form as criteria. And then
use REQUERY of each of the subforms whenever the master form selection changed.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

forest8 wrote:
Hi

I have a case management database where there is one main form and a subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.