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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#3
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|