C
Calvin Spealman
I am not a veteran of VB, VBA, or MS Access, but I do some work with them for
my job. That said, I have a problem. I'm having difficulty getting a complete
understanding of the type conversions that take place between my queries in
Access and my functions in the VBA modules. Particularly, when returning a
boolean value from a function, I know it is returned as 0 or -1, but no
matter what I try to set as a criteria for the field it is in (I am using the
functions mostly for special case criteria), Access claims a type mismatch in
my criteria. Does anyone have some good advice or references to help me in
these situations?
my job. That said, I have a problem. I'm having difficulty getting a complete
understanding of the type conversions that take place between my queries in
Access and my functions in the VBA modules. Particularly, when returning a
boolean value from a function, I know it is returned as 0 or -1, but no
matter what I try to set as a criteria for the field it is in (I am using the
functions mostly for special case criteria), Access claims a type mismatch in
my criteria. Does anyone have some good advice or references to help me in
these situations?