Max Wanadoo
max.wanadoo at gmail.com
Sun Jul 19 14:58:57 CDT 2009
My pleasure. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 19 July 2009 20:52 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed Holy air code, batman! You've done it! Saved my bacon. T&R (thanks and regards) Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Sunday, July 19, 2009 11:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed You can reverse the function, Application.loadfromtext acForm, "frmNameYouWant","pathandnameoftextfile" acForm can be replaced with any of the access object types to export and import - this is the essence of EATBloat What is T&R? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 19 July 2009 19:42 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed I did it from the File-->Export menu in the database container. And got the 'Not enough memory...' error. I'll try from a new form and see what happens. OK, it exported and I can see it in the txt file. Now how do I get it back in? T&R Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Sunday, July 19, 2009 9:19 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed Hmm, that is not sound too good then Rocky. Just to confirm, the exporting should be something like: Application.saveastext,acForm,"frmNameAsString","SaveToText.txtAsString" What error did this throw up? Max Ps. Air code -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 19 July 2009 17:04 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed Exporting form as text failed. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Sunday, July 19, 2009 8:56 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Hosed Try exporting it as text and then reimporting it. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 19 July 2009 16:48 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Form Hosed Dear List: I have a form that got hosed during design. Sure would like to get it back. It can open in form view but won't go to design view. Says 'Not enough memory to complete operation...' but I know that's not the problem. When compact and repair, decompile, and export form as text all fail, is there any other alternative to recovering this form? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.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 -- 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