Delete Files Based On a Text Field

[isladogs]

"C:\Folder1\Folder2"
"C:\Folder1\Folder2\ "

Ok if you add a trailing space
How peculiar .... must be a new bug
Moral is of course to always use code tags....

 

[Learn2010]

Here is my last attempt. The control is on a subform.

Start of Code
strCustID = Forms!frmMain!frmMainSub!Form!control

Kill "C:\Folder1\Folder2" & '" & strCustID & "'"
End of Code

I get a syntax error on the second line.

 

[isladogs]

As I said in post #7

Add a backslash after Folder2

 

[Learn2010]

My mistake. I did.

Kill "C:\Folder1\Folder2" & '" & strCustID & "'"

 

[Gasman]

My mistake. I did.

Kill "C:\Folder1\Folder2" & '" & strCustID & "'"

As has been amply demonstrated, the site removes the last backslash if in quotes and not in code tags.

If you post within code tags and copy and paste the code we can see exactly what you have.

FWIW although it is a string I would have stuck with

Kill "C:\Folder1\Folder2\" & lngCustID

and assigned CustomerID to lngCustID

Gets rid of all the quote matching?

 

[Learn2010]

Can you give me an example of using code tags.

 

[RuralGuy]

Highlight your code and then press the "#" sign in the tool bar.

 

[Gasman]

Can you give me an example of using code tags.

Click the # icon and post between the tags, then look to see what is generated.

 

[isladogs]

I used them in post 3.
To do so, use the # button in the toolbar above your post.
If you can't see it, click the Advanced button

Example:

strCustID = Forms!frmMain!frmMainSub!Form![COLOR="Red"]control[/COLOR]

Kill "C:\Folder1\Folder2\" & '" & strCustID & "'"

The first line of code is referencing a control in a subform from the main form.
However I'm sure you don't have a control called control.
Use the actual control name instead
If it is called 'control', rename it or you'll have loads of problems

 

[Learn2010]

#
strCustID = Forms!frmMain!frmMainSub!Form!control Kill "C:\Folder1\Folder2" & '" & strCustID & "'"
#

Like this?

Also, the control is not named control

 

[RuralGuy]

Here's a link with code tag examples: https://access-programmers.co.uk/forums/showthread.php?t=240420

 

[isladogs]

#
strCustID = Forms!frmMain!frmMainSub!Form!control Kill "C:\Folder1\Folder2" & '" & strCustID & "'"
#

Like this?

Also, the control is not named control

NO

To do so, use the # button in the toolbar above your post.
If you can't see it, click the Advanced button

And I don't suppose its Folder1 or Folder2 either.
Please don't rename items. It doesn't help. In fact it just causes confusion.

 

[Learn2010]

Got it.

strCustID = Forms!frmMain!frmMainSub!Form![COLOR=Red]controlname[/COLOR] 
 Kill "C:\Folder1\Folder2\ " & '" & strCustID & "'"

 

[isladogs]

And you've got the code tags too....

Now if that is called controlname, please rename it
If not, see my previous comment about using actual names.

 

[Learn2010]

It is not called controlname.

Thank you.

 

[Gasman]

OK, think about what you are trying to get and what you have.?

You have coded for a space after the last backslash.?
Do you ever see that in real life?

Then as it is a string it just needs to be added to the first string?

"C:\Folder1\Folder2\"

then we need the variable

"C:\Folder1\Folder2\" & strCustID

Got it.

strCustID = Forms!frmMain!frmMainSub!Form![COLOR=Red]controlname[/COLOR] 
 Kill "C:\Folder1\Folder2\ " & '" & strCustID & "'"