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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Clearing an Access table from Visual Basic
- Thread starter JasonV
- Start date
edderic
Programmer
- May 8, 1999
- 628
- 0
- 0
g_sql = "DELETE FROM Table "<br>
g_sql = g_sql & "WHERE ADVNR = " & CStr(advnr)<br>
g_sql = g_sql & " AND VOLGNR = " & CStr(volgnr)<br>
g_db.Execute g_sql<br>
<br>
g_db is the location of the database<br>
<br>
Eric<br>
<br>
<p>Eric De Decker<br><a href=mailto:vbg.be@vbgroup.nl>vbg.be@vbgroup.nl</a><br><a href= Basic Center</a><br>
g_sql = g_sql & "WHERE ADVNR = " & CStr(advnr)<br>
g_sql = g_sql & " AND VOLGNR = " & CStr(volgnr)<br>
g_db.Execute g_sql<br>
<br>
g_db is the location of the database<br>
<br>
Eric<br>
<br>
<p>Eric De Decker<br><a href=mailto:vbg.be@vbgroup.nl>vbg.be@vbgroup.nl</a><br><a href= Basic Center</a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
