Search results

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?

yes i mistake add dutyrate.. lol when added its slove thank you dear fast respsond

hi all i try whole day to fix this issue when i set values 0.69 its back to 1 automatic any expert help me please?

Yes Change Name )) Thank you Again Dear

MY PROBLAM SLOVE I MOVE TO TABLE TO COMBOX BOX ' Retrieve mobile number from Customer customerName = Me.Customer ' Retrieve mobile number from Combo241 customerMobile = "88" & Me.Combo241 ' Adding 88 to the mobile number Thank you Gasman for you time and help

why i cant post full vba code its give error Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please contact an administrator.