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

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



More information about the AccessD mailing list