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

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

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

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

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

.

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

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

.

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

.



.

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

.



.