Modules in access

  • Thread starter Thread starter pushpendra vats
  • Start date Start date
P

pushpendra vats

Hi!!
I have small query! I have created a small module in
access 2000.I want to call this module from visaul basic6.0
Is it possible .If yes then what is the procedure for that.

Thanks in advace

Pushpendra
 
add a reference to access 2000 in your VB app, then make a proc with:

Private mAccess As Access.Application
Set mAccess = New Access.Application
mAccess.OpenCurrentDatabase "C:\my.mdb"
mAccess.run "=MyFunction()"

dont remember exact syntax for .run method, so please check online help
 
Back
Top