I found a snip of code, could something like this work....??
am I wrong or shouldn't something like this search trough the Group_ID, and sort out the administrator and MOD group.... and not display the admin and mod group, but list all other member groups...??
Anyone know how to make this work...!!
( I don't have the skills to make it work....???)
strsql = "SELECT * FROM " & strDbTable & " Author, " WHERE & strDbTable & " Username " AND & strDbTable & " Author_ID " AND & strDbTable & "Group_ID "<> 15 AND & strDbTable & "Group_ID" <> 3 " strAuthor.Open sql, conn, 3, 3 If not strAuthor.eof Then If Not isNull(Trim(strAuthor("Group_ID"))) Then Group_ID = Split(Replace(strAuthor("Group_ID"), "@", ""), ", ") End If
|