[AccessD] Set value in a report textbox
Rocky Smolin
rockysmolin at bchacc.com
Tue Oct 30 17:06:45 CDT 2018
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