Dear friends,
I have a function for converting number to word for netamt.
function name is num_to_word.
How to call the function in a form(while calculating netamt).Please guide me.
Printable View
Dear friends,
I have a function for converting number to word for netamt.
function name is num_to_word.
How to call the function in a form(while calculating netamt).Please guide me.
Can you post your function?
(a guess without seeing your Function)vb Code:
num_to_word(this_is_the_number_parameter_I_pass) 'Eg. MsgBox num_to_word(14)
If the function is in a module, you want to declare it Public:
Code:Public Function num_to_word( ... ) As String
Thanks for your mail.
I want to call num_to_word function in select function.
How to call funtion in a select query?
suppose net_amt column.
select num_to_word(val(net_amt)) ........gives error
Assuming that you mean a Select query (SQL), you can't - you can only use functions that the database provides.
You will need to run the function against the recordset fields (as part of your display process) instead.
Or have an index table in the database that can give the wanted results, ie.
word_id in this sample would link a certain number to certain word. The words table would be very simple, having only word_id and word columns in the table.Code:SELECT a.id, b.word FROM amounts a, words b WHERE b.word_id = a.net_amt
A number to word? I have that program below...
So where is it? :)Quote:
Originally Posted by sessi4ml
?
My links.... Number to Words/66 digits
Ah, if it's in your signature then I don't see anybody's sigs... Sorry.