|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Can't find Master Link and Child Link Attributessuccessfully linked one of those subforms with the master by doing something with the mouse that got me to a property list where the "data" tabpage included "master link" and "child link" (I THINK it was 'master'... might have been 'parent'.) My problem is that I don't know exactly what I did (right mouse/properties somewhere - just don't know where). Now I can't link the second subform to the master because I can't get at that particular property list. I know I'm not imagining that I did it succesfully once. The first subform is in synch with the records on the master form. The second is not. Someone suggested that I can see all of the controls in the dropdown in the menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not yelling... underlining). My understanding is that a subform actually lives inside a subform control. Whether or not I'm right about the subform control thing.... Can someone tell me how to get at that property list that contains "master link" and "child link"? Might I have a corrupt database? I've "compact & repair"ed a couple of times. In form design view, doulble click on the subform, the subforms properties
should then pop up. Select the data tab. That should show you the master and child fields. HTH Rico Show quote "Laurel" wrote: > I have a form with 4 tabpages. I have subforms on two of those tabpages. I > successfully linked one of those subforms with the master by doing something > with the mouse that got me to a property list where the "data" tabpage > included "master link" and "child link" (I THINK it was 'master'... might > have been 'parent'.) > > My problem is that I don't know exactly what I did (right mouse/properties > somewhere - just don't know where). Now I can't link the second subform to > the master because I can't get at that particular property list. > > I know I'm not imagining that I did it succesfully once. The first subform > is in synch with the records on the master form. The second is not. > > Someone suggested that I can see all of the controls in the dropdown in the > menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not > yelling... underlining). My understanding is that a subform actually lives > inside a subform control. > > Whether or not I'm right about the subform control thing.... Can someone > tell me how to get at that property list that contains "master link" and > "child link"? Might I have a corrupt database? I've "compact & repair"ed > a couple of times. > > > rico wrote:
> In form design view, doulble click on the subform, the subforms That is incorrect. The MasterLink and ChildLink properties are NOT> properties should then pop up. Select the data tab. That should show > you the master and child fields. properties of the form shown within the subform control. They are properties of the subform control itself. If you "single" click on the subform control then those properties should be shown on the {data} page of the property sheet. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com See reply to Malcom. Single click just selects the object. Isn't that what
it always does? I've also tried "single click/right mouse" No help there. Show quote "Rick Brandt" <rickbran***@hotmail.com> wrote in message news:381619F5ektvbU1@individual.net... > rico wrote: > > In form design view, doulble click on the subform, the subforms > > properties should then pop up. Select the data tab. That should show > > you the master and child fields. > > That is incorrect. The MasterLink and ChildLink properties are NOT > properties of the form shown within the subform control. They are > properties of the subform control itself. > > If you "single" click on the subform control then those properties should be > shown on the {data} page of the property sheet. > > -- > I don't check the Email account attached > to this message. Send instead to... > RBrandt at Hunter dot com > > > Laurel wrote:
> See reply to Malcom. Single click just selects the object. Isn't Yes and when you single click what do you see in the property sheet?> that what it always does? I've also tried "single click/right mouse" > No help there. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com "Rick Brandt" <rickbran***@hotmail.com> wrote in message If I went to the property sheet the way I usually do, rightnews:3819e2F5f56geU1@individual.net... > Laurel wrote: > > See reply to Malcom. Single click just selects the object. Isn't > > that what it always does? I've also tried "single click/right mouse" > > No help there. > > Yes and when you single click what do you see in the property sheet? mouse/properties, I see the data properties of he underlying form BUT!!!! If I use the View menu at the top and choose properties as suggested by Malcom, above, I get what. YAY!!!! I guess what I did to set the first one will forever be a mystery. Show quote > > -- > I don't check the Email account attached > to this message. Send instead to... > RBrandt at Hunter dot com > > When I do that I get the same thing I got when I right-moused on that area.
That is, I get the attributes of the underlying form. The Data tab contains things like "RecordSource", "Filter".....down to "Record Locks." No "Link" attributes. Show quote "rico" <r***@discussions.microsoft.com> wrote in message tabpages. Inews:42575E82-8BDD-4DBF-A3CD-8E14EF61B752@microsoft.com... > In form design view, doulble click on the subform, the subforms properties > should then pop up. Select the data tab. That should show you the master and > child fields. > > HTH > > Rico > > > "Laurel" wrote: > > > I have a form with 4 tabpages. I have subforms on two of those Show quote > > successfully linked one of those subforms with the master by doing something > > with the mouse that got me to a property list where the "data" tabpage > > included "master link" and "child link" (I THINK it was 'master'... might > > have been 'parent'.) > > > > My problem is that I don't know exactly what I did (right mouse/properties > > somewhere - just don't know where). Now I can't link the second subform to > > the master because I can't get at that particular property list. > > > > I know I'm not imagining that I did it succesfully once. The first subform > > is in synch with the records on the master form. The second is not. > > > > Someone suggested that I can see all of the controls in the dropdown in the > > menu. I see tabpages and subforms, but I don't see subforms CONTROLS (not > > yelling... underlining). My understanding is that a subform actually lives > > inside a subform control. > > > > Whether or not I'm right about the subform control thing.... Can someone > > tell me how to get at that property list that contains "master link" and > > "child link"? Might I have a corrupt database? I've "compact & repair"ed > > a couple of times. > > > > > > single click.
the 1st time you click, you get the subform object the 2nd time you click, you get the form which is the 'sourceobject' of the subform. got it? Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:%23OCOt2PGFHA.2976@TK2MSFTNGP09.phx.gbl... > When I do that I get the same thing I got when I right-moused on that area. > That is, I get the attributes of the underlying form. The Data tab contains > things like "RecordSource", "Filter".....down to "Record Locks." No "Link" > attributes. > > "rico" <r***@discussions.microsoft.com> wrote in message > news:42575E82-8BDD-4DBF-A3CD-8E14EF61B752@microsoft.com... > > In form design view, doulble click on the subform, the subforms properties > > should then pop up. Select the data tab. That should show you the master > and > > child fields. > > > > HTH > > > > Rico > > > > > > "Laurel" wrote: > > > > > I have a form with 4 tabpages. I have subforms on two of those > tabpages. I > > > successfully linked one of those subforms with the master by doing > something > > > with the mouse that got me to a property list where the "data" tabpage > > > included "master link" and "child link" (I THINK it was 'master'... > might > > > have been 'parent'.) > > > > > > My problem is that I don't know exactly what I did (right > mouse/properties > > > somewhere - just don't know where). Now I can't link the second subform > to > > > the master because I can't get at that particular property list. > > > > > > I know I'm not imagining that I did it succesfully once. The first > subform > > > is in synch with the records on the master form. The second is not. > > > > > > Someone suggested that I can see all of the controls in the dropdown in > the > > > menu. I see tabpages and subforms, but I don't see subforms CONTROLS > (not > > > yelling... underlining). My understanding is that a subform actually > lives > > > inside a subform control. > > > > > > Whether or not I'm right about the subform control thing.... Can someone > > > tell me how to get at that property list that contains "master link" and > > > "child link"? Might I have a corrupt database? I've "compact & > repair"ed > > > a couple of times. > > > > > > > > > > > A single click just seems to select the subform (put 8 tiny squares on
corners and sides). This is what I would expect it to do. When I click after it is selected, it unselects (again, what I would expect). So, no, don't got it yet. I'm running Access 2000. Do you think there might be a bug involved here somewhere? Show quote "Malcolm Cook" <m**@stowers-institute.org> wrote in message news:%23SWFw5PGFHA.2588@TK2MSFTNGP09.phx.gbl... > single click. > > the 1st time you click, you get the subform object > > the 2nd time you click, you get the form which is the 'sourceobject' of the > subform. > > got it? > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:%23OCOt2PGFHA.2976@TK2MSFTNGP09.phx.gbl... > > When I do that I get the same thing I got when I right-moused on that > area. > > That is, I get the attributes of the underlying form. The Data tab > contains > > things like "RecordSource", "Filter".....down to "Record Locks." No > "Link" > > attributes. > > > > "rico" <r***@discussions.microsoft.com> wrote in message > > news:42575E82-8BDD-4DBF-A3CD-8E14EF61B752@microsoft.com... > > > In form design view, doulble click on the subform, the subforms > properties > > > should then pop up. Select the data tab. That should show you the master > > and > > > child fields. > > > > > > HTH > > > > > > Rico > > > > > > > > > "Laurel" wrote: > > > > > > > I have a form with 4 tabpages. I have subforms on two of those > > tabpages. I > > > > successfully linked one of those subforms with the master by doing > > something > > > > with the mouse that got me to a property list where the "data" > tabpage > > > > included "master link" and "child link" (I THINK it was 'master'... > > might > > > > have been 'parent'.) > > > > > > > > My problem is that I don't know exactly what I did (right > > mouse/properties > > > > somewhere - just don't know where). Now I can't link the second > subform > > to > > > > the master because I can't get at that particular property list. > > > > > > > > I know I'm not imagining that I did it succesfully once. The first > > subform > > > > is in synch with the records on the master form. The second is not. > > > > > > > > Someone suggested that I can see all of the controls in the dropdown > in > > the > > > > menu. I see tabpages and subforms, but I don't see subforms CONTROLS > > (not > > > > yelling... underlining). My understanding is that a subform actually > > lives > > > > inside a subform control. > > > > > > > > Whether or not I'm right about the subform control thing.... Can > someone > > > > tell me how to get at that property list that contains "master link" > and > > > > "child link"? Might I have a corrupt database? I've "compact & > > repair"ed > > > > a couple of times. > > > > > > > > > > > > > > > > > > after the single clicke, choose "View > Properties" - then in the properites
window look at the 'Data' tab. Your memory should be refreshed.... Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:%238M2o$PGFHA.3608@TK2MSFTNGP14.phx.gbl... > A single click just seems to select the subform (put 8 tiny squares on > corners and sides). This is what I would expect it to do. When I click > after it is selected, it unselects (again, what I would expect). > > So, no, don't got it yet. > > I'm running Access 2000. Do you think there might be a bug involved here > somewhere? > > "Malcolm Cook" <m**@stowers-institute.org> wrote in message > news:%23SWFw5PGFHA.2588@TK2MSFTNGP09.phx.gbl... > > single click. > > > > the 1st time you click, you get the subform object > > > > the 2nd time you click, you get the form which is the 'sourceobject' of > the > > subform. > > > > got it? > > > > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > > news:%23OCOt2PGFHA.2976@TK2MSFTNGP09.phx.gbl... > > > When I do that I get the same thing I got when I right-moused on that > > area. > > > That is, I get the attributes of the underlying form. The Data tab > > contains > > > things like "RecordSource", "Filter".....down to "Record Locks." No > > "Link" > > > attributes. > > > > > > "rico" <r***@discussions.microsoft.com> wrote in message > > > news:42575E82-8BDD-4DBF-A3CD-8E14EF61B752@microsoft.com... > > > > In form design view, doulble click on the subform, the subforms > > properties > > > > should then pop up. Select the data tab. That should show you the > master > > > and > > > > child fields. > > > > > > > > HTH > > > > > > > > Rico > > > > > > > > > > > > "Laurel" wrote: > > > > > > > > > I have a form with 4 tabpages. I have subforms on two of those > > > tabpages. I > > > > > successfully linked one of those subforms with the master by doing > > > something > > > > > with the mouse that got me to a property list where the "data" > > tabpage > > > > > included "master link" and "child link" (I THINK it was 'master'... > > > might > > > > > have been 'parent'.) > > > > > > > > > > My problem is that I don't know exactly what I did (right > > > mouse/properties > > > > > somewhere - just don't know where). Now I can't link the second > > subform > > > to > > > > > the master because I can't get at that particular property list. > > > > > > > > > > I know I'm not imagining that I did it succesfully once. The first > > > subform > > > > > is in synch with the records on the master form. The second is not. > > > > > > > > > > Someone suggested that I can see all of the controls in the dropdown > > in > > > the > > > > > menu. I see tabpages and subforms, but I don't see subforms > CONTROLS > > > (not > > > > > yelling... underlining). My understanding is that a subform > actually > > > lives > > > > > inside a subform control. > > > > > > > > > > Whether or not I'm right about the subform control thing.... Can > > someone > > > > > tell me how to get at that property list that contains "master link" > > and > > > > > "child link"? Might I have a corrupt database? I've "compact & > > > repair"ed > > > > > a couple of times. > > > > > > > > > > > > > > > > > > > > > > > > > > > BINGO!!!!!!!!
THANKS!!!!! I really don't think this is how I did it for the first tab - menu didn't feel familiar, but who cares! Show quote "Malcolm Cook" <m**@stowers-institute.org> wrote in message news:OqiWvPQGFHA.3492@TK2MSFTNGP12.phx.gbl... > after the single clicke, choose "View > Properties" - then in the properites > window look at the 'Data' tab. Your memory should be refreshed.... > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:%238M2o$PGFHA.3608@TK2MSFTNGP14.phx.gbl... > > A single click just seems to select the subform (put 8 tiny squares on > > corners and sides). This is what I would expect it to do. When I click > > after it is selected, it unselects (again, what I would expect). > > > > So, no, don't got it yet. > > > > I'm running Access 2000. Do you think there might be a bug involved here > > somewhere? > > > > "Malcolm Cook" <m**@stowers-institute.org> wrote in message > > news:%23SWFw5PGFHA.2588@TK2MSFTNGP09.phx.gbl... > > > single click. > > > > > > the 1st time you click, you get the subform object > > > > > > the 2nd time you click, you get the form which is the 'sourceobject' of > > the > > > subform. > > > > > > got it? > > > > > > > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > > > news:%23OCOt2PGFHA.2976@TK2MSFTNGP09.phx.gbl... > > > > When I do that I get the same thing I got when I right-moused on that > > > area. > > > > That is, I get the attributes of the underlying form. The Data tab > > > contains > > > > things like "RecordSource", "Filter".....down to "Record Locks." No > > > "Link" > > > > attributes. > > > > > > > > "rico" <r***@discussions.microsoft.com> wrote in message > > > > news:42575E82-8BDD-4DBF-A3CD-8E14EF61B752@microsoft.com... > > > > > In form design view, doulble click on the subform, the subforms > > > properties > > > > > should then pop up. Select the data tab. That should show you the > > master > > > > and > > > > > child fields. > > > > > > > > > > HTH > > > > > > > > > > Rico > > > > > > > > > > > > > > > "Laurel" wrote: > > > > > > > > > > > I have a form with 4 tabpages. I have subforms on two of those > > > > tabpages. I > > > > > > successfully linked one of those subforms with the master by doing > > > > something > > > > > > with the mouse that got me to a property list where the "data" > > > tabpage > > > > > > included "master link" and "child link" (I THINK it was > 'master'... > > > > might > > > > > > have been 'parent'.) > > > > > > > > > > > > My problem is that I don't know exactly what I did (right > > > > mouse/properties > > > > > > somewhere - just don't know where). Now I can't link the second > > > subform > > > > to > > > > > > the master because I can't get at that particular property list. > > > > > > > > > > > > I know I'm not imagining that I did it succesfully once. The > first > > > > subform > > > > > > is in synch with the records on the master form. The second is > not. > > > > > > > > > > > > Someone suggested that I can see all of the controls in the > dropdown > > > in > > > > the > > > > > > menu. I see tabpages and subforms, but I don't see subforms > > CONTROLS > > > > (not > > > > > > yelling... underlining). My understanding is that a subform > > actually > > > > lives > > > > > > inside a subform control. > > > > > > > > > > > > Whether or not I'm right about the subform control thing.... Can > > > someone > > > > > > tell me how to get at that property list that contains "master > link" > > > and > > > > > > "child link"? Might I have a corrupt database? I've "compact & > > > > repair"ed > > > > > > a couple of times. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Laurel wrote:
Show quote > I have a form with 4 tabpages. I have subforms on two of those You likely have your subform controls named the same as the forms within> tabpages. I successfully linked one of those subforms with the > master by doing something with the mouse that got me to a property > list where the "data" tabpage included "master link" and "child > link" (I THINK it was 'master'... might have been 'parent'.) > > My problem is that I don't know exactly what I did (right > mouse/properties somewhere - just don't know where). Now I can't > link the second subform to the master because I can't get at that > particular property list. > > I know I'm not imagining that I did it succesfully once. The first > subform is in synch with the records on the master form. The second > is not. > > Someone suggested that I can see all of the controls in the dropdown > in the menu. I see tabpages and subforms, but I don't see subforms > CONTROLS[snip] them (which is typical). What you see in the list are the controls as the forms within the subform controls are never shown in that list. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com No, I don't have them named the same. I read a really excellent article
yesterday by Roger Carlson about why subforms can be confusing. Once I bumped into this problem, I carefully named the pages objects ContactPage and FundPage and left the forms with the Access default names, frmContacts and frmFunds. I've looked carefully at the list of objects in the menu dropdown. There simply aren't any third objects associated with the two tabpages that each have a sub-form on them. Again, I'm beginning to suspect some corruption here. Do you think it's time to start over? I will wait til I get a response to this notion that single-clicking on anything will bring up properties instead of selecting the thing. There's some missing info or bad communication going on here somewhere. Thanks for taking time with this! Show quote "Rick Brandt" <rickbran***@hotmail.com> wrote in message news:381640F5g9ntgU1@individual.net... > Laurel wrote: > > I have a form with 4 tabpages. I have subforms on two of those > > tabpages. I successfully linked one of those subforms with the > > master by doing something with the mouse that got me to a property > > list where the "data" tabpage included "master link" and "child > > link" (I THINK it was 'master'... might have been 'parent'.) > > > > My problem is that I don't know exactly what I did (right > > mouse/properties somewhere - just don't know where). Now I can't > > link the second subform to the master because I can't get at that > > particular property list. > > > > I know I'm not imagining that I did it succesfully once. The first > > subform is in synch with the records on the master form. The second > > is not. > > > > Someone suggested that I can see all of the controls in the dropdown > > in the menu. I see tabpages and subforms, but I don't see subforms > > CONTROLS[snip] > > You likely have your subform controls named the same as the forms within > them (which is typical). What you see in the list are the controls as the > forms within the subform controls are never shown in that list. > > -- > I don't check the Email account attached > to this message. Send instead to... > RBrandt at Hunter dot com > > Single-clicking does not bring up properties (unless the Properties are
already displayed for another control). Once a control is selected, you can then bring up the properties by going to View Properties, pressing F4, clicking the Properties button on the Toolbar, OR right-clicking on the control selected and choosing Properties. In my answer to your previous post, I assumed that you knew how to display the Properties. Debbie Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... | No, I don't have them named the same. I read a really excellent article | yesterday by Roger Carlson about why subforms can be confusing. Once I | bumped into this problem, I carefully named the pages objects ContactPage | and FundPage and left the forms with the Access default names, frmContacts | and frmFunds. I've looked carefully at the list of objects in the menu | dropdown. There simply aren't any third objects associated with the two | tabpages that each have a sub-form on them. | | Again, I'm beginning to suspect some corruption here. Do you think it's | time to start over? | I will wait til I get a response to this notion that single-clicking on | anything will bring up properties instead of selecting the thing. There's | some missing info or bad communication going on here somewhere. | | Thanks for taking time with this! | | "Rick Brandt" <rickbran***@hotmail.com> wrote in message | news:381640F5g9ntgU1@individual.net... | > Laurel wrote: | > > I have a form with 4 tabpages. I have subforms on two of those | > > tabpages. I successfully linked one of those subforms with the | > > master by doing something with the mouse that got me to a property | > > list where the "data" tabpage included "master link" and "child | > > link" (I THINK it was 'master'... might have been 'parent'.) | > > | > > My problem is that I don't know exactly what I did (right | > > mouse/properties somewhere - just don't know where). Now I can't | > > link the second subform to the master because I can't get at that | > > particular property list. | > > | > > I know I'm not imagining that I did it succesfully once. The first | > > subform is in synch with the records on the master form. The second | > > is not. | > > | > > Someone suggested that I can see all of the controls in the dropdown | > > in the menu. I see tabpages and subforms, but I don't see subforms | > > CONTROLS[snip] | > | > You likely have your subform controls named the same as the forms within | > them (which is typical). What you see in the list are the controls as the | > forms within the subform controls are never shown in that list. | > | > -- | > I don't check the Email account attached | > to this message. Send instead to... | > RBrandt at Hunter dot com I think I do know how to display properties. I just didn't know that in the
case of a subform, the way that I usually use (rightmouse/properties) didn't work. Show quote "DebbieG" <debbieg@NOSPAM.NOSPAM> wrote in message news:OM1bLYRGFHA.1396@tk2msftngp13.phx.gbl... > Single-clicking does not bring up properties (unless the Properties are > already displayed for another control). Once a control is selected, you can > then bring up the properties by going to View Properties, pressing F4, > clicking the Properties button on the Toolbar, OR right-clicking on the > control selected and choosing Properties. > > In my answer to your previous post, I assumed that you knew how to display > the Properties. > > Debbie > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... > | No, I don't have them named the same. I read a really excellent article > | yesterday by Roger Carlson about why subforms can be confusing. Once I > | bumped into this problem, I carefully named the pages objects ContactPage > | and FundPage and left the forms with the Access default names, > frmContacts > | and frmFunds. I've looked carefully at the list of objects in the menu > | dropdown. There simply aren't any third objects associated with the two > | tabpages that each have a sub-form on them. > | > | Again, I'm beginning to suspect some corruption here. Do you think it's > | time to start over? > | I will wait til I get a response to this notion that single-clicking on > | anything will bring up properties instead of selecting the thing. There's > | some missing info or bad communication going on here somewhere. > | > | Thanks for taking time with this! > | > | "Rick Brandt" <rickbran***@hotmail.com> wrote in message > | news:381640F5g9ntgU1@individual.net... > | > Laurel wrote: > | > > I have a form with 4 tabpages. I have subforms on two of those > | > > tabpages. I successfully linked one of those subforms with the > | > > master by doing something with the mouse that got me to a property > | > > list where the "data" tabpage included "master link" and "child > | > > link" (I THINK it was 'master'... might have been 'parent'.) > | > > > | > > My problem is that I don't know exactly what I did (right > | > > mouse/properties somewhere - just don't know where). Now I can't > | > > link the second subform to the master because I can't get at that > | > > particular property list. > | > > > | > > I know I'm not imagining that I did it succesfully once. The first > | > > subform is in synch with the records on the master form. The second > | > > is not. > | > > > | > > Someone suggested that I can see all of the controls in the dropdown > | > > in the menu. I see tabpages and subforms, but I don't see subforms > | > > CONTROLS[snip] > | > > | > You likely have your subform controls named the same as the forms within > | > them (which is typical). What you see in the list are the controls as > the > | > forms within the subform controls are never shown in that list. > | > > | > -- > | > I don't check the Email account attached > | > to this message. Send instead to... > | > RBrandt at Hunter dot com > I have no problem using the right-mouse to display the properties for a
subform control. I still don't understand why you're having problems with that. Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:uwJxzFSGFHA.3504@TK2MSFTNGP12.phx.gbl... |I think I do know how to display properties. I just didn't know that in the | case of a subform, the way that I usually use (rightmouse/properties) didn't | work. | | "DebbieG" <debbieg@NOSPAM.NOSPAM> wrote in message | news:OM1bLYRGFHA.1396@tk2msftngp13.phx.gbl... | > Single-clicking does not bring up properties (unless the Properties are | > already displayed for another control). Once a control is selected, you | can | > then bring up the properties by going to View Properties, pressing F4, | > clicking the Properties button on the Toolbar, OR right-clicking on the | > control selected and choosing Properties. | > | > In my answer to your previous post, I assumed that you knew how to display | > the Properties. | > | > Debbie | > | > | > "Laurel" <FakeM***@Hotmail.com> wrote in message | > news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... | > | No, I don't have them named the same. I read a really excellent article | > | yesterday by Roger Carlson about why subforms can be confusing. Once I | > | bumped into this problem, I carefully named the pages objects | ContactPage | > | and FundPage and left the forms with the Access default names, | > frmContacts | > | and frmFunds. I've looked carefully at the list of objects in the menu | > | dropdown. There simply aren't any third objects associated with the two | > | tabpages that each have a sub-form on them. | > | | > | Again, I'm beginning to suspect some corruption here. Do you think it's | > | time to start over? | > | I will wait til I get a response to this notion that single-clicking on | > | anything will bring up properties instead of selecting the thing. | There's | > | some missing info or bad communication going on here somewhere. | > | | > | Thanks for taking time with this! | > | | > | "Rick Brandt" <rickbran***@hotmail.com> wrote in message | > | news:381640F5g9ntgU1@individual.net... | > | > Laurel wrote: | > | > > I have a form with 4 tabpages. I have subforms on two of those | > | > > tabpages. I successfully linked one of those subforms with the | > | > > master by doing something with the mouse that got me to a property | > | > > list where the "data" tabpage included "master link" and "child | > | > > link" (I THINK it was 'master'... might have been 'parent'.) | > | > > | > | > > My problem is that I don't know exactly what I did (right | > | > > mouse/properties somewhere - just don't know where). Now I can't | > | > > link the second subform to the master because I can't get at that | > | > > particular property list. | > | > > | > | > > I know I'm not imagining that I did it succesfully once. The first | > | > > subform is in synch with the records on the master form. The second | > | > > is not. | > | > > | > | > > Someone suggested that I can see all of the controls in the dropdown | > | > > in the menu. I see tabpages and subforms, but I don't see subforms | > | > > CONTROLS[snip] | > | > | > | > You likely have your subform controls named the same as the forms | within | > | > them (which is typical). What you see in the list are the controls as | > the | > | > forms within the subform controls are never shown in that list. | > | > | > | > -- | > | > I don't check the Email account attached | > | > to this message. Send instead to... | > | > RBrandt at Hunter dot com | > | | Me either. As I mentioned a couple of times, I suspect some subtle
corruption of the db. Like.. why would the PASTE menu item, alone of al lthe others, be disabled. Weird. But, thankfully, I have a solution. Thanks for pointing out that what I thought might be standard behavior is actually still "weird." Show quote "DebbieG" <debbieg@NOSPAM.NOSPAM> wrote in message news:eh27oNSGFHA.3928@TK2MSFTNGP15.phx.gbl... > I have no problem using the right-mouse to display the properties for a > subform control. I still don't understand why you're having problems with > that. > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:uwJxzFSGFHA.3504@TK2MSFTNGP12.phx.gbl... > |I think I do know how to display properties. I just didn't know that in > the > | case of a subform, the way that I usually use (rightmouse/properties) > didn't > | work. > | > | "DebbieG" <debbieg@NOSPAM.NOSPAM> wrote in message > | news:OM1bLYRGFHA.1396@tk2msftngp13.phx.gbl... > | > Single-clicking does not bring up properties (unless the Properties are > | > already displayed for another control). Once a control is selected, you > | can > | > then bring up the properties by going to View Properties, pressing F4, > | > clicking the Properties button on the Toolbar, OR right-clicking on the > | > control selected and choosing Properties. > | > > | > In my answer to your previous post, I assumed that you knew how to > display > | > the Properties. > | > > | > Debbie > | > > | > > | > "Laurel" <FakeM***@Hotmail.com> wrote in message > | > news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... > | > | No, I don't have them named the same. I read a really excellent > article > | > | yesterday by Roger Carlson about why subforms can be confusing. Once > I > | > | bumped into this problem, I carefully named the pages objects > | ContactPage > | > | and FundPage and left the forms with the Access default names, > | > frmContacts > | > | and frmFunds. I've looked carefully at the list of objects in the > menu > | > | dropdown. There simply aren't any third objects associated with the > two > | > | tabpages that each have a sub-form on them. > | > | > | > | Again, I'm beginning to suspect some corruption here. Do you think > it's > | > | time to start over? > | > | I will wait til I get a response to this notion that single-clicking > on > | > | anything will bring up properties instead of selecting the thing. > | There's > | > | some missing info or bad communication going on here somewhere. > | > | > | > | Thanks for taking time with this! > | > | > | > | "Rick Brandt" <rickbran***@hotmail.com> wrote in message > | > | news:381640F5g9ntgU1@individual.net... > | > | > Laurel wrote: > | > | > > I have a form with 4 tabpages. I have subforms on two of those > | > | > > tabpages. I successfully linked one of those subforms with the > | > | > > master by doing something with the mouse that got me to a property > | > | > > list where the "data" tabpage included "master link" and "child > | > | > > link" (I THINK it was 'master'... might have been 'parent'.) > | > | > > > | > | > > My problem is that I don't know exactly what I did (right > | > | > > mouse/properties somewhere - just don't know where). Now I can't > | > | > > link the second subform to the master because I can't get at that > | > | > > particular property list. > | > | > > > | > | > > I know I'm not imagining that I did it succesfully once. The > first > | > | > > subform is in synch with the records on the master form. The > second > | > | > > is not. > | > | > > > | > | > > Someone suggested that I can see all of the controls in the > dropdown > | > | > > in the menu. I see tabpages and subforms, but I don't see > subforms > | > | > > CONTROLS[snip] > | > | > > | > | > You likely have your subform controls named the same as the forms > | within > | > | > them (which is typical). What you see in the list are the controls > as > | > the > | > | > forms within the subform controls are never shown in that list. > | > | > > | > | > -- > | > | > I don't check the Email account attached > | > | > to this message. Send instead to... > | > | > RBrandt at Hunter dot com > | > > | > | > You seem to have some confusion between your tab pages and your
subform controls and your forms? pages should be called page subform controls should be called sbfxxxxxx forms should be called ..... From your description, it appears that in the list of controls you can see your page controls and your subform controls. The subform controls have the same names as the subforms. BTW, if you open the subform in design view FIRST, then open the main form in design view, you don't get the subform stuck inside the subform control. (david) Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... > No, I don't have them named the same. I read a really excellent article > yesterday by Roger Carlson about why subforms can be confusing. Once I > bumped into this problem, I carefully named the pages objects ContactPage > and FundPage and left the forms with the Access default names, > frmContacts > and frmFunds. I've looked carefully at the list of objects in the menu > dropdown. There simply aren't any third objects associated with the two > tabpages that each have a sub-form on them. > > Again, I'm beginning to suspect some corruption here. Do you think it's > time to start over? > I will wait til I get a response to this notion that single-clicking on > anything will bring up properties instead of selecting the thing. There's > some missing info or bad communication going on here somewhere. > > Thanks for taking time with this! > > "Rick Brandt" <rickbran***@hotmail.com> wrote in message > news:381640F5g9ntgU1@individual.net... >> Laurel wrote: >> > I have a form with 4 tabpages. I have subforms on two of those >> > tabpages. I successfully linked one of those subforms with the >> > master by doing something with the mouse that got me to a property >> > list where the "data" tabpage included "master link" and "child >> > link" (I THINK it was 'master'... might have been 'parent'.) >> > >> > My problem is that I don't know exactly what I did (right >> > mouse/properties somewhere - just don't know where). Now I can't >> > link the second subform to the master because I can't get at that >> > particular property list. >> > >> > I know I'm not imagining that I did it succesfully once. The first >> > subform is in synch with the records on the master form. The second >> > is not. >> > >> > Someone suggested that I can see all of the controls in the dropdown >> > in the menu. I see tabpages and subforms, but I don't see subforms >> > CONTROLS[snip] >> >> You likely have your subform controls named the same as the forms within >> them (which is typical). What you see in the list are the controls as >> the >> forms within the subform controls are never shown in that list. >> >> -- >> I don't check the Email account attached >> to this message. Send instead to... >> RBrandt at Hunter dot com >> >> > > > You seem to have some confusion between your tab pages and your No, I don't think so. Perhaps you didn't notice my explanation embedded in> subform controls and your forms? the thread. It seems that my system is behaving differently than it should. I've found a work-around by using the menu at the top to get at the properties wndow for he control. Show quote > > No, I don't have them named the same. I read a really excellent article > > yesterday by Roger Carlson about why subforms can be confusing. Once I > > bumped into this problem, I carefully named the pages objects ContactPage > > and FundPage and left the forms with the Access default names, > > frmContacts > > and frmFunds. I've looked carefully at the list of objects in the menu > > dropdown. There simply aren't any third objects associated with the two > > tabpages that each have a sub-form on them. "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:uZzPwdVGFHA.2736@TK2MSFTNGP09.phx.gbl... > You seem to have some confusion between your tab pages and your > subform controls and your forms? > > pages should be called page > subform controls should be called sbfxxxxxx > forms should be called ..... > > From your description, it appears that in the list of controls > you can see your page controls and your subform controls. The > subform controls have the same names as the subforms. > > BTW, if you open the subform in design view FIRST, then open > the main form in design view, you don't get the subform stuck > inside the subform control. > > (david) > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... > > No, I don't have them named the same. I read a really excellent article > > yesterday by Roger Carlson about why subforms can be confusing. Once I > > bumped into this problem, I carefully named the pages objects ContactPage > > and FundPage and left the forms with the Access default names, > > frmContacts > > and frmFunds. I've looked carefully at the list of objects in the menu > > dropdown. There simply aren't any third objects associated with the two > > tabpages that each have a sub-form on them. > > > > Again, I'm beginning to suspect some corruption here. Do you think it's > > time to start over? > > I will wait til I get a response to this notion that single-clicking on > > anything will bring up properties instead of selecting the thing. There's > > some missing info or bad communication going on here somewhere. > > > > Thanks for taking time with this! > > > > "Rick Brandt" <rickbran***@hotmail.com> wrote in message > > news:381640F5g9ntgU1@individual.net... > >> Laurel wrote: > >> > I have a form with 4 tabpages. I have subforms on two of those > >> > tabpages. I successfully linked one of those subforms with the > >> > master by doing something with the mouse that got me to a property > >> > list where the "data" tabpage included "master link" and "child > >> > link" (I THINK it was 'master'... might have been 'parent'.) > >> > > >> > My problem is that I don't know exactly what I did (right > >> > mouse/properties somewhere - just don't know where). Now I can't > >> > link the second subform to the master because I can't get at that > >> > particular property list. > >> > > >> > I know I'm not imagining that I did it succesfully once. The first > >> > subform is in synch with the records on the master form. The second > >> > is not. > >> > > >> > Someone suggested that I can see all of the controls in the dropdown > >> > in the menu. I see tabpages and subforms, but I don't see subforms > >> > CONTROLS[snip] > >> > >> You likely have your subform controls named the same as the forms within > >> them (which is typical). What you see in the list are the controls as > >> the > >> forms within the subform controls are never shown in that list. > >> > >> -- > >> I don't check the Email account attached > >> to this message. Send instead to... > >> RBrandt at Hunter dot com > >> > >> > > > > > > >I don't think so. Perhaps you didn't notice my explanation I read that, and it doesn't support your argument:You mention renaming the page objects and not finding third objects. Perhaps you meant that you had renamed the subform controls and could not find the page objects? I'm glad that you have found the subform control properties, and I'm certain that eventually you will sort out the nomenclature :) BTW, subforms are quite slow. I never have a default subform in a tabbed page unless the page is visible. I load the subform in the subform control only when the page becomes visible. Actually, in many places I place a single subform control /below/ the tabbed pages, and load a different form into the control for each page. It's a bit fiddly to get the layout correct for a single subform control beneath a tab control, but it does look ok after some effort. (david) Show quote "Laurel" <FakeM***@Hotmail.com> wrote in message news:%239KNXmdGFHA.3964@TK2MSFTNGP14.phx.gbl... >> You seem to have some confusion between your tab pages and your >> subform controls and your forms? > > No, I don't think so. Perhaps you didn't notice my explanation embedded > in > the > thread. It seems that my system is behaving differently than it should. > I've found a work-around by using the menu at the top to get at the > properties wndow for he control. > >> > No, I don't have them named the same. I read a really excellent >> > article >> > yesterday by Roger Carlson about why subforms can be confusing. Once I >> > bumped into this problem, I carefully named the pages objects > ContactPage >> > and FundPage and left the forms with the Access default names, >> > frmContacts >> > and frmFunds. I've looked carefully at the list of objects in the menu >> > dropdown. There simply aren't any third objects associated with the >> > two >> > tabpages that each have a sub-form on them. > > > "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message > news:uZzPwdVGFHA.2736@TK2MSFTNGP09.phx.gbl... >> You seem to have some confusion between your tab pages and your >> subform controls and your forms? >> >> pages should be called page >> subform controls should be called sbfxxxxxx >> forms should be called ..... >> >> From your description, it appears that in the list of controls >> you can see your page controls and your subform controls. The >> subform controls have the same names as the subforms. >> >> BTW, if you open the subform in design view FIRST, then open >> the main form in design view, you don't get the subform stuck >> inside the subform control. >> >> (david) >> >> >> "Laurel" <FakeM***@Hotmail.com> wrote in message >> news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... >> > No, I don't have them named the same. I read a really excellent >> > article >> > yesterday by Roger Carlson about why subforms can be confusing. Once I >> > bumped into this problem, I carefully named the pages objects > ContactPage >> > and FundPage and left the forms with the Access default names, >> > frmContacts >> > and frmFunds. I've looked carefully at the list of objects in the menu >> > dropdown. There simply aren't any third objects associated with the >> > two >> > tabpages that each have a sub-form on them. >> > >> > Again, I'm beginning to suspect some corruption here. Do you think >> > it's >> > time to start over? >> > I will wait til I get a response to this notion that single-clicking on >> > anything will bring up properties instead of selecting the thing. > There's >> > some missing info or bad communication going on here somewhere. >> > >> > Thanks for taking time with this! >> > >> > "Rick Brandt" <rickbran***@hotmail.com> wrote in message >> > news:381640F5g9ntgU1@individual.net... >> >> Laurel wrote: >> >> > I have a form with 4 tabpages. I have subforms on two of those >> >> > tabpages. I successfully linked one of those subforms with the >> >> > master by doing something with the mouse that got me to a property >> >> > list where the "data" tabpage included "master link" and "child >> >> > link" (I THINK it was 'master'... might have been 'parent'.) >> >> > >> >> > My problem is that I don't know exactly what I did (right >> >> > mouse/properties somewhere - just don't know where). Now I can't >> >> > link the second subform to the master because I can't get at that >> >> > particular property list. >> >> > >> >> > I know I'm not imagining that I did it succesfully once. The first >> >> > subform is in synch with the records on the master form. The second >> >> > is not. >> >> > >> >> > Someone suggested that I can see all of the controls in the dropdown >> >> > in the menu. I see tabpages and subforms, but I don't see subforms >> >> > CONTROLS[snip] >> >> >> >> You likely have your subform controls named the same as the forms > within >> >> them (which is typical). What you see in the list are the controls as >> >> the >> >> forms within the subform controls are never shown in that list. >> >> >> >> -- >> >> I don't check the Email account attached >> >> to this message. Send instead to... >> >> RBrandt at Hunter dot com >> >> >> >> >> > >> > >> >> > > Yeah, I did mention not finding third objects.
Show quote > >> > I've looked carefully at the list of objects in the menu > >> > dropdown. There simply aren't any third objects associated with the > >> > two "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:%23QcAOcgGFHA.2356@TK2MSFTNGP12.phx.gbl... > >I don't think so. Perhaps you didn't notice my explanation > > I read that, and it doesn't support your argument: > > You mention renaming the page objects and not > finding third objects. > > Perhaps you meant that you had renamed the subform > controls and could not find the page objects? > > I'm glad that you have found the subform control > properties, and I'm certain that eventually you > will sort out the nomenclature :) > > BTW, subforms are quite slow. I never have a default > subform in a tabbed page unless the page is visible. > I load the subform in the subform control only when > the page becomes visible. Actually, in many places > I place a single subform control /below/ the tabbed > pages, and load a different form into the control > for each page. It's a bit fiddly to get the layout > correct for a single subform control beneath a tab > control, but it does look ok after some effort. > > (david) > > > > "Laurel" <FakeM***@Hotmail.com> wrote in message > news:%239KNXmdGFHA.3964@TK2MSFTNGP14.phx.gbl... > >> You seem to have some confusion between your tab pages and your > >> subform controls and your forms? > > > > No, I don't think so. Perhaps you didn't notice my explanation embedded > > in > > the > > thread. It seems that my system is behaving differently than it should. > > I've found a work-around by using the menu at the top to get at the > > properties wndow for he control. > > > >> > No, I don't have them named the same. I read a really excellent > >> > article > >> > yesterday by Roger Carlson about why subforms can be confusing. Once I > >> > bumped into this problem, I carefully named the pages objects > > ContactPage > >> > and FundPage and left the forms with the Access default names, > >> > frmContacts > >> > and frmFunds. I've looked carefully at the list of objects in the menu > >> > dropdown. There simply aren't any third objects associated with the > >> > two > >> > tabpages that each have a sub-form on them. > > > > > > "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message > > news:uZzPwdVGFHA.2736@TK2MSFTNGP09.phx.gbl... > >> You seem to have some confusion between your tab pages and your > >> subform controls and your forms? > >> > >> pages should be called page > >> subform controls should be called sbfxxxxxx > >> forms should be called ..... > >> > >> From your description, it appears that in the list of controls > >> you can see your page controls and your subform controls. The > >> subform controls have the same names as the subforms. > >> > >> BTW, if you open the subform in design view FIRST, then open > >> the main form in design view, you don't get the subform stuck > >> inside the subform control. > >> > >> (david) > >> > >> > >> "Laurel" <FakeM***@Hotmail.com> wrote in message > >> news:%23FZ8WDQGFHA.2676@TK2MSFTNGP12.phx.gbl... > >> > No, I don't have them named the same. I read a really excellent > >> > article > >> > yesterday by Roger Carlson about why subforms can be confusing. Once I > >> > bumped into this problem, I carefully named the pages objects > > ContactPage > >> > and FundPage and left the forms with the Access default names, > >> > frmContacts > >> > and frmFunds. I've looked carefully at the list of objects in the menu > >> > dropdown. There simply aren't any third objects associated with the > >> > two > >> > tabpages that each have a sub-form on them. > >> > > >> > Again, I'm beginning to suspect some corruption here. Do you think > >> > it's > >> > time to start over? > >> > I will wait til I get a response to this notion that single-clicking on > >> > anything will bring up properties instead of selecting the thing. > > There's > >> > some missing info or bad communication going on here somewhere. > >> > > >> > Thanks for taking time with this! > >> > > >> > "Rick Brandt" <rickbran***@hotmail.com> wrote in message > >> > news:381640F5g9ntgU1@individual.net... > >> >> Laurel wrote: > >> >> > I have a form with 4 tabpages. I have subforms on two of those > >> >> > tabpages. I successfully linked one of those subforms with the > >> >> > master by doing something with the mouse that got me to a property > >> >> > list where the "data" tabpage included "master link" and "child > >> >> > link" (I THINK it was 'master'... might have been 'parent'.) > >> >> > > >> >> > My problem is that I don't know exactly what I did (right > >> >> > mouse/properties somewhere - just don't know where). Now I can't > >> >> > link the second subform to the master because I can't get at that > >> >> > particular property list. > >> >> > > >> >> > I know I'm not imagining that I did it succesfully once. The first > >> >> > subform is in synch with the records on the master form. The second > >> >> > is not. > >> >> > > >> >> > Someone suggested that I can see all of the controls in the dropdown > >> >> > in the menu. I see tabpages and subforms, but I don't see subforms > >> >> > CONTROLS[snip] > >> >> > >> >> You likely have your subform controls named the same as the forms > > within > >> >> them (which is typical). What you see in the list are the controls as > >> >> the > >> >> forms within the subform controls are never shown in that list. > >> >> > >> >> -- > >> >> I don't check the Email account attached > >> >> to this message. Send instead to... > >> >> RBrandt at Hunter dot com > >> >> > >> >> > >> > > >> > > >> > >> > > > > > >
Other interesting topics
|
|||||||||||||||||||||||