[AccessD] Set value in a report textbox

Rocky Smolin rockysmolin at bchacc.com
Tue Oct 30 17:16:41 CDT 2018


And since the A name will be retrieved in your query, you can have it show
up in a text box bound to that field.  So no code required.

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Tina N Fields
Sent: Tuesday, October 30, 2018 3:15 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Set value in a report textbox

Hmm - I'll look into that. Thanks.

T

Tina Norris Fields
231-322-2787
tinanfields-at-torchlake-dot-com

On 10/30/2018 6:06 PM, Rocky Smolin wrote:
> If the names are in a sub-report, then the record source for that sub
report could retrieve all the names as well as the foreign key to the
family.  Then the sub report would be linked to the parent report by the
FK<-->PK. So the record source for the main report would still have only one
name and the sub report for the family would have all the names.  Minus the
"A" name through a filter in the sub-report's query.
>
> If I understand you correctly.  Which is possible. (It could happen) :)
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Tina N Fields
> Sent: Tuesday, October 30, 2018 2:38 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Set value in a report textbox
>
> Hi Rocky,
>
> Yeah, that's true, but I need all the other people in the household for
> the rest of the report. So, it's something like this.
>
> At the top is the assigned family number, the household name, whether
> the household is participating in the Thanksgiving meal or the Christmas
> programs, if Christmas the date and time of pickup appear (they remain
> invisible for Thanksgiving because it's a meal and not a scheduled
> pickup), and there may also be a gift card assigned to the household.
> This last is going to change also, because there could be more than one,
> so there will be a list box here.
>
> Below that are three sub reports. The first one is about food baskets,
> that's a yes or no checkmark The second is about Toy Shop gifts
> received, where the name, age, and gender of the child appears followed
> by space for writing in indications of type of gifts, plus a textbox
> (which is going to have to become a listbox) for any gift card assigned
> to that child. The  third is for the Teen Angels where only teens are
> listed - again it's name, age, gender, space for writing in number of
> gifts, and a textbox (will become a listbox) for any gift cards.
>
> So, I have to find a way to put that person A first name up at top, but
> I also need to have all the other names.
>
> I thought I could put an unbound textbox and populate it when the report
> is Active with the PE_Fname, with PE_Fam-spot of "A", where PE_IDHH
> equals HH_ID. But, dang it, I am not figuring out how to do that.
>
> Thanks for helping me think.
>
> T
>
> Tina Norris Fields
> 231-322-2787
> tinanfields-at-torchlake-dot-com
>
> On 10/30/2018 5:15 PM, Rocky Smolin wrote:
>> Enter criterion for field PE_Fam-spot of "A"? You'd get all the
Households and only one name per.  Unless more than one person has "A" rank.
>>
>> HTH
>>
>> R
>>
>>
>> -----Original Message-----
>> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Tina N Fields
>> Sent: Tuesday, October 30, 2018 2:04 PM
>> To: ACCESSD
>> Subject: [AccessD] Set value in a report textbox
>>
>> Hii,
>>
>> I have a report for my local Salvation Army, that is to be a signature
>> sheet for the family picking up the Christmas stuff.
>>
>> When we developed it, they wanted only the household name and the
>> assigned family number to be displayed at the top of the report. Turns
>> out, though, they'd really also like the first name of the parent of the
>> household.
>>
>> The tblHouseholds doesn't have any  person names in it, of course. So, I
>> want to put a textbox alongside the Household name box to be populated
>> with the first name of person A in the household. The tblPeople has the
>> foreign key matching the household ID. (Using John Colby's naming
>> convention, HH_ID from tblHouseholds is foreign key PE_IDHH.)
>>
>> How do I do this? I have the PE_Fname in the query, and I have the
>> person's rank in the family (they insisted on this), so each
>> individual's record has a PE_Fam-spot field.  How do I display the
>> PE_Fname of the person with the PE_Fam-spot of "A" where PE_IDHH equals
>> HH_ID?
>>
>> It feels as though this should be simple, but I'm just not getting it.
>>
>> Thanks for any help you can give me.
>>
>> T
>>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list