Prev: Check if folder path exists
Next: How do a get percentile rank of a column?
From: TinMan on 13 May 2010 09:15
Hi Tom, I hope you are still available to help. I have the same problem. A
main form with sub forms. I have tried adding another form but as soon as add
this form to the main form. The main form reports the error. I can't open it
in design view either. If i delete the subform it doesn't cure the error
message. The sub form opens by itself and no problems opening the table. I
have deleted the main formand tried numerous time but same problem. I have
also tried importing all into new db but get the message as the form is
analysed and doesn't import. Can you please help me??!!

"Tom Wickerath" wrote:

> Hi Earl,
>
> First, please ignore the reply that you received from Aaron Kempf. His
> suggestion for *everything* is to upgrade to SQL Server. Oh, but he
> inadvertently failed to mention that SQL Server has no real provisions for
> creating a user interface. Typical Aaron. Just ignore him.
>
> You didn't say which version of Access that you are using, but if you are
> using an unpatched copy of Access 2000, then updating to Service Pack 1 (and
> ultimately to SP3) may solve your problem:
>
> You receive "There isn't enough free memory" error message
> when you work with a Form in Access 2000
> http://support.microsoft.com/kb/236977
>
> Here is another KB article, although this one seems to deal with startup
> errors:
>
> ACC2000: Resolving "System Error or Not Enough Memory to Start"
> Error Messages
> http://support.microsoft.com/kb/217353
>
> If you are not using Access 2000, then you may have one or more corrupt
> forms. The first thing to try is to import all objects into a new database
> container. I give complete instructions for how to do this on the bottom half
> of page 3 of a Word document that I call Access Links. See the section titled
> "My standard advice for attempting to fix minor corruptions". You are welcome
> to download a zipped copy from my web site:
> http://www.accessmvp.com/TWickerath/
>
> If this does not work, then we may be able to recover the affected form(s)
> using a few other methods. I can write more about these other methods if the
> above method does not work for you.
>
>
> Tom Wickerath
> Microsoft Access MVP
> http://www.accessmvp.com/TWickerath/
> http://www.access.qbuilt.com/html/expert_contributors.html
> __________________________________________
>
>
> "EarlCPhillips" wrote:
>
> > I have a Contact Management form for outreach that contains four sub forms.
> > Things worked well until I added the fourth subform. The first three are
> > addresses, phones and email addresses. The fourth is for case histories
> > related to this contact.
> >
> > Now it fails to open even in design mode with the message that there is "not
> > enough memory to open the operation, close other programs to perform this
> > operation." But there are no other operations open.
> >
> > How do I revert to a prior version? Even deleting the fourth subform does
> > not help. Help!
> >
> > EarlCPhillips
> > Volunteer Ex-mainframer Learning Access To Help
> > Local Food Bank Feed the Hungry More Efficiently
> >
> > --
> > Trying To Feed The Hungry
From: Paul Shapiro on 14 May 2010 19:16
If everything BUT that one form imports successfully to a new blank db, that
might be indicating the form is corrupted. Try importing JUST that one form
into a new blank db. If it still fails, you can either try loading an older
version of the form from a backup, or exporting that form to a text file
using the undocumented Application.SaveAsText command:
Application.SaveAsText acForm, "formName", "C:\Path\OutputFile.txt"
and then importing it to a blank db using the equivalent LoadFromText
command. These are the commands used by the Access Sourcesafe integration to
put objects to and from text format.

If that still doesn't work, you can try looking at the .txt file to see if
you can find the problem. Try saving a similar but working form to text and
see if you can find the difference. Might not be so easy.

"TinMan" <TinMan(a)discussions.microsoft.com> wrote in message
news:492F2C9D-5F21-42E4-957F-6E43A0897AEC(a)microsoft.com...
> Hi Tom, I hope you are still available to help. I have the same problem. A
> main form with sub forms. I have tried adding another form but as soon as
> add
> this form to the main form. The main form reports the error. I can't open
> it
> in design view either. If i delete the subform it doesn't cure the error
> message. The sub form opens by itself and no problems opening the table. I
> have deleted the main formand tried numerous time but same problem. I have
> also tried importing all into new db but get the message as the form is
> analysed and doesn't import. Can you please help me??!!
>
> "Tom Wickerath" wrote:
>
>> Hi Earl,
>>
>> First, please ignore the reply that you received from Aaron Kempf. His
>> suggestion for *everything* is to upgrade to SQL Server. Oh, but he
>> inadvertently failed to mention that SQL Server has no real provisions
>> for
>> creating a user interface. Typical Aaron. Just ignore him.
>>
>> You didn't say which version of Access that you are using, but if you are
>> using an unpatched copy of Access 2000, then updating to Service Pack 1
>> (and
>> ultimately to SP3) may solve your problem:
>>
>> You receive "There isn't enough free memory" error message
>> when you work with a Form in Access 2000
>> http://support.microsoft.com/kb/236977
>>
>> Here is another KB article, although this one seems to deal with startup
>> errors:
>>
>> ACC2000: Resolving "System Error or Not Enough Memory to Start"
>> Error Messages
>> http://support.microsoft.com/kb/217353
>>
>> If you are not using Access 2000, then you may have one or more corrupt
>> forms. The first thing to try is to import all objects into a new
>> database
>> container. I give complete instructions for how to do this on the bottom
>> half
>> of page 3 of a Word document that I call Access Links. See the section
>> titled
>> "My standard advice for attempting to fix minor corruptions". You are
>> welcome
>> to download a zipped copy from my web site:
>> http://www.accessmvp.com/TWickerath/
>>
>> If this does not work, then we may be able to recover the affected
>> form(s)
>> using a few other methods. I can write more about these other methods if
>> the
>> above method does not work for you.
>>
>>
>> Tom Wickerath
>> Microsoft Access MVP
>> http://www.accessmvp.com/TWickerath/
>> http://www.access.qbuilt.com/html/expert_contributors.html
>> __________________________________________
>>
>>
>> "EarlCPhillips" wrote:
>>
>> > I have a Contact Management form for outreach that contains four sub
>> > forms.
>> > Things worked well until I added the fourth subform. The first three
>> > are
>> > addresses, phones and email addresses. The fourth is for case
>> > histories
>> > related to this contact.
>> >
>> > Now it fails to open even in design mode with the message that there is
>> > "not
>> > enough memory to open the operation, close other programs to perform
>> > this
>> > operation." But there are no other operations open.
>> >
>> > How do I revert to a prior version? Even deleting the fourth subform
>> > does
>> > not help. Help!
>> >
>> > EarlCPhillips

 | 
Pages: 1
Prev: Check if folder path exists
Next: How do a get percentile rank of a column?