Access VBA is crashing

[PhillipsTCasey]

Every time I try to type code into the code editor the second it tries to give suggestions as to what I am going to type next, access crashes.

Example:

When I try to type me.txtName.text

it crashes right when I hit the "." after me.

I have reinstalled Microsoft Office twice, I have done a system restore to when I knew this didn't happen, and I have updated access.

This all started happening when I added a developer extension to access. I have however, already uninstalled it, and restore the system to a point before it was installed.

I am at a loss on this one, can anyone help?

 

[bokarinho]

Does this happen in all access databases?

 

[PhillipsTCasey]

Yes, all previous ones, and even new ones I make.

 

[Khalid_Afridi]

Is there any other VBA code runing behinde while you are in VBA Module, I usually stop all the running codes (do not open forms directly) while working in VBA codes.

 

[bokarinho]

Try running the event viewer to watch if there is any problem there. It might give you a hint. Is there any security issues?

 

[PhillipsTCasey]

I have yet to add code to the database at all, and even then I stopped running all the codes and still no luck.

Bokarinho I am relatively new to access and I don't know what the event viewer is. There are no security issues that I am aware of.

 

[vbaInet]

Try turning off Intellisense and see what happens when you type. From the VBA editor:

TOOLS > OPTIONS > untick AUTO LIST MEMBERS > click OK

FYI: Intellisense is the list of properties/methods/arguments that pop-up as you type.

 

[PhillipsTCasey]

I actually decided to install the 2010 beta version of MSOffice and I seemed to have fixed the problem.

When I downgrade back to 2007 we will see if the problem continues.

Thanks for all the help.

 

[vbaInet]

Most likely a problem with your copy of Access. I hope you don't get to used to the Beta version if you were to use it for real development.

Good luck.