[AccessD] Fwd: Report's Hide Duplicate property doesn't work withall field types?

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



More information about the AccessD mailing list