Search results

Thanks for the effort. why it is not working as i need? i mean to open "View Customer Form" And add products on subform? what is the problem doing it? You can take a look at the file i have made earlier, https://www.mediafire.com/file/80xwl4nkgd96c1o/FDMS.accdb/file it works in my FDMS File...

open "View Customer Form" and try to add more than one items in subform,

HI all, i am trying to create a simple order system. done all relationship and sub form matching field. but still got error as per attachment. I am trying to learn this thing so pls guide me what i am doing wrong. I have attached my database and query screenshot. Thank You,

Function ConvertCurrencyToEnglish(ByVal MyNumber) ' Edited by Karthikeyan karthikeyan@livetolearn.in Dim Temp Dim Rupees, Paise Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " lakh " Place(4) = "...

This works finally... thanks man

didn't it the same thing done in my "OrderdetailsQ" as well? i mean what is the change ?

Tried it, this thing records all product names to my product table, e.g. if i select a product name and don't enter quantity then it stores it without price in my product table. I dont want to store values in my product table. i want to use it in my "OrderF" only. ProductT must be stay as it is...

Its a great help, Thanks only one question, if i change control source to "ProductIT" does it affect my data? i mean does it stores productID in field instead of product name?

Can u pls solve my Unit lookup problem on the file i've uploaded ?

You mean to say, I have to convert my Unit Textbox to Combobox ? or i am getting it wrong? Can u elaborate it further?

I have already added "Unit" in the combobox row source, and changed "ProductName" combobox to "CboProductName", and trying to add one more 'SetValue" for unit as per attached screenshot but no luck. can u help further?

Hi all, I have a table "ProductT" which has following columns, - ProductID - Product Name - GGRC Price - Unit I have created a form named "OrderDetailsF" which get values from table "ProductT". When i select a product from combo box i need relevance price in Price field for this, I have...

This solved my problem. Thanks

i need sum of "Amount" Field but condition is where "Is Head Unit" value is Yes only.

Hi all, I have a table which has following columns, - Product Item - Rate - Is Head unit item (yes no field) - Quantity - Amount Now i need sum of amount where "Is Head Unit item" field has value yes. I have tried "Sum(IIF([Is Head Unit Item],1,0)) but not able to get the sum value. How...

Thanks Larry you are a life saver.

Hi all, I have created a customer order entry system, I have tried to follow an online tutorial and make the attached access order entry system. Now I need help on, 1. How to create a new customer and enter order items 2. how to edit items in OrderF (it shows an error) Thanks

Yes with Abs()

This works most...Thanks

Sorry for the late reply, But this works for me as calculated field, IIf(IsNull([Invoice Sent Date] and IsNull([TR Date] and IsNull([TPA Date] and Not IsNull([WO Date])))),"WO Received",IIf(IsNull([Invoice Sent Date] and IsNull([TR Date] and Not IsNull([TPA Date]))),"TPA...