"Out of Memory" message when trying to use vba in access 2000

[Last user''''s name that modified a reco]

Hi, guys!

Here I am again and i hope you could help. Thanks for the previous advices.
My problem now is i'm always getting an "Out of Memory" message everytime i
try to put code in Events Procedure in Access forms. My pc has 128mb memory.

Hope you can help me out. thank you very much.

Resty

 

[Wayne Morgan]

Have you installed SP1 for Office 2000? It is actually up to SP3 which you
will also want to install. SP3 fixes a very nasty VBA bug. The SP1 bug fix
is for a memory leak in the graphic converter. It appears if you have a gif
or jpg (don't remember which) file as the background of a form and you go
back and forth between design view and form view. It doesn't take very many
view changes to cause the problem.

What version of Windows are you running? What else is running? Have you
tried importing everything from your current file into a new file and
recompiling?

--
Wayne Morgan
MS Access MVP


"Last user''''s name that modified a reco"

 

[Last user''''s name that modified a reco]

Hi, Wayne. Thank you very much for the reply.

I have installed SP1 and SP2 and i'm running Windows 98. I split my database
and everything was just fine until i added some forms to add more
functionality to my database. i remove my office 2000 and installed it back
again thinking some of my dll's are corrupted or something to that effect.
But it still gives me an "Out of Memory" message. I tried opening it on a
different computer running windows 98 and still get the same error message.

 

[Wayne Morgan]

If you add forms by copying them from another database file without
compiling there is a nasty bug that is fixed in SP3. Have you tried copying
the items from this mdb file into a new, empty mdb file? If you do, be sure
to compile before closing the database or you'll run into the bug fixed in
SP3. If that doesn't help, try importing the items except for the forms you
just added and see if the new mdb file will work.

--
Wayne Morgan
MS Access MVP


"Last user''''s name that modified a reco"

 

[Last user''''s name that modified a reco]

hi, Wayne! Good morning!

Thank you very much for the help. My database is now working.

Thank you very much!

Resty