how do i delete a text file using ACCESS VBA code

[Guest]

I am willing to delete a text file after i use it by using VBA code while my
form is running

 

[Guest]

to delete a file using VBA:
Kill "c:\yourfolder\yourfile.txt"

You may want to put some kind of if statement in to make sure the file
exists first.

Hth

Stu

 

[Jamie Collins]

I am willing to delete a text file after i use it by using VBA code while my
form is running

Tongue slightly in cheek:

CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"

Jamie.

--

 

[John W. Vinson]

I am willing to delete a text file after i use it by using VBA code while my
form is running

Tongue slightly in cheek:

CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"

Jamie.

<g>

Yeah, that'd work.

Sort of like using a helicoptor rotor as a hedge trimmer though...

John W. Vinson [MVP]

 

[John Nurick]

Sort of like using a helicoptor rotor as a hedge trimmer though...

Flying a helicopter inverted: way cool!

 

[John W. Vinson]

Flying a helicopter inverted: way cool!

Or just low to the ground... with a TALL hedge...

John W. Vinson [MVP]

 

[Jamie Collins]

Tongue slightly in cheek:

CurrentProject.Connection.Execute _
"DROP TABLE [TEXT;DATABASE=C:\FolderNameHere\;].FileNameHere#txt;"

<g>

Yeah, that'd work.

Sort of like using a helicoptor rotor as a hedge trimmer though...

I figured the OP had in the title emphasized ACCESS VBA, as distinct
from vanilla VBA, so I thought, "What's the most _*ACCESS*_ way of
deleting a file...?" ;-)

Jamie.

--

 

[John W. Vinson]

I figured the OP had in the title emphasized ACCESS VBA, as distinct
from vanilla VBA, so I thought, "What's the most _*ACCESS*_ way of
deleting a file...?" ;-)

Nah. None of us Access rubes ever use DDL; "DROP TABLE" is a foreign
language! :-{)


John W. Vinson [MVP]

 

[Jamie Collins]

I thought, "What's the most _*ACCESS*_ way of

Nah. None of us Access rubes ever use DDL; "DROP TABLE" is a foreign
language! :-{)

LOL!

Jamie.

--