How do I build an event that will move all files on a camera to a destination folder on my hard dri

[Don]

I tried FileCopy and Name but it seems that they only allow one file to
be moved. I want to my user to be able to plug in a camera and click a
button that will move the files from the camera to a folder on the hard
drive. I believe that the camera becomes the E: drive when plugged in
so it should be just like moving files from one drive to another. Any
help with the code?

 

[Pieter Wijnen]

Use the Dir Function

Const Dest="C:\Pictures"
Dim fil As String

Fil = Dir("E:\*.jpg")
While Len(Fil)
FileCopy Fil, Dest
Fil=Dir()
Wend

I believe there's a Searching Sub-Folders for files function available at
http://www.mvps.org/Access

Pieter

 

[Pieter Wijnen]

Use the Dir Function

Const Dest="C:\Pictures"
Dim fil As String

Fil = Dir("E:\*.jpg")
While Len(Fil)
FileCopy Fil, Dest
Fil=Dir()
Wend

I believe there's a Searching Sub-Folders for files function available at
http://www.mvps.org/Access

Pieter

Why would you want to use MS Access to do this function?

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

--