Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use 'UPDATE' in MSAccess
- Thread starter mazdaman
- Start date
when you hit the submit button, the form can either submit to itself or to another where you set up the
sql="UPDATE addressbook INNER JOIN newaddress ON addressbook.PersonID = newaddress.PersonID SET newaddress.add1 = addressbook.add1"
conn.execute(sql)
where conn is your connection string
sql="UPDATE addressbook INNER JOIN newaddress ON addressbook.PersonID = newaddress.PersonID SET newaddress.add1 = addressbook.add1"
conn.execute(sql)
where conn is your connection string
Code:
<html>
<head>
</head>
<body>
<form method="post" action="<%=Request.servervariables("script_name")%>">
<!-- form inputs -->
<input type="image" name="update" src="update.gif" alt-"Update">
' form image has x and y attributes so when
' requesting value see if x value was submitted
</form>
<%
If Request.Form("update.x") <> "" Then
strSQL="UPDATE addressbook INNER JOIN newaddress ON addressbook.PersonID = newaddress.PersonID SET newaddress.add1 = addressbook.add1"
conn.execute(sql)
Response.Write "Address Updated!"
End If
%>
</body>
</html>- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question