Hello,
I have a form that seems to corrupt over and over again. I can't open it in
design view, usually getting a message like "There isn't enough memory to
perform this operation. Close unneeded programs and try the operation
again.". I can get to the code but can't seem to do anything to get into
design view. The thing I thought about at first was the number of controls
on the form; there are about 320 controls, but that is still about half of
the Access limit of 754. I also removed about 120 text boxes and placed
them in a subform to reduce the number of controls on the main form. Any
idea what might be causing this problem? at this point, I feel like I'm
spinning my wheels, because I have to keep restoring from a previous
version, then modify and hopefully save a copy before the form corrupts
again. One thing I should add, is the corruption only happens when I'm
modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks!
Rick 8 2385
Rico wrote:
Hello,
I have a form that seems to corrupt over and over again. I can't open it in
design view, usually getting a message like "There isn't enough memory to
perform this operation. Close unneeded programs and try the operation
again.". I can get to the code but can't seem to do anything to get into
design view. The thing I thought about at first was the number of controls
on the form; there are about 320 controls, but that is still about half of
the Access limit of 754. I also removed about 120 text boxes and placed
them in a subform to reduce the number of controls on the main form. Any
idea what might be causing this problem? at this point, I feel like I'm
spinning my wheels, because I have to keep restoring from a previous
version, then modify and hopefully save a copy before the form corrupts
again. One thing I should add, is the corruption only happens when I'm
modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks!
Rick
1)Try copying the form in the current database and try editing the copy.
2)Try importing the form into a clean database, that has any source
tables and queries defined.
3) Try saving the sub form and then replacing it with a very simple
subform - to see if that can be edited.
4) After recovering from a previous version, what edits do you do to the
form? After these edits are you EVER able to edit it?
Bob
remember that the 754 limit is life-span
it might be an idea to export the form (using application.sav eastext) &
importing
(application.lo adfromtext)
Pieter
"Rico" <me@you.comwrot e in message news:BkPQi.1442 4$G25.2918@edtn ps89...
Hello,
I have a form that seems to corrupt over and over again. I can't open it
in design view, usually getting a message like "There isn't enough memory
to perform this operation. Close unneeded programs and try the operation
again.". I can get to the code but can't seem to do anything to get into
design view. The thing I thought about at first was the number of
controls on the form; there are about 320 controls, but that is still
about half of the Access limit of 754. I also removed about 120 text
boxes and placed them in a subform to reduce the number of controls on the
main form. Any idea what might be causing this problem? at this point, I
feel like I'm spinning my wheels, because I have to keep restoring from a
previous version, then modify and hopefully save a copy before the form
corrupts again. One thing I should add, is the corruption only happens
when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks!
Rick
Rico wrote:
Hello,
I have a form that seems to corrupt over and over again. I can't open it in
design view, usually getting a message like "There isn't enough memory to
perform this operation. Close unneeded programs and try the operation
again.". I can get to the code but can't seem to do anything to get into
design view. The thing I thought about at first was the number of controls
on the form; there are about 320 controls, but that is still about half of
the Access limit of 754. I also removed about 120 text boxes and placed
them in a subform to reduce the number of controls on the main form. Any
idea what might be causing this problem? at this point, I feel like I'm
spinning my wheels, because I have to keep restoring from a previous
version, then modify and hopefully save a copy before the form corrupts
again. One thing I should add, is the corruption only happens when I'm
modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks!
Rick
Along with the other's comments...some times I open the "corrupt" form
and create a new form and select all controls on the bad form and do and
Edit/Copy from the bad form and Edit/Paste to the new form. Then copy
in the code. Then save the new form, delete the old.
That would work if I could open the form in design view. ;)
"Salad" <oi*@vinegar.co mwrote in message
news:13******** *****@corp.supe rnews.com...
Rico wrote:
>Hello,
I have a form that seems to corrupt over and over again. I can't open it in design view, usually getting a message like "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.". I can get to the code but can't seem to do anything to get into design view. The thing I thought about at first was the number of controls on the form; there are about 320 controls, but that is still about half of the Access limit of 754. I also removed about 120 text boxes and placed them in a subform to reduce the number of controls on the main form. Any idea what might be causing this problem? at this point, I feel like I'm spinning my wheels, because I have to keep restoring from a previous version, then modify and hopefully save a copy before the form corrupts again. One thing I should add, is the corruption only happens when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks! Rick
Along with the other's comments...some times I open the "corrupt" form and
create a new form and select all controls on the bad form and do and
Edit/Copy from the bad form and Edit/Paste to the new form. Then copy in
the code. Then save the new form, delete the old.
I tried SaveAsText but the app craps out before saving.
"Pieter Wijnen"
<it************ *************** *************** *************** *@online.replac e.with.norway>
wrote in message news:OZ******** ******@TK2MSFTN GP02.phx.gbl...
remember that the 754 limit is life-span
it might be an idea to export the form (using application.sav eastext) &
importing
(application.lo adfromtext)
Pieter
"Rico" <me@you.comwrot e in message news:BkPQi.1442 4$G25.2918@edtn ps89...
>Hello,
I have a form that seems to corrupt over and over again. I can't open it in design view, usually getting a message like "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.". I can get to the code but can't seem to do anything to get into design view. The thing I thought about at first was the number of controls on the form; there are about 320 controls, but that is still about half of the Access limit of 754. I also removed about 120 text boxes and placed them in a subform to reduce the number of controls on the main form. Any idea what might be causing this problem? at this point, I feel like I'm spinning my wheels, because I have to keep restoring from a previous version, then modify and hopefully save a copy before the form corrupts again. One thing I should add, is the corruption only happens when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks! Rick
Hi Bob,
Thanks for your advice. I wound up recreating the entire form from scratch,
one control at a time, but, to answer your question;
4) After recovering from a previous version, what edits do you do to the
form? After these edits are you EVER able to edit it?
All I was doing was trying to add a new combo box. after adding and saving
the form, I haven't been able to open it.
Rick
"Bob Alston" <bo********@yah oo.comwrote in message
news:6r******** *****@newsfe02. lga...
Rico wrote:
>Hello,
I have a form that seems to corrupt over and over again. I can't open it in design view, usually getting a message like "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.". I can get to the code but can't seem to do anything to get into design view. The thing I thought about at first was the number of controls on the form; there are about 320 controls, but that is still about half of the Access limit of 754. I also removed about 120 text boxes and placed them in a subform to reduce the number of controls on the main form. Any idea what might be causing this problem? at this point, I feel like I'm spinning my wheels, because I have to keep restoring from a previous version, then modify and hopefully save a copy before the form corrupts again. One thing I should add, is the corruption only happens when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks! Rick
1)Try copying the form in the current database and try editing the copy.
2)Try importing the form into a clean database, that has any source tables
and queries defined.
3) Try saving the sub form and then replacing it with a very simple
subform - to see if that can be edited.
4) After recovering from a previous version, what edits do you do to the
form? After these edits are you EVER able to edit it?
Bob
Rico wrote:
Hi Bob,
Thanks for your advice. I wound up recreating the entire form from scratch,
one control at a time, but, to answer your question;
>4) After recovering from a previous version, what edits do you do to the form? After these edits are you EVER able to edit it?
All I was doing was trying to add a new combo box. after adding and saving
the form, I haven't been able to open it.
Rick
"Bob Alston" <bo********@yah oo.comwrote in message
news:6r******** *****@newsfe02. lga...
>Rico wrote:
>>Hello,
I have a form that seems to corrupt over and over again. I can't open it in design view, usually getting a message like "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.". I can get to the code but can't seem to do anything to get into design view. The thing I thought about at first was the number of controls on the form; there are about 320 controls, but that is still about half of the Access limit of 754. I also removed about 120 text boxes and placed them in a subform to reduce the number of controls on the main form. Any idea what might be causing this problem? at this point, I feel like I'm spinning my wheels, because I have to keep restoring from a previous version, then modify and hopefully save a copy before the form corrupts again. One thing I should add, is the corruption only happens when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks! Rick
1)Try copying the form in the current database and try editing the copy.
2)Try importing the form into a clean database, that has any source tables and queries defined.
3) Try saving the sub form and then replacing it with a very simple subform - to see if that can be edited.
4) After recovering from a previous version, what edits do you do to the form? After these edits are you EVER able to edit it?
Bob
So is it now working OK? If so the problem was probably the lifetime
max on controls. A way around this is to copy the form, delete the
original then rename the copy. works slick. works for tables also.
bob
Can you import the corrupted form into a new blank database? Just that form,
nothing else?
If you can't then i'd give up. If it won't import I'd call it corrupted
beyond repair. Rebuild it from scratch or a usable backup (a backup version
carries a reoccurance risk however, so be careful..).
If you can import it, and can also open it in design view, then the import
*may* have fixed it & you can import all other objects into the new mdb file
and move forward.
HTH,
"Rico" <me@you.comwrot e in message news:8Z5Ri.1519 5$G25.4600@edtn ps89...
That would work if I could open the form in design view. ;)
"Salad" <oi*@vinegar.co mwrote in message
news:13******** *****@corp.supe rnews.com...
>Rico wrote:
>>Hello,
I have a form that seems to corrupt over and over again. I can't open it in design view, usually getting a message like "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.". I can get to the code but can't seem to do anything to get into design view. The thing I thought about at first was the number of controls on the form; there are about 320 controls, but that is still about half of the Access limit of 754. I also removed about 120 text boxes and placed them in a subform to reduce the number of controls on the main form. Any idea what might be causing this problem? at this point, I feel like I'm spinning my wheels, because I have to keep restoring from a previous version, then modify and hopefully save a copy before the form corrupts again. One thing I should add, is the corruption only happens when I'm modifying the design.
Any help or direction on this issue would be greatly appreciated.
Thanks! Rick
Along with the other's comments...some times I open the "corrupt" form and create a new form and select all controls on the bad form and do and Edit/Copy from the bad form and Edit/Paste to the new form. Then copy in the code. Then save the new form, delete the old. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Trevor Best |
last post by:
Access 2002 MDB -> SQL Server 2000 - ODBC Linked tables.
B4 we start, this is not occurring in a recordset operation and yes I
googled, even found my own fix, which I already use
(http://tinyurl.com/2e8os) but in one particular form it's getting
worse, sometimes accompanied by a "Another user has modified the data"
or something or that the...
|
by: lsloan |
last post by:
Hi!
I have a reoccuring problem with one of my databases where forms will
occasionally become corrupted. Since I have backup copies of my
production databases, it is easy to recover from using the 'standard'
methodology discussed in the various threads that address this issue.
However, I would like to prevent the problem from happening in...
|
by: Chris Dunaway |
last post by:
I was working on a Windows Forms app. The main form had a tab control, a
number of tabs with labels and buttons, etc. It is a new project so not
much work has been completed yet.
I added an app.config file to the project and then added appSettings
section to the file as shown below:
<?xml version="1.0" encoding="utf-8" ?>...
|
by: Marc Gravell |
last post by:
Aaarrggghhh! Maybe I've just got lucky, but until now I haven't had such a
seemingly unrecoverable form corruption error...
I have a reasonably complex form (data-binding to sub-controls, events,
etc), which was working fine... until about an hour ago... Now, although the
form works fine when playing the app, whenever I go into the form...
|
by: Deano |
last post by:
I'm having this problem when closing a form that I really don't think should
be happening;
This is the last section of code in the afterupdate of a combo box in form
frm_Agency;
DoCmd.openform stDocName
DoCmd.Close acForm, "frm_Agency"
| |
by: Dave G |
last post by:
Since upgrading one of my clients from A97/W2000 to A2003/XP they have
suffered no end of data corruption problems, mainly involving one of
the main tables. The corruption can result in one record's fields
turning into chinese characters. On running the compact/repair I can
see that the corruption may be deeper than I expected because...
|
by: Phil Powell |
last post by:
Requirement is to refresh a page in the form of a continual form
submittal (for server-side validation and action)
Here is the Javascript I came up with that I thought would do that:
<script type="text/javascript">
function generateForm() {
document.forms.elements.name = 'username';
document.forms.elements.type = 'hidden';...
|
by: dbagirltx |
last post by:
We have done some testing with mixed and forgotten results. So I'm
hoping that asking here can clarify some issues for us. Right now we do
one weekly warm backup. Throughout the week there are multiple
unrecoverable loads. We are tyring to come up with the best backup
strategy for this system? It is a large dev data warehouse.
What...
|
by: =?Utf-8?B?UHVjY2E=?= |
last post by:
Hi, I'm using VS2005 and .net 2.0. I'm creating an application that has 3
forms. I want allow users to move forward and backward with the forms and
retain the data users have entered. I thought I'll make the inactive forms
invisible but this is creating a memory corruption problem when user close
the form2 or form3 and not the formMain.
...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |