hi,
how can i call a sub/function in access from VB.
there is a sub called import in a module modX
i need to call this sub from vb
i tried Call DoCmd.OpenModule(strModName, strSubName) but nothing happens.
Even this didnt work....
Set acObject = CreateObject("Access.application")
acObject.DoCmd.OpenModule(strModName, strSubName)
also if write a function in that module which takes a parameter.....how can i call that function(in access) from VB and pass that parameter.
TIA
how can i call a sub/function in access from VB.
there is a sub called import in a module modX
i need to call this sub from vb
i tried Call DoCmd.OpenModule(strModName, strSubName) but nothing happens.
Even this didnt work....
Set acObject = CreateObject("Access.application")
acObject.DoCmd.OpenModule(strModName, strSubName)
also if write a function in that module which takes a parameter.....how can i call that function(in access) from VB and pass that parameter.
TIA