1. scalar function return value into a VBA variable - ADP:Access
2. Filtering on a VB function return value
I've built a VBA function that returns a TRUE/FALSE value. I've defined the return data type of the function as boolean. In a query I pass certain values from a table to the VBA function. It works just fine returning a result that is displayed as 0 or -1. However, if I try to place a value in the criteria portion of the query, such as TRUE, I get a message that it has an incompatible data type. If get the same message if I use either a 0 or -1 for criteria. In addition, if I run the query without the criteria, and then right-click on the field and select either Filter by Selection or Filter Excluding Selection, I get the same error message. In other words, it appears that for a function return value in a query no possible filter is allowed. Does anyone have a work around? Thanks. Regards, Leif
3. Function return values - VB.Net
4. Using sub with byref Param or Function return value
Hi! I'm maybe from old school but, for me, whebn it's time to call a method from DCOM, remoting or web service returning a string or anything else I use a function. It's more verbose. In my new company, much of my coworker works with Public sub ( byval Itemx as integer, byref returnCode as Integer). I don't understand why they use this kind of sub and i'm wondering if this kind of sub take more time to response? So, my question is, I have to debate this point tomorrow PM, is there any good raison why we should prefer function to sub with a byref when byref variable only seve to return a value? Tks
5. Function return values revisited - VB.Net
6. Date Function Return Values
If i use the date function within a vbscript the value returned is the system date, but the function does not return the date the way that the date cmd returns it. Date function in VBscript: 9/10/2003 date command in command shell: 09/10/2003 I am going to use the value returned from the Date function to generate a filename in the form of yyyymmdd. Is there any way that I can force the Date function to return a two digit value for month and day, i.e. put the 0 (zero) in there? Thanks for any suggestion, Darren Currently I am just using an If to manipulate the string, but i was hoping for a option within the function to return the 2 digit values
7. Simple assignment of function return value fails - vbs Rusty