Open another database and send Variable Back

vendredi 24 avril 2015

I have code that from DB1 opens DB2 and runs a Function in DB2.

The DB2 function produces a Boolean result that i am trying to get back to DB1 without success. Any suggestions? below is the script.

Sub Test22()
Dim AC As Object
Set AC = CreateObject("Access.Application")

rc = "K:\ARSHR\Automation_Projects\Mike\FE\DB2.accd b"
AC.OpenCurrentDatabase (rc)
AC.Visible = True
AC.Run "SendVariable"

End Sub

Because i am using AC.Run "SendVariable" i cant find a way to get the value of SendVariable!!
Open another database and send Variable Back

0 commentaires:

Enregistrer un commentaire

Labels