Hey guys,
Im currious whats the difference between these 2, also what and when to use?
The example is pretty poor but just curious whats the difference and when what to use.
Thanks!
Im currious whats the difference between these 2, also what and when to use?
Code:
Set Cust = MyDb.OpenRecordset("SELECT CustomerID FROM Customer)
If Cust.RecordCount <> 0 Then
Cust.MoveFirst
While Not Cust.EOF
MyDb.Execute ("UPDATE Receipt SET Receipt.Printed = Date() WHERE Receipt.CustomerID = " & Cust!CustomerID & ";")
Cust.MoveNext
Wend
End If
Code:
Set Cust = MyDb.OpenRecordset("SELECT CustomerID FROM Customer)
If Cust.RecordCount <> 0 Then
Cust.MoveFirst
While Not Cust.EOF
Set ReceiptPrint = MyDb.OpenRecordset("SELECT * FROM Receipt WHERE CustomerID = " & Cust!CustomerID & "")
With ReceiptPrint
.Edit
!Print = Date
.Update
End With
Cust.MoveNext
Wend
End If
Thanks!