References question

[jeffmoore]

I have added the "MS Offices lib 11" reference to my project.
As a test I did the following:

Access.DoCmd.Beep()

Which shows up undelined in blue, with the following message:

reference to a non-shared member requires an object reference

Q: do I need to somehow declare the access reference with in my class??

I'm real new to all this VB.net stuff....
I need to be able to use some of the VBA language in my VB.net program.

TIA
Jeff

 

[chrissie1]

probably you need to make an instance of some access database

something like

dim myaccess as new access.application
myaccess.docmd.beep


you will need more code then that and you can find more here

http://support.microsoft.com/default.aspx?scid=kb;[LN];317113

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting