Search results

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...

Hi godo, Thanks and reply and the sample db. That worked very well ...... Thanks again Thanks

Hi all, I had a small problem with combo box . Is there any way to store the previous value of the combo box. Last time Pat showed me a way to collect the value by .oldvalue property of the combo box and it worked fine. But it working only for saved record and one time only. If I choose...

Skip Labels Hi Pat, With reference to the answer, did u tried that code anytime? I had a problem in that. When I am using the code, I can see the label skipped in the preview screen, but when I am printing the label is not skipped? Why is that? Any idea? Thanks in advance Thanks

Hi Pat, I had managed that code worked.....Thanks for the help

Hi Pat, Thanks for the reply, but I failed to get a result. Can you update my sample with this code????? :( Thanks in advance Thanks