Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Dim RS As DAO.Recordset '//Gets the IDs from the recently selected query sSQL = "SELECT ID FROM " & strQuery Set RS = CurrentDb.OpenRecordset(sSQL) Do While RS.EOF = False Call UpdateCommLog(RS(0), "Record Merged") sSQL = "UPDATE DetailsQuery SET LastLog = 'Merged' WHERE ID = " & RS(0) Call ExecuteSQL(sSQL) RS.MoveNext Loop Set RS = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to add extra IF statement to a loop in MS Access VBA||3||26|
|Macro problems with Excel file||6||27|
|MS Access Query Criteria How To Handle Many ORs||4||26|
|Calculate Weeks in A "Fiscal Month"||8||26|