Thanks for the explanation Rich, I'm wondering if it possible to set to option compare binary for just one sub in a module? (Ex. Password match button)
The InStr function itself has a 3rd argument (optional) that allows you to specify the type of comparison. If omitted it defaults to the module's compare setting. If you want to use InStr for binary match in just one sub, then set the 3rd argument to 0.
So, if you have different paradigms, where different functions/subroutines require different comparison options then each sub/function must be located in theor respective modules.... ie, "option compare..." can only be declared once?????
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Thanks for the explanation Rich, I'm wondering if it possible to set to option compare binary for just one sub in a module? (Ex. Password match button)
The InStr function itself has a 3rd argument (optional) that allows you to specify the type of comparison. If omitted it defaults to the module's compare setting. If you want to use InStr for binary match in just one sub, then set the 3rd argument to 0.
599cd.com/QQ
So, if you have different paradigms, where different functions/subroutines require different comparison options then each sub/function must be located in theor respective modules.... ie, "option compare..." can only be declared once?????
599cd.com/Ask
599cd.com/QQ
I get the impression that these statements are module specific. So the answer to the question above would be yes.
*question above
@@gregoryjeffries8475 599cd.com/QQ
So, Richard Rost is a customer since 1955 ? I'm sure you're not a day older than 1956....haha LOL
I hopped in my DeLorean. :)
Do people still use Microsoft Access? Why not just use SQL? Isn't VBA old? The IDE is terrible. Just learn python + SQL it's better.
599cd.com/QQ
Hlo sir
I have a one database application,i want to help for this,how i can contact u
599cd.com/Ask