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