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

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

Hi all, Is there any way to update a field with previous value of a combo box before updating a new value to the combo field. If my question is not clear please go through the sample db with this . Thanks in advance Thanks

HI all, Is there any way to trim a field if there is no value in that field. Now I am using this code =Trim([District] & " Dist.") The "Dist." is still displaying if there is no value at all. Thanks in advance. Thanks

Dear All, Is there any way that I can use an input mask to enter serial numbers of softwares..... the data will be like this... ABC8F-CHJ68-FH76F-GHF87-67JH5 Thanks in advance Thanks

Hi all, which is the best way to clear an active field.I had tried these, but no results. me.fieldname = Null and me .fieldname = "" both codes doesn't clear the field or if someone had any idea about this please help me Thanks

HI all, I am trying to use this code, but it is not working. If someone can please correct this... :o If Me.Text83 = Me.Recip_ID Then 'do nothing Else strMsg = "The Photo Selected is not Correct one. Do you want to change?" If MsgBox(strMsg, vbQuestion + vbYesNo, "Change Photo?")...

HI all, I had a field which is populated by selecting file from filebrowser. In that I am able to get the file and it is entering to field correctly also. The result will be like this. \\server\database\2005\649937\xxxxxx.jpg Is there any way to rip off \\server\database\2005\649937\...

Hi all, I had a report in that I like to hide a field if one criteria is met How can I make it possible. Can someone check this code if me.fieldname = "name" then me.fieldname.visible = false end if If someone done this before please give a help thanks

Hi all, Can we track the number of times a specific word appeared in a field on a report. I mean In a report I had a field which shows a or b or c for each records...is there any way to count howmany times these texts appeared.. like if a had shown in 3 records the count should be 3 like...

Hi all, In my db I had a table for students. I am using a report to view the age of the students. I want to list the name of the students who are 18 or more compared to the current date. The code which I am using now is SELECT Recipients.Inst_Name, Recipients.Rec_First...

Hi all I had a query and the sql is SELECT Institutions.*, Institutions.merge, Institutions.Inst_type FROM Institutions WHERE (((Institutions.merge)=True) AND ((Institutions.Inst_type)=[forms]![merge_inst_type]![Inst_type])); and I had a command button which process MergeAllWord ("select...

Hi all, I had a form which I am using for logon to db. the form is working fine, But i had a small doubt in that. When I typed password and press enter key it is only chaning the selection to my command button. Again I had to press the command button to activate the code for command button. If...