Recent content by jadeja

Function i named as TextConvert. Now text box property is =TextConbert([Bill_Amount]) But getting result as #Name? Compiling dose not shows any error in code. Also there is no other module available now. Please suggest.

This is as per what mentioned in the post. As i don't kn ow anything about the code i just copy paste the text as it and changed the control name. Please if you can modify in this as per my requirement then i can use the same code as it is. Also i need Rial and Baiza instead of Doller/Cents...

I changed it to NumToWords. Even though it displays results as #Error. This is the code i have used. Function English(ByVal N As Currency) As String Const Thousand = 1000@ Const Million = Thousand * Thousand Const Billion = Thousand * Million Const Trillion = Thousand * Billion...

No, It shows error. I created a module named as English. Then attached the module with text box. =English([Bill_Amount]) When i run the form it displays as #Name? Please explain in detail as i am new to access and don't know much in codes. thanks

Hello. I have one field called Bill_Amount. Data Type is Currency and format is set as a Fixed with 3 Decimal Places in the form. I want a text box which will display the Bill_Amount in the Text. e.g Bill_Amount = 123.251 Text box will display One Hundred Twenty Three Rial and Two Hundred...

Working..... The code is working with giving option to continue Yes or NO... Now how do i go back to the detected duplicate record. Is it not possible warning will display the Edit Record button as well to navigate directly to the record ?

Name is changed to Bill_Type. Data type for Bill_Type is Text only. And yes Bill_ID is primary key of the table. field type if autonumber for the Bill_ID.

I am writing what exactly i want.. My Table name is Billings and form name is Billings subform. Table is containing these fields. Bill_ID, Bill_Date, Cust_Ref, Amount, Type Now i want if Bill_Date, Cust_Ref and the Type is matching for the record it will warn me with this functions. Record...

Could be i don't know how to put the validation. Fine even if it warns to me saying "Check, Could Be Duplicate Bill" then also will fine. I don't want completely stop over there. With warning user can go ahead with duplicate. I just need a warning at that point. Please guide how to i set...

Thank you The method you describe is correct. I want like that only. I checked both fields and both are Indexed (Duplicates OK). But with this it doesn't work. I mean nothing happens. It creates duplicate value. I think i need to put something code at form level it self. May be after update...

I have one database with table name Billings and form name Billings subform. I want users to prevent entering duplicate records by two fields. Cust_Ref and Bill_Date these are the two fields in the form. User can not make the bill if the cust_code is already entered for the date. Means...