Loop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

I have a continuous form. How can I loop thropugh each record and perform
certain action?

Thank you,

Daniel
 
Daniel said:
I have a continuous form. How can I loop thropugh each record and perform
certain action?
Click to expand...


Consider that request carefully. Most everyone that asked
for that is seriously violating the rules of normalization
and trying to treat with the recordset as if it were a
spreadsheet.

If you have a really valid reason for doing this. the code
would be along these lines:

With Me.RecordsetClone
If .RecordCount > 0 Then
.MoveFirst
Do Until .EOF
'perform unspecified action
Loop
End If
End With
 
I have a continuous form. How can I loop thropugh each record and
perform certain action?
Click to expand...

Use a query on the underlying recordset:

UPDATE MyProducts

SET CurrentPrice = 1.15 * CurrentPrice,
LastIncrease = DATE()

WHERE YEAR(LastIncrease)<2006;

Hope that helps


Tim F
 
Back
Top