VBA, Access hangs when opening VBA Code window

Access hangs when opening VBA Code window

Author	Message
RzB #1 / 10	Access hangs when opening VBA Code window I have a seroius problem that has occurred out of the blue! I am unable to open the VBA Code window. OK - first question what did you change... Nuffin - honest.. Not that I can remember anyway... One day it was working - next day NBG. I have uninstalled Office and reinstalled Office and reinstalled Office Developer and still NBG. Access opens fine. If I try to open the VBA window CPU usage goes to 100 percent and Access won't respond and it just hangs.... I have tried with existing Dbs and with a new empty Db - same effect.... The only change to the system I have made recently is to upgrade my graphics card from a Matrox 450 to a Matrox Parhelia. However it has been working fine with this new card for a couple of days... I am running dual monitors... Windows XP, Office Developer Edition 2002.... Anyone any ideas? Many thanks, Roy
Mon, 27 Jun 2005 04:44:53 GMT

David Muelle #2 / 10	Access hangs when opening VBA Code window Roy, A VBA code window from a module or form or both? I guess you're talking about all/any VBA code window? I would guess that you have an invalid reference or activex control on a form?!? There are some options in the Tools \| Options \| Module that I honestly don't think will change anything but I'm not sure. Not much help, huh? David Quote: >-----Original Message----- >I have a seroius problem that has occurred out of the blue! I am >unable to open the VBA Code window. OK - first question >what did you change... Nuffin - honest.. Not that I can remember >anyway... One day it was working - next day NBG. >I have uninstalled Office and reinstalled Office and reinstalled >Office Developer and still NBG. >Access opens fine. If I try to open the VBA window CPU usage >goes to 100 percent and Access won't respond and it just hangs.... >I have tried with existing Dbs and with a new empty Db - same effect.... >The only change to the system I have made recently is to >upgrade my graphics card from a Matrox 450 to a Matrox Parhelia. >However it has been working fine with this new card for a couple >of days... I am running dual monitors... >Windows XP, Office Developer Edition 2002.... >Anyone any ideas? >Many thanks, >Roy >.
Tue, 28 Jun 2005 02:02:48 GMT

RzB #3 / 10	Access hangs when opening VBA Code window David, Many thanks for your response... Yes - any route into VBA causes a hang... It's not an invalid ref.... I can open a new Blank db and try to create a new module. This will cause it to hang.... Tools\|Options\|Module ? In the Access window if I go to Tools\|Options I don't have a module tab? Is this telling me something? I have gleaned nothing from the Event logs other than it is the MSACCESS.EXE that is{filter}.... I think I will try uninstalling Office again - There seems to be no way to (uninstall the developer tools). However I think I saw reference to an MS utility that should be used when uninstalling Office that clears out all the remnants ... I didn't use that before -- we shall see if that helps - if not it looks like a WinXP reinstall.... Not unreasonable - haven't done that for at least a couple of months.....:-) Many thanks, Roy Quote: > Roy, > A VBA code window from a module or form or both? I guess > you're talking about all/any VBA code window? > I would guess that you have an invalid reference or > activex control on a form?!? > There are some options in the Tools \| Options \| Module > that I honestly don't think will change anything but I'm > not sure. > Not much help, huh? > David
Tue, 28 Jun 2005 03:52:46 GMT

RzB #4 / 10	Access hangs when opening VBA Code window OK, OK - I found the Developer Tools uninstall... :-) What I can't find is the Office Uninstall Utility that clears out all the remnants... Am I dreaming... I know I saw a reference to it somewhere.... Anyone any ideas ........... Thanks, Roy Quote: > David, > Many thanks for your response... > Yes - any route into VBA causes a hang... > It's not an invalid ref.... I can open a new Blank db and try to create a new > module. This will cause it to hang.... > Tools\|Options\|Module ? In the Access window if I go to Tools\|Options I don't > have a module tab? Is this telling me something? > I have gleaned nothing from the Event logs other than it is the MSACCESS.EXE > that is{filter}.... I think I will try uninstalling Office again - There seems > to be no way to (uninstall the developer tools). However I think I saw reference > to an MS utility that should be used when uninstalling Office that clears out > all the remnants ... I didn't use that before -- we shall see if that helps - if > not it looks like a WinXP reinstall.... Not unreasonable - haven't done that for > at least a couple of months.....:-) > Many thanks, > Roy > > Roy, > > A VBA code window from a module or form or both? I guess > > you're talking about all/any VBA code window? > > I would guess that you have an invalid reference or > > activex control on a form?!? > > There are some options in the Tools \| Options \| Module > > that I honestly don't think will change anything but I'm > > not sure. > > Not much help, huh? > > David
Tue, 28 Jun 2005 04:16:56 GMT

RzB #5 / 10	Access hangs when opening VBA Code window Reinstalled Windows XP - Over current install... Did not fix the problem... Now what - format... and start from scratch :-( Not at all happy....:-( Roy Quote: > OK, OK - I found the Developer Tools uninstall... :-) > What I can't find is the Office Uninstall Utility that clears out all the > remnants... > Am I dreaming... I know I saw a reference to it somewhere.... > Anyone any ideas ........... > Thanks, > Roy > > David, > > Many thanks for your response... > > Yes - any route into VBA causes a hang... > > It's not an invalid ref.... I can open a new Blank db and try to create a new > > module. This will cause it to hang.... > > Tools\|Options\|Module ? In the Access window if I go to Tools\|Options I don't > > have a module tab? Is this telling me something? > > I have gleaned nothing from the Event logs other than it is the MSACCESS.EXE > > that is{filter}.... I think I will try uninstalling Office again - There seems > > to be no way to (uninstall the developer tools). However I think I saw > reference > > to an MS utility that should be used when uninstalling Office that clears out > > all the remnants ... I didn't use that before -- we shall see if that helps - > if > > not it looks like a WinXP reinstall.... Not unreasonable - haven't done that > for > > at least a couple of months.....:-) > > Many thanks, > > Roy > > > Roy, > > > A VBA code window from a module or form or both? I guess > > > you're talking about all/any VBA code window? > > > I would guess that you have an invalid reference or > > > activex control on a form?!? > > > There are some options in the Tools \| Options \| Module > > > that I honestly don't think will change anything but I'm > > > not sure. > > > Not much help, huh? > > > David
Tue, 28 Jun 2005 06:20:06 GMT

Dirk Goldga #6 / 10	Access hangs when opening VBA Code window Have you tried importing all objects into a new database? I wonder if this could be the problem that turns up if you don't close code windows as you go along, so you end up with so many windows open in the VB Editor that it crashes. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Quote: > Reinstalled Windows XP - Over current install... Did not fix the problem... > Now what - format... and start from scratch :-( > Not at all happy....:-( > Roy > > OK, OK - I found the Developer Tools uninstall... :-) > > What I can't find is the Office Uninstall Utility that clears out all the > > remnants... > > Am I dreaming... I know I saw a reference to it somewhere.... > > Anyone any ideas ........... > > Thanks, > > Roy > > > David, > > > Many thanks for your response... > > > Yes - any route into VBA causes a hang... > > > It's not an invalid ref.... I can open a new Blank db and try to create a > new > > > module. This will cause it to hang.... > > > Tools\|Options\|Module ? In the Access window if I go to Tools\|Options I don't - Hide quoted text - - Show quoted text - Quote: > > > have a module tab? Is this telling me something? > > > I have gleaned nothing from the Event logs other than it is the MSACCESS.EXE > > > that is{filter}.... I think I will try uninstalling Office again - There > seems > > > to be no way to (uninstall the developer tools). However I think I saw > > reference > > > to an MS utility that should be used when uninstalling Office that clears > out > > > all the remnants ... I didn't use that before -- we shall see if that > helps - > > if > > > not it looks like a WinXP reinstall.... Not unreasonable - haven't done that > > for > > > at least a couple of months.....:-) > > > Many thanks, > > > Roy > > > > Roy, > > > > A VBA code window from a module or form or both? I guess > > > > you're talking about all/any VBA code window? > > > > I would guess that you have an invalid reference or > > > > activex control on a form?!? > > > > There are some options in the Tools \| Options \| Module > > > > that I honestly don't think will change anything but I'm > > > > not sure. > > > > Not much help, huh? > > > > David
Tue, 28 Jun 2005 07:01:32 GMT

Dirk Goldga #7 / 10	Access hangs when opening VBA Code window This KB article discusses the problem I'm talking about: http://www.--.com/ ;en-us;223235 -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Quote: > Have you tried importing all objects into a new database? I wonder if > this could be the problem that turns up if you don't close code > windows as you go along, so you end up with so many windows open in > the VB Editor that it crashes. > -- > Dirk Goldgar, MS Access MVP > www.datagnostics.com > (please reply to the newsgroup) > > Reinstalled Windows XP - Over current install... Did not fix the > problem... > > Now what - format... and start from scratch :-( > > Not at all happy....:-( > > Roy > > > OK, OK - I found the Developer Tools uninstall... :-) > > > What I can't find is the Office Uninstall Utility that clears out > all the > > > remnants... > > > Am I dreaming... I know I saw a reference to it somewhere.... > > > Anyone any ideas ........... > > > Thanks, > > > Roy > > > > David, > > > > Many thanks for your response... > > > > Yes - any route into VBA causes a hang... > > > > It's not an invalid ref.... I can open a new Blank db and try to > create a > > new > > > > module. This will cause it to hang.... > > > > Tools\|Options\|Module ? In the Access window if I go to > Tools\|Options I don't > > > > have a module tab? Is this telling me something? > > > > I have gleaned nothing from the Event logs other than it is the > MSACCESS.EXE > > > > that is{filter*}.... I think I will try uninstalling Office > again - There > > seems > > > > to be no way to (uninstall the developer tools). However I think > I saw > > > reference > > > > to an MS utility that should be used when uninstalling Office > that clears > > out > > > > all the remnants ... I didn't use that before -- we shall see if > that > > helps - > > > if > > > > not it looks like a WinXP reinstall.... Not unreasonable - > haven't done that > > > for > > > > at least a couple of months.....:-) > > > > Many thanks, > > > > Roy > > > > > Roy, > > > > > A VBA code window from a module or form or both? I guess > > > > > you're talking about all/any VBA code window? > > > > > I would guess that you have an invalid reference or > > > > > activex control on a form?!? > > > > > There are some options in the Tools \| Options \| Module > > > > > that I honestly don't think will change anything but I'm > > > > > not sure. > > > > > Not much help, huh? > > > > > David
Tue, 28 Jun 2005 07:06:13 GMT

RzB #8 / 10	Access hangs when opening VBA Code window Dirk, Thanks for the response.... No - that's not the problem... It happens even when I have a new, blank database.... I am resorting to a reformat then reinstall of Windows :-) Must be a screwed up registry.... or summat.. Roy Quote: > This KB article discusses the problem I'm talking about: > http://www.--.com/ ;en-us;223235 > -- > Dirk Goldgar, MS Access MVP > www.datagnostics.com > (please reply to the newsgroup) > > Have you tried importing all objects into a new database? I wonder > if > > this could be the problem that turns up if you don't close code > > windows as you go along, so you end up with so many windows open in > > the VB Editor that it crashes. > > -- > > Dirk Goldgar, MS Access MVP > > www.datagnostics.com > > (please reply to the newsgroup) > > > Reinstalled Windows XP - Over current install... Did not fix the > > problem... > > > Now what - format... and start from scratch :-( > > > Not at all happy....:-( > > > Roy > > > > OK, OK - I found the Developer Tools uninstall... :-) > > > > What I can't find is the Office Uninstall Utility that clears > out > > all the > > > > remnants... > > > > Am I dreaming... I know I saw a reference to it somewhere.... > > > > Anyone any ideas ........... > > > > Thanks, > > > > Roy > > > > > David, > > > > > Many thanks for your response... > > > > > Yes - any route into VBA causes a hang... > > > > > It's not an invalid ref.... I can open a new Blank db and try > to > > create a > > > new > > > > > module. This will cause it to hang.... > > > > > Tools\|Options\|Module ? In the Access window if I go to > > Tools\|Options I don't > > > > > have a module tab? Is this telling me something? > > > > > I have gleaned nothing from the Event logs other than it is > the > > MSACCESS.EXE > > > > > that is{filter*}.... I think I will try uninstalling Office > > again - There > > > seems > > > > > to be no way to (uninstall the developer tools). However I > think > > I saw > > > > reference > > > > > to an MS utility that should be used when uninstalling Office > > that clears > > > out > > > > > all the remnants ... I didn't use that before -- we shall see > if > > that > > > helps - > > > > if > > > > > not it looks like a WinXP reinstall.... Not unreasonable - > > haven't done that > > > > for > > > > > at least a couple of months.....:-) > > > > > Many thanks, > > > > > Roy > > > > > > Roy, > > > > > > A VBA code window from a module or form or both? I guess > > > > > > you're talking about all/any VBA code window? > > > > > > I would guess that you have an invalid reference or > > > > > > activex control on a form?!? > > > > > > There are some options in the Tools \| Options \| Module > > > > > > that I honestly don't think will change anything but I'm > > > > > > not sure. > > > > > > Not much help, huh? > > > > > > David
Wed, 29 Jun 2005 03:33:26 GMT

Dirk Goldga #9 / 10	Access hangs when opening VBA Code window Quote: > Dirk, > Thanks for the response.... > No - that's not the problem... It happens even when I have a new, blank > database.... > I am resorting to a reformat then reinstall of Windows :-) > Must be a screwed up registry.... or summat.. > Roy Ugh! Good luck with it. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
Wed, 29 Jun 2005 04:21:08 GMT

RzB #10 / 10	Access hangs when opening VBA Code window Dirk, I think "Ugh!" is very descriptive and captures exactly how I feel.... Interestingly I did a search on Google and found that someone in 2000 had exactly the same problem and posted to this group... However he got zero responses... I am now resigned to format / reinstall of windows... Not happy.. Not at all happy... in fact Ugh!... :-) Roy Quote: > > Dirk, > > Thanks for the response.... > > No - that's not the problem... It happens even when I have a new, > blank > > database.... > > I am resorting to a reformat then reinstall of Windows :-) > > Must be a screwed up registry.... or summat.. > > Roy > Ugh! Good luck with it. > -- > Dirk Goldgar, MS Access MVP > www.datagnostics.com > (please reply to the newsgroup)
Wed, 29 Jun 2005 07:14:42 GMT

Page 1 of 1

[ 10 post ]