IC Macro fails during edit with Out Of Memory error

I built two macros that create IC adjustments for a certain class of items for a client.  Works fine on the system in my office.

I coped the two macros onto the clients server and when i go to edit either macro I'm getting an 'Out of Memory' error.

It allows me to open the macro but not change anything.  The client is on Sage 300 v2017.  SQL 2014

It throws up this window first.

Then this one:

It does NOT allow me to open the user form in the macro.

Anyone seen this before?

Dana

  • 0

    Yes - and this drives me up the wall.

    The problem is that there's a difference in the underlying VBA environment and how each of your environments (where you built it vs where you're deploying it) are handling forms.

    The easiest thing to do is do is on the client's site, edit the macro and remove the form. Save the macro and then re-create the form. You only have to re-create the form because you can copy/paste the code from the copy of the macro on your computer.

  • 0 in reply to Django

    That was the problem.  I rebuilt the forms and it's working now.  PITA!  There were a lot of objects on the forms.  Date fields, Datasources, Field Edits with finders, etc.

    Thanks for the help Django

    Dana