Delete a Files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo

I hope some one can help i want delete some files when clicking on my exit
button on my form i have the path and file names saved in a table. I know how
to use the kill command when deleting one files but now i have a list of
files which i can get from my table but i have no idea how the code needs to
look like i hope some one can help

Regards
Markus
 
hi Markus,
I hope some one can help i want delete some files when clicking on my exit
button on my form i have the path and file names saved in a table. I know how
to use the kill command when deleting one files but now i have a list of
files which i can get from my table but i have no idea how the code needs to
look like i hope some one can help
Click to expand...
You need do loop through your datasets, e.g.

Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("Table")
Do While Not rs.Eof
Kill rs![Path] & rs![File]
rs.Next
Loop


mfG
--> stefan <--
 
Thank you Stefan

Stefan Hoffmann said:
hi Markus,
I hope some one can help i want delete some files when clicking on my exit
button on my form i have the path and file names saved in a table. I know how
to use the kill command when deleting one files but now i have a list of
files which i can get from my table but i have no idea how the code needs to
look like i hope some one can help
Click to expand...
You need do loop through your datasets, e.g.

Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("Table")
Do While Not rs.Eof
Kill rs![Path] & rs![File]
rs.Next
Loop


mfG
--> stefan <--
Click to expand...
 
Back
Top