Autoexec failing to find designated function

[GraeagleBill]

I can't figure out why access can't find a function via Autoexec Run Code? The function is "Public" coded in a general module, like I've been doing for years.



I must have forgotten something???

[pbaldy]

Looks okay to me Bill, presuming that's a standard module rather than a form/report module. What error do you get, just "can't find..."?

[GraeagleBill]

Public Function MedTimes() coded in ModMedTimes. I get the error with both RUN Autoexec from macro design or open DB.

[pbaldy]

Does it compile? I'm wondering whether there are 2 functions with the same name. If not, can you attach the db here?

[GraeagleBill]

Only one instance of "Public Function MedTimes()" and the DB compiles. However, Compress and Repair produce the same error. I have to leave for a bit, but when I get back I will rebuild the DB piece-meal to see if I just have a corrupted DB. Happens sometimes with cut/paste of code and or modules.

[davegri]

The Runcode should be =MedTimes()

note the =

[GraeagleBill]

Far be it for me to question my elders, but here's one of my production macros that has run successfully for about 12 years or so.


I created a new DB and copied the modules, queries and macros plus the backend links. So, as I somewhat expected, I was dealing with some level of corruption within the DB causing the issue. One has to remain astute when using copy/paste within Access, especially code and controls.
Thanks,
Bill

[davegri]

but here's one of my production macros that has run successfully for about 12 years or so.

Well, that's a surprise. Turns out it works either way for me.