B
Brandon Johnson
I'm having a little issue. Kind of seems minor. I have a table,
"tblLoginPWD", that holds yes/no in one column. what im trying to do is
be able to go through the whole column and find ALL the ones that are
checked and display them in a listbox. I would also like to put that in
a timer so that fires every 30 sec or so. Im kind of lost of how to go
about doing all that. if anyone has any input please let me know.
thankyou so much.
Set User = CurrentDb.OpenRecordset("tblLoginPWD", dbOpenDynaset)
UserCri = "[login_status] = yes"
For i = 0 To User.EOF
User.FindNext UserCri
lstActivity.AddItem (User!login_Name)
Next
"tblLoginPWD", that holds yes/no in one column. what im trying to do is
be able to go through the whole column and find ALL the ones that are
checked and display them in a listbox. I would also like to put that in
a timer so that fires every 30 sec or so. Im kind of lost of how to go
about doing all that. if anyone has any input please let me know.
thankyou so much.
Set User = CurrentDb.OpenRecordset("tblLoginPWD", dbOpenDynaset)
UserCri = "[login_status] = yes"
For i = 0 To User.EOF
User.FindNext UserCri
lstActivity.AddItem (User!login_Name)
Next