Rocky Smolin
rockysmolin at bchacc.com
Mon Apr 7 09:43:12 CDT 2014
Now I'm not sure - I'd have to look at the app. 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 7:38 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Fwd: Report's Hide Duplicate property doesn't work withall field types? 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com