<div>
Hi Professor,<br />
Unfortunately this application is large and very complex. &nbsp;The only way I have been able to share the code in the past was to create a separate DB with just the code I had a problem with. &nbsp;In this case I don't believe that would provide an accurate representation of the issue.<br />
Thanks,<br />
Bob C.
</div>


<div>
Hi Bob,<br />
<br />
i would not understand unless i see that small amount of code.
</div>


<div>
Hi Professor,<br />
The application is for converting the data from one version of the application to another. &nbsp;The .accdb is just over 100 Meg making it difficult to provide the whole application. &nbsp;In addition the data is all in Back End Tables.<br />
<br />
I am attaching a file containing all of the code for this procedure.<br />
<br />
It works correctly if the Code for the following steps is removed.<br />
STEP_4590: to the end of STEP_4599:<br />
<br />
As you can see in STEP_4593: the following line of code needs to be uncommented however as soon as I do this I get the Error 7 Message.<br />
<br />
Thanks.<br />
Bob C.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/01_w02/1066102/Period-Event-Module-Conversion-Code-.txt" target="_blank" class="file-inline" title="Period Event Module Conversion Code - Complete.txt (157 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Period-Event-Module-Conversion-Code-.txt</a>
</div>


Period Event Module Conversion Code - Complete.txt

Period-Event-Module-Conversion-Code-.txt

<div>
Hi Professor,<br />
<br />
Thanks for the confirmation that this code it too large. &nbsp;I had assumed as much.<br />
<br />
I'll leave this open for a couple of days to see if anyone else has comments.<br />
<br />
Thanks again,<br />
Bob C.
</div>


<div>
you are welcome Bob, i am glad i was able to help.
</div>


<div>
Hi Professor,<br />
I would like some additional guidance with regard to doing this. &nbsp;My plan is as follows.<br />
<br />
This application is strictly for data conversion. &nbsp;There are currently four Modules in this application with all of the conversion code for all Modules within the one application.<br />
<br />
My approach will be to split each Module into a separate .accdb containing only the conversion code for that Module. &nbsp;Each Conversion Module .accdb will then be opened, run and closed in sequence from a Master Conversion Application .accdb.<br />
<br />
Each Conversion Module when opened by the Master will execute without User intervention. &nbsp;This will make the individual Modules transparent for the User while I can mange / run them individually for development.<br />
<br />
Does this sound like a good approach?<br />
<br />
Thanks,<br />
Bob C.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I have just run into this error while trying to add another small amount of code to a quite large Procedure.<br />
<br />
If I remove the last code it is ok.<br />
<br />
I have saved it, done a Compact / Repair and I still get the error.<br />
<br />
Is there a way to overcome this error?<br />
<br />
Thanks.<br />
Bob C.
</div>
</div>


Hi Experts,
I have just run into this error while trying to add another small amount of code to a quite large Procedure.

If I remove the last code it is ok.

I have saved it, done a Compact / Repair and I still get the error.

Is there a way to overcome this error?

Thanks.
Bob C.

Windows 7 Pro ACCESS 2010 VBA - Out Of Memory (Error 7)

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.