Recent content by puthenveetil

Dear all, If some have the code for converting amount to words in rupees, please help me... Thanks in advance Thanks:(

Dear all, If some have the code for converting amount to words in rupees, please help me... Thanks in advance Thanks:(

Dear all, I am creating a database which has an invoice printing form. In that I would like to have a column for the total amount in words. I have got a sample module from northwind database. According to that 100,000 is "one hundred thousand" but in my country that is pronounced as " 1 Lakh"...

Dear all, Is there any way to update the same record from two forms? The requirement is that in a form I have a checkbox. If I select the checkbox, it will open another form, in which I can update some fields which are of the same record. When I tried, it is updating on another record. Is that...

Hi all, Is there anyway to use Last() feature in load event?. I would like to find the last value in the balance amount when the form load. I would like to use like this.. Me.Bal_amt = last([Bal_amt]) When I open form an error message is popping up error 13 . Is there any way I can use...

Hi pat, Thanks for the reply, could you please explain what is 1-side table.... Thanks

Thanks for the reply, I need the second table because I need to get a sum of field from that... Or is there any other way to get the sum of fields.. Thanks

Hi all, This may be dump question. Don't laugh at me..Can I display the data from two tables in a report without using a query. Why I need this because I had two tables which has no common fields in that... Or if there is a way how can I do that.... thanks in advance Thanks

Hi Jon, That worked........ Thanks for the help Thanks :D

Hi Jon Thanks for the reply DELETE * FROM Details WHERE [No_cover] is null and [Load_amt] is null; This is my query, in this it should delete all the records which [No_cover] and [Load_amt] is null. If any one this field has data it should stay there. Will this code do that??? thanks in...

Hi all, I had a little problem with delete query. I would like to delete the records by checking two fields if both fields are empty. I mean if a records had both these fields are empty only. If one of the field has data , the record should stay there.. Is there any way I can do this? Thanks...

Pat, That is what I wanted....thanks :D Thanks

Thanks Pat, I will give a try ...... Thanks

Hi Brian, I would like to find the last updated date in a field. thanks

Hi all, I have a problem finding the last date entered in a table..The purpose is to find the record which entered last in a table. Is there any way to find the last record with date ? I am attaching a sample db with this. Please look that if my question is not clear here.. Thanks in advance...