MarkH
lists at theopg.com
Wed Jan 21 09:38:40 CST 2004
I have some code which works ok. It's a bit tricky as there are limits on how many connections etc. you can have which restricts the number of screens you can open. Also you have to be careful how you refer to the form as its name is no longer reliable when multiple instances are open. I used the hwnd value. If you want I can send some code but it will take a while as my main box is completely dead - maybe a psu failure, maybe mobo... Will be fixing that first I hope... Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: 20 January 2004 21:02 To: Access Developers discussion and problem solving Subject: RE: [AccessD] Instantiate Forms as Objects I don't generally do it at all, so I would have to dig back into my archives to see how I did it last time. I seem to recall using a collection and a custom class, but I haven't done it in several years, so my memory is dusty. Charlotte Foust -----Original Message----- From: Ken Ismert [mailto:KIsmert at TexasSystems.com] Sent: Tuesday, January 20, 2004 11:49 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Instantiate Forms as Objects So, how do you get muliple instances of the same form open without using the "Set rFrm = New Form_YourForm" syntax? -Ken -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Tuesday, January 20, 2004 10:42 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Instantiate Forms as Objects Maybe JC knows differently, but as far as I know, you can't do it that way, which is one of the reasons I don't use that syntax. Charlotte Foust _______________________________________________ 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