Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by Last user''''s name that modified a reco, Oct 27, 2005.

  1. 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
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Eternal Sunshine of the Bionic Mind: Prosthesis Could Restore Memory Breaking News Jun 24, 2013
    Canada Sikh Nation’s Annual Blood Drive Aims To Keep Alive Memory Of Innocent Sikhs Murdered In India Breaking News Oct 28, 2012
    Sikh Foundation The Sikh Foundation and the Memory of 1984 Outrage Sikh Organisations Jul 12, 2011
    In memory of Gurmail Singh Interfaith Dialogues Jun 10, 2011
    A Novel Way to Improve Memory Business, Lifestyle & Leisure Nov 14, 2010

  3. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    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"
    <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in message
    news:54886C49-BCC6-49AF-B0CA-7708D259F906@microsoft.com...
    > 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
     
  4. 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" wrote:

    > 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"
    > <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in message
    > news:54886C49-BCC6-49AF-B0CA-7708D259F906@microsoft.com...
    > > 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

    >
    >
    >
     
  5. Wayne Morgan

    Wayne Morgan
    Expand Collapse
    Guest

    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"
    <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in message
    news:3C82434A-ABFD-46F3-8D7F-5889BC633B55@microsoft.com...
    > 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" wrote:
    >
    >> 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"
    >> <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in
    >> message
    >> news:54886C49-BCC6-49AF-B0CA-7708D259F906@microsoft.com...
    >> > 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

    >>
    >>
    >>
     
  6. hi, Wayne! Good morning!

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

    Thank you very much!

    Resty

    "Wayne Morgan" wrote:

    > 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"
    > <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in message
    > news:3C82434A-ABFD-46F3-8D7F-5889BC633B55@microsoft.com...
    > > 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" wrote:
    > >
    > >> 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"
    > >> <Lastusersnamethatmodifiedareco@discussions.microsoft.com> wrote in
    > >> message
    > >> news:54886C49-BCC6-49AF-B0CA-7708D259F906@microsoft.com...
    > >> > 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
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page