Thanks to LMSConsulting's suggestion in this thread: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24211524.html
- I've been able to do commands against each individual item in a single Access table. Meaning, I have a table with a bunch of PC names, and (in the example provided) I can MsgBox each PC name in the list.
If possible, I'd like to evolve this script - to add another table. IE
Basically, what I'd like to do here, would be to run all the commands in the right table against the PCs in the left. So, in other words - run command1 and command2 against PC1 - then move onto PC2, and rinse/repeat.
My guess is that it'll be some sort of "For each PC in Table1.ComputerName ***" but I honestly don't have any ideas past that.
Any assistance you guys can provide on this subject would be greatly appreciated.
Dim rst As DAO.Recordset
Set rst = Me.RecordsetClone
Do Until rst.EOF
MsgBox "Testing " & rst("SomeFieldNameHere")