Rocky Smolin
rockysmolin at bchacc.com
Mon Apr 7 09:24:35 CDT 2014
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