[AccessD] Hide Duplicates Not Working

Susan Harkins ssharkins at gmail.com
Thu Jul 2 20:43:44 CDT 2009


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 




More information about the AccessD mailing list