Recent content by Onlylonely

I have find the solution.

Hi Guys, Appreciate if you could help me out. I have listbox4 and listbox5, when i select multiple row from the listbox4 and click next, the issuetbl suppose to update 'Check' in complete column. So that listbox5 have the item which i selected. Unfortunately, it only show the last item that i...

Hi Guys, I have roughly 20frames in my forms. Any idea how to select all the 20frames in shot and update? Like .... Private Sub All20frames_AfterUpdate() coding.... End Sub

Hi MajP, Single button click, then it will click all the buttons. Private Sub CheckPass_Click() Dim ctrl As Control For Each ctrl In Me.Controls If CheckPass = True Then If ctrl.Tag = "Step1" Then ctrl.Value = 1 'If ctrl.Name <> "CheckPass" Then If ctrl.Tag =...

Hi Guys, May i know how to execute many buttons using a single buttons? I have a tag all the buttons with "Step1" My code like below but not works. Private Sub CheckPass_Click() Click.ctrl.Tag = "Step 1" And Click.ctrl.Value = 1 End Sub

Hi Guys, Any clue to update the table with incremental number? With rst Do Until .EOF If (![Remark] = "Rework") Then Rework = Rework + 1 Else End If .MoveNext Loop End With For R = 1 To 19 CurrentDb.Execute "INSERT INTO Issuetbl (Part_Number, Serial_Number, Job_Number , Step...

Alright, thank you very much Micron! Appreciate your help on this.

Hi Micron, I've solved the summary issue by changing the steps. Do you have any idea to increase the "Rework" as below?

My apologize, 1st - Open checklistform. 2nd - Input any part number , job number and Distinct Serial number. 3rd - Step 1, Question 1 to 12, put at least 1 FAIL 4th - Step 2 , Question 1 to 7 , put all pass 5th - Submit it. 6th - Open Issuetbl, check the data. Summary not update to FAIL...

Hi Micron, Yes, all the control are not bound. What to do to replicate the issue in a database you've never seen before and no instructions?? << i dont really get it. can you give me an example?

Hi essaytee, Sorry to make you confuse. I haven't work on the step 3 yet. I'm working on step 1 and 2... What i want is if there is a FAIL in step 1 or 2, table summary field need to update to "FAIL".

Anyone help? I still stuck ......

I'm still stuck... Attach herewith the file. Hopefully can solve it. I've solve the step 1 summary to FAIL, but Step 2 summary still remain PASS.

Hi Micron, Im using procedure coding. Type mismatch. sSQL = "Update Issuetbl Set [Issuetbl].[Summary_Result] = 'Fail' WHERE [Issuetbl].[Serial_Number] = '" & Forms!checklist!txtSN & "' IN (Select Serial_Number from issuetbl AS T where T.Result LIKE " * Fail * ")" MsgBox (sSQL)...

Hi Micron, I've tried this an it is not working. The code only will update the summary result to FAIL if the result column contain FAIL. For the result column is pass , it will not update to FAIL for the same S/N.