Max Wanadoo
max.wanadoo at gmail.com
Thu Feb 18 09:40:59 CST 2010
Hi Dan, It is 64K size limited. Have a look here: http://support.microsoft.com/kb/79055 Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 18 February 2010 14:36 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers Do you know how many objects it takes to cause problems with a list box? I'd guess it must be more than a hundred ... Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, February 18, 2010 8:23 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers Duh, I know that Dan... The point is that if they select "Select" you have to populate it with all the objects. Therein lies the rub. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 18 February 2010 14:18 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers Hi Max, In that case the developer can select All for each object type. That puts only one line in the list box for each object type, and the code will loop through the list of all the objects. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Wednesday, February 17, 2010 1:54 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] New Export As Text (EAT) Form - Need Beta Testers Well done Dan, I haven't looked at it yet (but I will) but I just wanted to point out a shortcoming that John Colby came up with on my original one with regards to the List Boxes. Basically, the List box has a limitation as to how much "stuff" you can get in there. On very large systems with lots of objects the ListBox dies. Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 17 February 2010 17:43 To: 'Access Developers discussion and problem solving' Subject: [AccessD] New Export As Text (EAT) Form - Need Beta Testers Good Morning! I've mentioned a few times that I was working on upgrading Max's EATBloat form (having started last year!). This is a significant change: There are 2 listboxes to quickly manage the objects to be exported. The objects are all exported to the same export folder, which is date and time stamped. The text files have prefix names to correspond with which type of object it is so you can quickly select what you want to import. You can quickly include or exclude linked tables. I have only used this in Access 2003. I have not tried to use this yet with any database other than the Current Database. To get a copy: http://www.promationsystems.com/databaseadvisors.htm Download the EAT.pdf file, and then change the extension to .mdb. Then place the single form, frmEAT, into your database. Please review the pages titled About, Steps, and Notes. If you have some ideas or find some problems please respond using my email address at dwaters at usinternet.com. Thanks! Dan -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com