Have to agree with Skip here. If there is already an AutoExec macro then you only have to open it and change whatever. However if you are saying that you want your own AutoExec to fire then create a module, name it AutoExec and make sure that have a procedure called Sub Main() where your main coding goes in it. This will then kick in as the AutoExec.
I've got a macro in access which is called Autoexec. Ant this macro calls some functions. And some of this functions shall run only once. So I tried,after this function is run, to change the condition of this specific function. And to do so, I wanted to change this condition with VBA.
But now I solved the problem with a function which is called at the startup form.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.