I am attempting to Run a function using runcode in the macro creator in Access 2010, I keep getting the following error:
"[Name of Database] cannot find the name “[Name of Function]” you entered in the expression.
The function is not marked private and I have macro security off. Any ideas what would be causing this??
Any help is greatly appreciated. Thanks!
2 Spice ups
tufot
(Tom4137)
2
nothing pops to mind - I’d try vba code instead, stop using macros, and simply run the function (or sub) with parameters values needed - much better error handling than macro - (other than that may be name of function reserve word or typo) - my 2 cents
Ended up skipping the macro part(thought it was necessary) (new to access/vba/vbs). I just created the sub and called it in a function. Called that function in my vbs file and it works perfectly now.
