Point til Sa....
Dette har han laver for mig :O)<%
if request.querystring("mode") = "submit" then
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Users.mdb") & ";DriverId=25;FIL=MS Access"
Set myConn2 = Server.CreateObject("ADODB.Connection")
myConn2.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Users.mdb") & ";DriverId=25;FIL=MS Access"
strSQL = "SELECT * FROM tblUsers"
Set rs = myConn.Execute(strSQL)
If not (rs.BOF Or rs.EOF) Then
Do While Not rs.EOF
if request.form("aktiv" & rs("id") & "") = "Ja" then
aktiv = "Ja"
else
aktiv = "Nej"
end if
Sql2 = "UPDATE tblUsers set aktiv='" & aktiv & "' WHERE id=" & rs("id") & ""
myConn2.Execute(Sql2)
rs.movenext
loop
end if
myConn.close
set myConn = nothing
myConn2.close
set myConn2 = nothing
end if
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Users.mdb") & ";DriverId=25;FIL=MS Access"
strSQL = "SELECT * FROM tblUsers"
Set rs = myConn.Execute(strSQL)
If not (rs.BOF Or rs.EOF) Then
%>
<html>
<form method="POST" action="aktiv.asp?mode=submit">
<p><b>Aktiv?</b></p>
<% Do While Not rs.EOF %>
<p><input type="checkbox" name="aktiv<%=rs("id")%>" value="Ja" <%
if rs("aktiv") = "Ja" then
response.write "checked"
end if
%>> <%= rs("username")%></p><br>
<%
rs.movenext
loop
%>
<p><input type="submit" value="Gem" name="mode"><input type="reset" value="Nulstil" name="B2"></p>
</form>
<p align="left">
<% end if %>
