FileCopy results in runtime error 53 file not found

[Bob]

I'm not sure why this is happening. Using Access 2003. My code is as
follows...

Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

FileCopy strSourceFile, strDestinationF ile

End Sub

Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combinations with the same result.

My code seems consistent with help file example syntax.

Can anyone suggest what is causing this or know a work around?

Thanks in Advance!

Bob

[salad]

Bob wrote:

I'm not sure why this is happening. Using Access 2003. My code is as
follows...

Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

FileCopy strSourceFile, strDestinationF ile

End Sub

Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combinations with the same result.

My code seems consistent with help file example syntax.

Can anyone suggest what is causing this or know a work around?

Thanks in Advance!

Bob

In your immediate (debug) window enter
strSourceFile = "C:\Test.tx t"
? dir(strSourceFi le)

Does it return the file name or does it return a blank line? If blank,
the file can't be found.

[Bob]

On Feb 1, 2:01 pm, salad <o...@vinegar.c omwrote:

Bob wrote:

I'm not sure why this is happening. Using Access 2003. My code is as
follows...

Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

FileCopy strSourceFile, strDestinationF ile

End Sub

Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combinations with the same result.

My code seems consistent with help file example syntax.

Can anyone suggest what is causing this or know a work around?

Thanks in Advance!

Bob

In your immediate (debug) window enter
strSourceFile = "C:\Test.tx t"
? dir(strSourceFi le)

Does it return the file name or does it return a blank line? If blank,
the file can't be found.- Hide quoted text -

- Show quoted text -

Thanks for getting back to me!

I did as you suggested and got a runtime error 13 - Type mismatch.

I declared strSourceFile as a String, should it be something else?

Bob

[salad]

Bob wrote:

On Feb 1, 2:01 pm, salad <o...@vinegar.c omwrote:

>>Bob wrote:

>>>I'm not sure why this is happening. Using Access 2003. My code is as
follows...

>>>Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

>> strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

>> FileCopy strSourceFile, strDestinationF ile

>>>End Sub

>>>Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combinatio ns with the same result.

>>>My code seems consistent with help file example syntax.

>>>Can anyone suggest what is causing this or know a work around?

>>>Thanks in Advance!

>>>Bob

In your immediate (debug) window enter
strSourceFile = "C:\Test.tx t"
? dir(strSourceFi le)

Does it return the file name or does it return a blank line? If blank,
the file can't be found.- Hide quoted text -

- Show quoted text -

Thanks for getting back to me!

I did as you suggested and got a runtime error 13 - Type mismatch.

I declared strSourceFile as a String, should it be something else?

Bob

I'm not sure. In the Debug window you don't declare variables. You
have to enter each line followed by the enter key to run the line.

Your code looks fine. DOn't know why it's failing.

[John Mishefske]

Bob wrote:

On Feb 1, 2:01 pm, salad <o...@vinegar.c omwrote:

>>Bob wrote:

>>>I'm not sure why this is happening. Using Access 2003. My code is as
follows...

>>>Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

>> strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

>> FileCopy strSourceFile, strDestinationF ile

>>>End Sub

>>>Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combinatio ns with the same result.

>>>My code seems consistent with help file example syntax.

>>>Can anyone suggest what is causing this or know a work around?

>>>Thanks in Advance!

>>>Bob

In your immediate (debug) window enter
strSourceFile = "C:\Test.tx t"
? dir(strSourceFi le)

Does it return the file name or does it return a blank line? If blank,
the file can't be found.- Hide quoted text -

- Show quoted text -

Thanks for getting back to me!

I did as you suggested and got a runtime error 13 - Type mismatch.

I declared strSourceFile as a String, should it be something else?

Try this in the Immediate window:

? Dir("c:\Test.tx t")

If the file exist then it should return "Test.txt"

--
'---------------
'John Mishefske
'---------------

[Bob]

On Feb 1, 3:08 pm, John Mishefske <jmishefsk...@S PAMyahoo.comwro te:

Bob wrote:

On Feb 1, 2:01 pm, salad <o...@vinegar.c omwrote:

>Bob wrote:

>>I'm not sure why this is happening. Using Access 2003. My code is as
follows...

>>Private Sub Command1_Click( )
Dim strSourceFile As String
Dim strDestinationF ile As String

> strSourceFile = "C:\Test.tx t"
strDestinationF ile = "C:\TextFile\te st2.txt"

> FileCopy strSourceFile, strDestinationF ile

>>End Sub

>>Test.txt exists and is located in the c: directory. I've also tried
different variations of the code with other directory and file
combination s with the same result.

>>My code seems consistent with help file example syntax.

>>Can anyone suggest what is causing this or know a work around?

>>Thanks in Advance!

>>Bob

>In your immediate (debug) window enter
strSourceFile = "C:\Test.tx t"
? dir(strSourceFi le)

>Does it return the file name or does it return a blank line? If blank,
the file can't be found.- Hide quoted text -

>- Show quoted text -

Thanks for getting back to me!

I did as you suggested and got a runtime error 13 - Type mismatch.

I declared strSourceFile as a String, should it be something else?

Try this in the Immediate window:

? Dir("c:\Test.tx t")

If the file exist then it should return "Test.txt"

--
'---------------
'John Mishefske
'---------------- Hide quoted text -

- Show quoted text -

This is really strange...
I went into the c:\Folder
Tools
Folder options
View
and unchecked hide extensions for known file types
Now the code operates as it should.