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 |
#11
|
|||
|
|||
Copying sub reports - third time around
Hi Duane,
Ah, the light dawns. I did not realize you could link on non-record source items such as text boxes. That because the linking wizard does not offer that option and complains if you try to do so. Very interesting!!! Learn something new! Thanks again! Clifford Bass Duane Hookom wrote: My calendar report available at http://www.access.hookom.net/Samples.htm has a record source on the main report that includes a WeekOf field with values like: 1/3/2010 1/10/2010 1/17/2010 I then create text boxes across the detail section with control sources like: =[WeekOf]+0 =[WeekOf]+1 =[WeekOf]+2 I can then use these 7 (or 5 if only workweek) text boxes as the Link Master for the individual copies of the same subreport. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#12
|
|||
|
|||
Copying sub reports - third time around
Clifford,
Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- 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 "Clifford Bass via AccessMonster.com" u48370@uwe wrote in message news:a2822533184c1@uwe... Hi Duane, Ah, the light dawns. I did not realize you could link on non-record source items such as text boxes. That because the linking wizard does not offer that option and complains if you try to do so. Very interesting!!! Learn something new! Thanks again! Clifford Bass Duane Hookom wrote: My calendar report available at http://www.access.hookom.net/Samples.htm has a record source on the main report that includes a WeekOf field with values like: 1/3/2010 1/10/2010 1/17/2010 I then create text boxes across the detail section with control sources like: =[WeekOf]+0 =[WeekOf]+1 =[WeekOf]+2 I can then use these 7 (or 5 if only workweek) text boxes as the Link Master for the individual copies of the same subreport. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#13
|
|||
|
|||
Copying sub reports - third time around
Hi Gina,
Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#14
|
|||
|
|||
Copying sub reports - third time around
Clifford,
I hear that! -- 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 "Clifford Bass via AccessMonster.com" u48370@uwe wrote in message news:a28277655ceeb@uwe... Hi Gina, Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#15
|
|||
|
|||
Copying sub reports - third time around
At least we're having a good time and learning new things in this thread ;-)
I don't like setting the Link Master/Child properties in code (forms or reports). It seems to me I have had issues with this but it was a number of years (and versions) ago. I expect you could create a 5 or 7 column subreport for a calendar but you would have to make sure every date was rendered. -- Duane Hookom Microsoft Access MVP "Clifford Bass via AccessMonster.com" wrote: Hi Gina, Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 . |
#16
|
|||
|
|||
Copying sub reports - third time around
Hi Duane,
Yes, and that makes for a good Friday! I would agree with you about changing the links in code. A good weekend to you all! Clifford Bass Duane Hookom wrote: At least we're having a good time and learning new things in this thread ;-) I don't like setting the Link Master/Child properties in code (forms or reports). It seems to me I have had issues with this but it was a number of years (and versions) ago. I expect you could create a 5 or 7 column subreport for a calendar but you would have to make sure every date was rendered. -- Message posted via http://www.accessmonster.com |
#17
|
|||
|
|||
Copying sub reports - third time around
Duane,
May I ask... why you don't like setting them in code? I've never had a problem BUT just because I haven't had a problem doesn't mean I won't have one. -- 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 "Duane Hookom" wrote in message ... At least we're having a good time and learning new things in this thread ;-) I don't like setting the Link Master/Child properties in code (forms or reports). It seems to me I have had issues with this but it was a number of years (and versions) ago. I expect you could create a 5 or 7 column subreport for a calendar but you would have to make sure every date was rendered. -- Duane Hookom Microsoft Access MVP "Clifford Bass via AccessMonster.com" wrote: Hi Gina, Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 . |
#18
|
|||
|
|||
Copying sub reports - third time around
First, I believe I have only tried this with forms and subforms. I recall
having serious corruption issues when attempting to change these properties. Like I said it was quite a few years ago. Now, I don't even recall why I thought I needed to change the properties. -- Duane Hookom Microsoft Access MVP "Gina Whipp" wrote: Duane, May I ask... why you don't like setting them in code? I've never had a problem BUT just because I haven't had a problem doesn't mean I won't have one. -- 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 "Duane Hookom" wrote in message ... At least we're having a good time and learning new things in this thread ;-) I don't like setting the Link Master/Child properties in code (forms or reports). It seems to me I have had issues with this but it was a number of years (and versions) ago. I expect you could create a 5 or 7 column subreport for a calendar but you would have to make sure every date was rendered. -- Duane Hookom Microsoft Access MVP "Clifford Bass via AccessMonster.com" wrote: Hi Gina, Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 . . |
#19
|
|||
|
|||
Copying sub reports - third time around
Duane,
Oh okay... just curious! -- 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 "Duane Hookom" wrote in message ... First, I believe I have only tried this with forms and subforms. I recall having serious corruption issues when attempting to change these properties. Like I said it was quite a few years ago. Now, I don't even recall why I thought I needed to change the properties. -- Duane Hookom Microsoft Access MVP "Gina Whipp" wrote: Duane, May I ask... why you don't like setting them in code? I've never had a problem BUT just because I haven't had a problem doesn't mean I won't have one. -- 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 "Duane Hookom" wrote in message ... At least we're having a good time and learning new things in this thread ;-) I don't like setting the Link Master/Child properties in code (forms or reports). It seems to me I have had issues with this but it was a number of years (and versions) ago. I expect you could create a 5 or 7 column subreport for a calendar but you would have to make sure every date was rendered. -- Duane Hookom Microsoft Access MVP "Clifford Bass via AccessMonster.com" wrote: Hi Gina, Sometimes one does something in a particular fashion for so long that one forgets to think outside the pattern. Thanks, Clifford Bass Gina Whipp wrote: Clifford, Or combo boxes... No the wizard does not bo you can just type them in or set them in code. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 . . |
|
Thread Tools | |
Display Modes | |
|
|