Run A Function of Sub on MS Access

[Firas]

I designed a small program to use in HR using MS Access 2016.
I am trying to run a function, which I wrote in one of the program modules.
The said function return a string, which shows the folder path for active employee window.



So, when the program is on, I want to retrieve the employee folder path from the function "EmployeeFolderPath"

may be the code will look something like this.

Code:

Copy      Help

str sPath
Access.Application acApp
;;acApp = I should get the running instance of the program
;; the program path ""\\HR-PC\HR.accdb"
sPath = acApp.Run("EmployeeFolderPath")

Appreciate your kind help