Another Newbie question about word VBA

[Y2KCobra]

Good Afternoon to all,

I am looking for an example where I create a form in Word 2000 and perform queries to an access database in order to populate list boxes. Does anyone know where I can locat an example and what references do I need enabled in my Word application in order to instantiate an Database object?

Any help would be greatly appreciated

 

[SBendBuckeye]

Assuming you are in Word VBA and want to instantiate an Access instance, try the following:

Dim objAccessApp As Access.Application
Set objAccessApp = GetObject("YourPathAndAccessFile&quot
objAccessApp. <== TO get methods and properties

etc

objAccessApp.Quit
Set objAccessApp = Nothing

Good Luck!

 

[Y2KCobra]

SBendBuckeye,

Thank you for the rapid response. I tried to test at least the instantiation of the access object but could not get VBA to recognize the calls.

Do you know what libaries should be loaded for this to work?

Thanking you in advance,

Steve

 

[SBendBuckeye]

Sorry, in the VB Project editor, open a module and then click Tools, References and then scroll down looking for Microsoft Access x.x Objects, etc.

Sorry I forgot that piece.

Good Luck!

 

[Y2KCobra]

Works Great

Im hitting MS Sql now

Thank you =)