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

I tried FileCopy and Name but it seems that they only allow one file to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13785-how-do-i-build-event-will.html
be moved. I want to my user to be able to plug in a camera and click a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
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?


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Don wrote:
> 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?

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785

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-HowToSea...#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.

--
Joseph Meehan

Dia duit

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



"Joseph Meehan" wrote in message
news:PWSwg.35628$vl5.13419@tornado.ohiordc.rr.com. ..
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
> Don wrote:
>> 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?
>
> 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-HowToSea...#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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
>
> --
> Joseph Meehan
>
> Dia duit
>

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



"Joseph Meehan" wrote in message
news:PWSwg.35628$vl5.13419@tornado.ohiordc.rr.com. ..
> Don wrote:
>> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
>> to another. Any help with the code?
>
> 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-HowToSea...#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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13785
>
> --
> Joseph Meehan
>
> Dia duit
>



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4285 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len