Recent content by porkie

The error was a control where I had changed the bound table but not reset the control data source. The control had the little error triangle but I had missed it as several other controls had the triangle due to warnings like label not linked to a table. I suggest you check and clear all the...

Hi Bob, Thanks very much for helping me and finding that. I fixed them and it works fine now.

If you could let me have an e-mail address that would be fine, i just don't want to post it all on the forum. The FE filesize is 4mb, I wont send the BE as the error happens way before that gets involved! I just tried creating a new public function in a module, with just a msgbox in, and...

When the accde is run, I get the msgbox style error with "The expression you entered has a function name that XXDB nameXX cant' find." Click OK and get the attached macro call error.

The autoexec macro just has: runcode autoexecstartup(1) and the function is here: Public Function autoexecStartup(SC As Integer) Dim booLinksOK As Boolean Dim booLinksChanged As Boolean Dim booCheckAppFolder As Boolean Dim strCheckMode As String strCheckMode = "quick"...

It isn't reaching the first line of the code. I put a msgbox as the first line and it didn't trigger. The error is it cannot find the function, rather than it is failing inside the function

Hi Bob, read the article thanks, the target function is Public in a module. The problem only occurs in the compiled db not the accdb version which works fine. Am I right in thinking that if the target function can be found in the uncompiled accdb version, then the scope issue shouldn't be a...

Hi Bob, Thanks for the prompt reply. There are 100 forms it is quite big and proprietary - my main issue with uploading. What are SCOPE issues, never heard of that.

I have a working database which runs fine in accdb mode. But when i compile it and run the accde file I get the error "The expression you entered has a function name that XXDB nameXX cant' find." The problem is that the autoexec macro cannot find the VBA public function that is called with...