Deleting files

[PayeDoc]

Hello All

Is it possible to have a button on a form that will delete certain files (if
there are any) in a specified folder?
I realise that such a thing would need to be used carefully, but provided
that I could ensure that it would, such a facility would be extremely
helpful.

The form has a textbox with a control source set to 'practiceID', and this
value would be the name of the subfolder from which files would need to be
deleted (the subfolder would always be in Z:\client folders). Also, another
textbox on the form ('notetype') has a value that would give the first 3
characters of any files that would need to be deleted.
e.g.
If the value of 'practiceID' on the form's current record is "123abc", and
the value of 'notetype' is "black", all files in Z:\client folders\123abc
where the filename started with "bla" would need to be deleted.

I am sure this can be done ... but how?!

Hope someone can help.
Many thanks
Les

 

[Allen Browne]

In the VBA windows, open help for Kill.

Dir() may help in determining if a file exists.
Example of testing for a file and/or folder:
http://allenbrowne.com/func-11.html

 

[Leslie Isaacs]

Hello Allen

That's brilliant!

The Kill command (which I had never heard of!) together with your
existence-testing functions do exactly what I needed, especially as I have
found I can build the string parameters with Left() functions and wildcards.

Many thanks indeed!
Les