June 15th, 2003, 01:06 PM
|
|
Contributing User
|
|
Join Date: Apr 2003
Posts: 45
Time spent in forums: 4 m 36 sec
Reputation Power: 6
|
|
|
How to return a value from a Function?
I have a problem with a function .. i need to return a value and i cant make
it work.. this is my code an a little explanation about what it should do.
hope you can help me
PHP Code:
ALL THIS CODE IS IN A FORM----->
Function formatearFecha(ByRef fecha) As String
Dim miAno, miMes, miDia
miAno = Mid(fecha, 1, 4)
miMes = Mid(fecha, 5, 2)
miDia = Mid(fecha, 7, 8)
fecha = miDia & "/" & miMes & "/" & miAno
End Function
Private Sub Form_Load()
Dim temp As String
SOME CODE HERE....
Do While Not rs.EOF()
temp = formatearFecha(rs!fecha)
msgbox temp
rs.MoveNext
Loop
End Sub
Well the explanation: i retrieve a number from rs!fecha like 20030611 then
in the function i convert it to "date" format so i want the return value
something like "11/06/2003". the function works ok.. i mean it does what it
should do (trsnformthe number into date format) , but my problem is that in
the form load in the MSGBOX temp line it shows nothing, i mean .. temp
variable is NULL.. Why the the "fecha" variable is not passed to the
variable temp??? how do i return that value from the function? what im doing
wrong here??
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
