How to edit the VBA code in Visual Studio?

[anniebai]

Is there a way to view/edit VBA code through Visual Studio 2005? I've installed VSTO, It works for word/excel/powerpoint, but don't know how to get Access VBA code opened in VS.
I used to use the middle button of mouse to scroll down pages of code, however, Access code editor doesn't support this, I have to drag the scroll bar to get down to the page. which sounds minor but drives me crazy.
Your suggestions and inputs are highly appreciated.

[NeoPa]

I think Access 2003 and onwards have this functionality as standard now Annie, but download VBScroll using http://www.gasanov.net/Donation.asp?VBScroll.zip to fix it for all previous versions anyway. http://www.gasanov.net/VBScroll.asp gives a short explanation and some other useful links.

[anniebai]

Thank you so much, NeoPa. It works perfectly.
I am using office 2003. Now i start wondering how come the standard is not standard on my machine :-(

[NeoPa]

No worries Annie.

I'm not positive it's 2003 that it's fixed in. I know it is in Access 2007 though. I doubt I'll ever play with A2007 though. I'll wait for a decent version to come out. I still use VBScroll on my home PC though which runs A2003.

PS. Congratulations on achieving full member status :)

[missinglinq]

Yes it was v2003, NeoPa, and I'm so glad I saw your post! I'd didn't realize the problem had been fixed, and being used to scrolling the old fashioned way, had just continued to do so when I upgraded from v2000!

Linq ;0)>

[NeoPa]

Well, I'm very pleased I was some help then :)

I still have A2000 at work, so VBScroll is still used here.

[anniebai]

Ya, I am hesitate to A2007 too.
Do you guys know how to make VBScroll as a startup service so there's no need to manually turn it on?

[NeoPa]

I have simply added a shortcut to the program in my Startup folder. Works like a treat :)