Recent content by shobhanauto

How can I create extra queries? If I have a packing list with 1000 items, how can I create a separate query for each item? Because in one box, there may be 4–5 different items. So I want to handle each item individually using separate queries or filters. Can you please guide me on how to do...

Actually sir I don't understand English very well What I’m trying to do is this: In my packing list, sometimes there are 2 items, sometimes 5 or more. I want to sum the NET WEIGHT (Box_Weight) of all records for each item, and then set that total as TOTAL_NT_WT, but only in the last row of...

I’ve attached an image to help explain the issue with the TOTAL_NT_WT calculation

here is image i want like this

Hi everyone, I am working on a Microsoft Access project where I add multiple records for items in a subform. Each record has a Box_Weight field, and I want to calculate the subtotal (sum of Box_Weight) for each item. However, I want to show this subtotal only in the last record of each item...

Hi everyone, how are you all? I’ve created a form for stock transfer between warehouses, but it’s not working. Can anyone help me? Details: Total Warehouses: 4 W-ADMIN W-MAIN W-RETAILS W-LOCALS The form is supposed to transfer stock from one warehouse to another, but it’s not...

Thank you sir, for providing advice and samples.

How are you, Pat Hartman? I'm actually new to Access. If you have a little time for me, could you please update my file if possible? Thank you

And since these are calculated values - why do you want to store them? The reason for storing this is because I have three sales forms for three branches. When I update Salespercents, it will be displayed next to ItemName on these forms. For users generating invoices, the Salespercents I set...

anyone here help please?

Dear Sir i Uploaded database file first page and here vb code i set SalesPercents Private Sub SalesPercents_Click() On Error GoTo ErrorHandler Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("SELECT * FROM ItemName"...

i need another help I uploaded the database file. In the forms, the last Sell% shows 3.53%. Then the result should update in the ItemName tables SalesPercents field. I added the VBA code, but it's not working. Can anyone help?

Thank You Working Good

hmm good idea can you me ff code? <> 0 please

hi i need another help I uploaded the database file. In the forms, the last Sell% shows 3.53%. Then the result should update in the ItemName tables SalesPercents field. I added the VBA code, but it's not working. Can anyone help? Could someone please help me?