By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

How to edit the VBA code in Visual Studio?

P: 51
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.
May 28 '08 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,494
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.
May 29 '08 #2

P: 51
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 :-(
May 29 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
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 :)
May 29 '08 #4

missinglinq
Expert 2.5K+
P: 3,532
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)>
May 29 '08 #5

NeoPa
Expert Mod 15k+
P: 31,494
Well, I'm very pleased I was some help then :)

I still have A2000 at work, so VBScroll is still used here.
May 30 '08 #6

P: 51
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?
May 30 '08 #7

NeoPa
Expert Mod 15k+
P: 31,494
I have simply added a shortcut to the program in my Startup folder. Works like a treat :)
Jun 2 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.