[AccessD] Hide Duplicates Not Working

Rocky Smolin rockysmolin at bchacc.com
Thu Jul 2 20:50:04 CDT 2009


This is in 2003.  Had the same problem on two other machines and don't have
the problem in other apps, so I think it must be in this mdb.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, July 02, 2009 6:44 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Hide Duplicates Not Working

Ah... you can set it only in Design view... I suppose if you're opening the
report from a form or something, you could consider trying. Why don't you
drop in a Debug.Print that tells you what the HideDuplicates property is --
just to see if Access is even reading the property.

Rocky, I haven't a clue. How about testing a report in another database, or
testing your database in another version????

Do you have Access 2000 on the same system. I read somewhere that it has a
problem with HideDuplicates, but it isn't the same problem -- so I can't
imagine it's the culprit, but if you do have 2000, you might make sure it's
updated.

Susan H.


> "You can't assign a value to this object" if I try that.
>
> Rocky
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan 
> Harkins
> Sent: Thursday, July 02, 2009 5:05 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Hide Duplicates Not Working
>
> Rocky, try setting the property in the report's Open or Load event, 
> instead of setting the property manually. I've never done that, so I'm 
> not totally sure you can do that, but I don't know why you couldn't.
>
> Susan H.
>
>
>> No soap on the import.  Now I'm getting worried.  What could it be?
>
> --
> 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