Modify a location route depending on the information contained into a field

[charly.csh]

Hello everyone



Does somebody know how to modify a location route depending on the information contained into a field?

Into my form I have a field named "Code_ID" (textbox) and also a buttom named "attachcmd"

After the event Attachcmd_Onclick I need the attached information will be recorded on this location:


"C:\Users\General\Desktop\ 'On this part of the path I want to add "Me.Code_ID" \


How Do I modifiy this part of the code?

Thanks for all the support!!!

[pbaldy]

Like

"C:\Users\General\Desktop\" & Me.Code_ID

[charly.csh]

Yes, it works pretty good, just a quick question....

When I using this code a messagebox is shown and the says:

Run-Time error '70'
Permission denied
End Debug.....

When I click on debug the error is in the red below:


Dim sourceFolder As String, destinationFolder As String
Dim aFSO As Object
Dim Direccion As String
Dim Destination As String


Direccion = Me.Problemsupporttxt

'Me.Problem support is a route pre-selected




sourceFolder = Direccion


destinationFolder = "C:\Users\General\Resultado\" & Me.Code_ID


Set aFSO = CreateObject("Scripting.FileSystemObject")


aFSO.CopyFile sourceFolder, destinationFolder


End Sub

When I delete the "Me.Code_Id" it copies the file but into the location expected

Thanks for the support

[pbaldy]

Do you have appropriate permissions on both source and destination folders? Does the variable resolve to a valid path? You can use this to see the variable values:

BaldyWeb-Immediate window

[ssanfu]

Also, you have this line:

destinationFolder = "C:\Users\General\Resultado\" & Me.Code_ID

Lets assume that Me.Code_ID = "Trial".

Then the path looks like "C:\Users\General\Resultado\Trial"

Does the "Trial" folder exist? If it doesn't, you have to create the directory before you can save anything into it.

[charly.csh]

Yes, this folder exists and it's created before

[charly.csh]

in fact that was the problem on that folder!!!

I solved just adding

destinationFolder = "C:\Users\General\Resultado\" & Me.Code_ID + "\"

and it worked now!!

Thanks so much for the help!!!

[pbaldy]

Glad you got it sorted. I'd use & to concatenate rather than +, which can be used but being a math operator will sometimes produce unexpected results.