Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by logmonkey
-
Custom Property in User Defined Function?
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...- logmonkey
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Custom Property in User Defined Function?
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- logmonkey
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Custom Property in User Defined Function?
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, _...- logmonkey
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
