Search results

I have include everything that you need in the database. For B: the image that i attached, i want too combine the same colour together and sum up the nettweight and yards, but not the grossweight. The grossweight have to be calculated after summing up the nettweight

Hi there! I have attached my database. B: As you can see from my database that i have 4 dataset, which consist of two PO number with two different colour each. What i want to acheive is that since PO 1234 and 1235 have the same color with diff our qty and supplier qty, i want to combine the...

hmm, that's sound a bit complicated. Is there any simpler way where i can like maybe tick the textbox and it will store the value somewhere and it will automatically sum up the value in the textbox that is tick?

I only need to know how to sum up the the pound qty for the same color even tho the colour belong to different PO NO. After summing up the pound qty then i will calculate the grossweight. I only need the linkage to the summing the total pound qty before calculting it

Hi all, just a brief understanding of my database, I have multiple lines of colours, pounds qty and yards qty for the same fabrication. I have a button which will calculate the gross weight, so in order to calculate the gross weight, I will need to calculate it line by line. I have zero issue...

yes, i use query to sum up the calculation

Using button in the report is my last resort. I am using a query to sum the calculation. However, if i do a combine PO, the sum will not telly with my manual calculation. So i am thinking if there is a way where i can just perform the calculation after summing up the different weightage

I actually do the calculation part on my form, however, the data are calculated line by line so when i sum the data in the report, the grossweight does not tally with my nettweight

I include the button for computation is because i want to computate the grossweight based on the total amount for nettweight. The image i attached shows that the grossweight value is the same despite having difference nettweight. By right difference nettweight will give a difference grossweight

Hi all, I would like to ask how to have difference calculated value appear on report through button? I am able to click on the button on my report to perform calculation, however, all the calculated value are the same. How can i have difference calculated value for each line? Only the first...

Dim param As Parameter Dim i As Integer With CurrentDb.CreateQueryDef("", strSQL) For i = 0 To .Parameters.Count - 1 .Parameters(i) = p(i) Next If InStr(strSQL, "SELECT") = 1 And InStr(strSQL, "INTO") = 0 Then ' Simple select query and not...

Dear all, I would appreciate if you can offer me some helps here. I am facing this run time error '91' for quite some time, it will unexpectedly apppear. This error occurs when i attempt to click the next,previous or save button, it only appears when i did not key in the form or stop at one...

Oh, when i click on the value 1 in the PO combo box, it will filter the PO 1 It is not a unbound combo

i did not use any filter

Hi, yes i use two combo box, one for PO the other for colour. I have no issue having the values in the combo box. However, when i select PO 1 and colour blue, it will jump to record blue but the PO is 2. How can i make the record to jump to the value that i selected based on the two combo box?

Hi all, I have an error on this module where it ties to the browse button on my form. It prompt me user defined not defined when i click on the browse button. Below is my screenshot

Thank you both for the help, i have created a bound form and it works! But how can i use search for keyword on a bound form? i am able to search keyword on my unbound form

Hi there, how can i update data that is saved on the table through form? Currently, i have a form modify, and a listbox that is created by using data from the table. So let say i want to modify on one of the PO number that already exist in the table, by retrieving the data to the form and...

Okay, thank you!!

Hi all, Can i ask how to do validation on form? As i put the validation rule on one of my textbox = <>0 and validation text = "filed cannot be blank" By right, if the textbox = 0 then when i click onto the save button on my form, it will prompt me the validation text right? But in my...