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

Susan Harkins ssharkins at gmail.com
Mon Apr 7 08:19:16 CDT 2014


I'm hanging on to this -- might be needed. :) Thanks Stuart!

Susan H.


On Mon, Apr 7, 2014 at 9:09 AM, Stuart McLachlan <stuart.mclachlan at gmail.com
> wrote:

> Aircode:
>
> Private strName as string
> ....
>
> Sub Detail_Format(...)
> If FormatCount = 1
>         if me!PersonName = strname then
>                 myimage.visible = false
>         else
>                 myimage.visible = true
>         end if
>         strName = me!PersonName
> End if
> ..
> End Sub
>
> On 7 Apr 2014 at 8:59, Susan Harkins wrote:
>
> > 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
>


More information about the AccessD mailing list