Referencing an Accde and getting ByRef Mismatch

[Perceptus]

I have an ACCDB that has a custom Type that is used in a function call.



When the Project is used as a reference library in ACCDB Form, the calls work. great. I get no errors.

When I converted the ACCDB to ACCDE and then use the same calls, I get an Compiler Byref Mismatch, even though the signature is a complete match of how it worked previously.

Im guessing this stems from the function call not having its parameters established as byval or byref, so they are set byref by default.

The MSDN help on this issue says Im passing a type that can't be coerced/cast into the type that is used. but they are the same type.

[ItsMe]

Not sure I follow perfectly, but ByRef is the default. So, yes, I would expect an error that mentions ByRef even when you did not explicitly define ByRef.

Aside from that, not sure why there would be an issue with accde vs. accdb. If I were to isolate an accde vs accdb issue (without considering a custom function or a specific error) I would ask if the accde was produced by a later version of Access than the client version running the accde. For instance, was the accde created using 2013 and then the problem occurred when using 2010 RT.

Specific to the Mismatch error, I would see if the declaration in the function's parameters matches the data type passed via the argument. Perhaps there was an implicit declaration of a Variant type string and not an explicit type string in the argument.

[Perceptus]

Thank you, I will review more.

[Perceptus]

Looks like I had copied the Custom type into a local module and it was using that type instead of the one in the reference lib. Even though it was just copied and pasted into the local. When I removed the local declaration for the type, the error went away.

[ItsMe]

That sounds pretty cool. What are you storing your Types in, Classes? All of these Classes reside in an Access file that acts as a Class Library? This Access file is then Referenced via tools>References?

[Perceptus]

Yes, yes yes and Yes =). Its pretty great.