Onlylonely
Registered User.
- Local time
- Today, 19:52
- Joined
- Jan 18, 2017
- Messages
- 43
Hi Guys,
Appreciate if you could help me to solve this out.
For i = 1 To 5
CurrentDb.Execute "INSERT INTO Issuetbl (Part_Number, Serial_Number, Job_Number , Step, Character_ID) " & _
" VALUES ('" & Me.txtPN & "' , '" & Me.txtSN & " ', ' " & Me.txtJN & "', '1' , i )"
Next
Expectation: Part number, SN, JN and step is fix. ID is running number 1 to 5.For above coding, it cannot works.
P S J S ID
123 333 444 1 1
123 333 444 1 2
123 333 444 1 3
123 333 444 1 4
123 333 444 1 5
Appreciate if you could help me to solve this out.
For i = 1 To 5
CurrentDb.Execute "INSERT INTO Issuetbl (Part_Number, Serial_Number, Job_Number , Step, Character_ID) " & _
" VALUES ('" & Me.txtPN & "' , '" & Me.txtSN & " ', ' " & Me.txtJN & "', '1' , i )"
Next
Expectation: Part number, SN, JN and step is fix. ID is running number 1 to 5.For above coding, it cannot works.
P S J S ID
123 333 444 1 1
123 333 444 1 2
123 333 444 1 3
123 333 444 1 4
123 333 444 1 5