[AccessD] Form Hosed

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




More information about the AccessD mailing list