Hi,
My requirement is , I have to search for a particular function name in VBA code (Module /Form) of Access Application . I am using the following piece of code for that.
dim AccApp As Access.Application
Set AccApp = New Access.Application
AccApp.OpenCurrentDatabase "test.mdb"
AccApp.Modules.count
The last line of code "AccApp.Modules.count" is not returning the actual count even some funtion/procedure is written inside it(Form,module).
So can you pls tell me another method to read the code inside an access form .
With Regards
Niju Jose
My requirement is , I have to search for a particular function name in VBA code (Module /Form) of Access Application . I am using the following piece of code for that.
dim AccApp As Access.Application
Set AccApp = New Access.Application
AccApp.OpenCurrentDatabase "test.mdb"
AccApp.Modules.count
The last line of code "AccApp.Modules.count" is not returning the actual count even some funtion/procedure is written inside it(Form,module).
So can you pls tell me another method to read the code inside an access form .
With Regards
Niju Jose