Reference - Which VBA To Choose

[jwjw]

I am running W2K and Access2K. I see in the reference section there are at least a half a dozen VBA references I could check. I tried checking multiple ones and it gives me an error message and won't let me. Any suggestions on which to choose? Thanks,

Jack Walsh

 

[JeremyNYC]

Jack,

Choose the latest one available (highest number).

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[jwjw]

Thanks Jeremy but I don't find any version numbers. The VBAs that are listed are c:\winnt\system32\vbaen32.olb,..msvbvm50.dll,..ven2232.olb,..msvbvm60.dll,..vbaend32.olb and c:\program files\commonfiles\microsoft shared\vba\vba332. The one that is checked is c:\program files\commonfiles\microsoft shared\vba\vba6\vb.. I tried to swap the ..vba332 with the ..vba6 but it won't let me.

Jack

 

[Junior1544]

Here's what I have.

Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.1 Library
OLE Automation
Microsoft Office 9.0 Object Library
Microsoft Excel 9.0 Object Library

So, there's just the one for vba... what is it your doing that you are looking for a reference?

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.