Susan Harkins
ssharkins at gmail.com
Mon Apr 7 09:37:59 CDT 2014
But seems like you could put that picture control in with the one record and all related orders or whatever in the subreport, right? Then, you don't need a property or VBA. It's been five years since I've looked at Access, so I'm probably totally wrong. Susan H. On Mon, Apr 7, 2014 at 10:24 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > Well I don't know about the sub-report. I'm dealing with this as we speak > - > a bill of materials report where the user wants a picture of the part on > the > report - if they've identified a graphic file with the part picture. If the > picture field in the part master file is blank I set the picture property > of > the picture control to "". > > R > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins > Sent: Monday, April 07, 2014 6:19 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Fwd: Report's Hide Duplicate property doesn't work > withall field types? > > The pic would be in the main report -- linked to the relevant data in the > subreport... right? > > Susan H. > > > On Mon, Apr 7, 2014 at 9:02 AM, Rocky Smolin <rockysmolin at bchacc.com> > wrote: > > > He'd have to set a 'first time' flag. Same I think if the pic were in > > a sub report, no? > > > > r > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan > > Harkins > > Sent: Monday, April 07, 2014 5:59 AM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Fwd: Report's Hide Duplicate property doesn't > > work withall field types? > > > > Wouldn't that hide them all instead of just the duplicates? He wants > > to see the first occurrence. > > > > Susan H. > > > > > > On Mon, Apr 7, 2014 at 8:56 AM, Rocky Smolin <rockysmolin at bchacc.com> > > wrote: > > > > > Or (control name).visible=false? > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan > > > Harkins > > > Sent: Monday, April 07, 2014 5:38 AM > > > To: Access Developers discussion and problem solving > > > Subject: [AccessD] Fwd: Report's Hide Duplicate property doesn't > > > work withall field types? > > > > > > Quick check and it appears to be true. The Attachment field doesn't > > > offer the Hide Duplicates property. Hmmm.... the only alternative > > > that seems reasonable is a subreport. > > > > > > Susan H. > > > > > > > > > A reader recently wrote to me about the Report object's Hide > > > Duplicate property. It worked fine on the query's primary key field -- > a > name. > > > But the query also includes the person's picture, and that's being > > > repeated for each record. She claims the Hide property isn't > > > available. I haven't tested this yet, but thought I'd see if anyone > > > else had run into this and what you did? > > > > > > SUsan H. > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >