Upon opening Access - Run a program or function

[johnseito]

I thought I know how to do this. I know the concept but it didn't work.

I created a macro, name is autoexec (so when access is open it auto run) then assign this macro to run a code or function that I build.

I tried it but it didn't work, not sure why.

I get the error message

Microsoft Access cannot find the name fxup you entered in the expression.
You may have specified a control that wasn't on the current object without specifying the correct form or report context.

The name is correct and is there and is a function in a module.



Please advise !

[RuralGuy]

Is it a Public Function in a Standard Module (not the class module of a form).

[johnseito]

You know how you go to the top and in the menu bar you click insert and you could select procedure, module or class module.
I entered Module and inside this module I created a public function.

The module however I rename to let's say abb because I was able to do so. I have the macro call or run the name of this function.

So yes is a public Function in a standard module - not class module.

[RuralGuy]

So it is now fixed and working?

[johnseito]

no - still has that error message every time I run the macro or when I open access.

[davegri]

Attachment 29853

If the name of your function is fcnStartup, here's how to code the autoexec macro.

[johnseito]

Ok that work. I just didn't have the two parentheses. Thanks !!!