S
sue
Hi everyone,
How do I delete all rows in a table through code?
Sue
How do I delete all rows in a table through code?
Sue
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dan Artuso
Hi Sue,
Dim strSql as String
strSql = "Delete From yourTableHere"
CurrentDb.Execute strSql, dbFailOnError
Dim strSql as String
strSql = "Delete From yourTableHere"
CurrentDb.Execute strSql, dbFailOnError
S
Sue
Thanks Dan,
Can I use the same sort of thing to update a value in a
one column table with no primary key. I am holding a
date there you see.
my table is called tbllastsync
the column or field is called datelastsync
I want to update the current value to todays date.
My thinking was to delete it then write it as today but
setting to defailt doesnt have the desired effect.
thanks again
sue
Can I use the same sort of thing to update a value in a
one column table with no primary key. I am holding a
date there you see.
my table is called tbllastsync
the column or field is called datelastsync
I want to update the current value to todays date.
My thinking was to delete it then write it as today but
setting to defailt doesnt have the desired effect.
thanks again
sue
message news:[email protected]...-----Original Message-----
Hi Sue,
Dim strSql as String
strSql = "Delete From yourTableHere"
CurrentDb.Execute strSql, dbFailOnError
--
HTH
Dan Artuso, Access MVP
"sue" <[email protected]> wrote in
D
Dan Artuso
Hi,
Do you mean you want to update the all rows of the datelastsync
field to today's date?
Or do you want to somehow identify one row to be updated?
If all rows:
Dim strSql as String
strSql = "Update tblastsync Set datelastsync = #" & Date() & "#"
CurrentDb.Execute strSql, dbFailOnError
Do you mean you want to update the all rows of the datelastsync
field to today's date?
Or do you want to somehow identify one row to be updated?
If all rows:
Dim strSql as String
strSql = "Update tblastsync Set datelastsync = #" & Date() & "#"
CurrentDb.Execute strSql, dbFailOnError
S
Sue
Thanks I adapted it.
Brilliant
Brilliant
message news:[email protected]...-----Original Message-----
Hi,
Do you mean you want to update the all rows of the datelastsync
field to today's date?
Or do you want to somehow identify one row to be updated?
If all rows:
Dim strSql as String
strSql = "Update tblastsync Set datelastsync = #" & Date () & "#"
CurrentDb.Execute strSql, dbFailOnError
--
HTH
Dan Artuso, Access MVP
"Sue" <[email protected]> wrote in