Loop

[EMILYTAN via AccessMonster.com]

Is there any way, where u you select the record (part number, quantity)
where the order number = strOrderNum...

Then,
I will put a loop there to do until it end.
But just the moment entering the loop, i will need to check whether this
selected part number exists in that table under the specified job number...
If exists, will update accumulate the quantity else it will insert a new line.
..

How should I do it?

 

[SusanV]

Open an ADODB.recordset with that record as criteria, and set the loop under
an IF statement:

If recordset.recordcount > 0 then
'do whatever in your loop
end if

For example, I use a loop in an if records exist here:

strSQL = "SELECT [TMINS #],TMTitle from tblTMTemp WHERE [TMINS #] is
null"
rst.Open strSQL, cnx, adOpenKeyset, adLockOptimistic
If rst.RecordCount > 0 Then
rst.MoveFirst
Do While Not rst.EOF
n = n + 1
strTM = strClass & " NoTM No." & n
rst![TMINS #] = strTM
rst.Update
rst.MoveNext
Loop
End If

 

[SusanV]

By the way this is done in a VBA function or sub, not in a query... sorry if
I confused you!

--
hth,
SusanV

Open an ADODB.recordset with that record as criteria, and set the loop
under an IF statement:

If recordset.recordcount > 0 then
'do whatever in your loop
end if

For example, I use a loop in an if records exist here:

strSQL = "SELECT [TMINS #],TMTitle from tblTMTemp WHERE [TMINS #] is
null"
rst.Open strSQL, cnx, adOpenKeyset, adLockOptimistic
If rst.RecordCount > 0 Then
rst.MoveFirst
Do While Not rst.EOF
n = n + 1
strTM = strClass & " NoTM No." & n
rst![TMINS #] = strTM
rst.Update
rst.MoveNext
Loop
End If