Here's a very down to basic way of using the AddNew which you are. What we'll do is add email and date
This is a actual script I use in a simple form of mine so I added a little error handling in there for the email to validate a empty field, I've cut it down tot he email and date for this example though
<%
Response.Buffer = true
dim cnn,rs
set cnn = Server.CreateObject("ADODB.Connection"

set rs = Server.CreateObject("ADODB.RecordSet"

cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=" & Server.MapPath("dbase\UserInfo.mdb"

sqltext = "SELECT * FROM userInfo"
rs.Open sqltext,cnn,3,3 'open the connection to the database
dim addr, day, error
addr = Request.Form("EmailAddr"

day = Request.Form("Day"
if addr = "" then
error = "You have not entered an email address."
Response.Write error
Response.End
end if
'If we pass through validation then store the information in the db
rs.AddNew
rs("EmailAddr"

= addr
rs("Date"

= day
rs.update
Response.Redirect "thank.asp"
%>
now I'll show you the same functionality with a simple sql insert statement, which makes things much easier and more efficient.
I've left out the validation.
<%
Dim cnn, sqltext,day, addr
addr = Request.Form("EmailAddr"

day = Request.Form("Day"

set cnn = Server.CreateObject("ADODB.Connection"

cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=" & Server.MapPath("dbase\UserInfo.mdb"
sqltext = "INSERT INTO userInfo (EmailAddr,Date)"
sqltext = sqltext & " VALUES ('" & addr & "', # " & day & "# )"
cnn.execute(sqltext)
cnn.close
set cnn = nothing
that's it
the main things you need to remember here is the date delimiter around date values, '" "' surounding strings and " " surounding integers
so if I thru a number in there it would look like this
sqltext = "INSERT INTO userInfo (EmailAddr,Date,Age)"
sqltext = sqltext & " VALUES ('" & addr & "', # " & day & "#, " & age & " )"
here's some a basic tutorial you can try out and see how things work.
sorry if there's some minor typos in there
hope this helps out
A language that doesn't affect the way you think about programming is not worth knowing.
admin@onpntwebdesigns.com