Search results for query: *

Hugh, Awesome You detected the root of the problem with my function, dynamically detecting the data type, which is why I chose to add the intDatatype argument to specify the input data, then used a series of if statements. I will look at VarType to see if I can eliminate the need to specify...

Thanks PHV. That did it. Hey you helped me out using less than 5 words. Pretty cool. For those of you searching for this. the answer was after doing a little reading, I created a new module and added the following code. Public Enum vbDataType vbInt = 2 vbString = 1 vbDate = 3 End Enum

Hi all I've created a generic search function to make creating custom searches in my Access 2010 application easier. Here is the function name and its arguments. I won't bore you with the rest. Public Function SrchFrm(strPrompt As String, _ strForm As String, _...