Solved Accdb: File Transfer (from path copy to path) (1 Viewer)

vhung

Member
Local time
Today, 07:20
Joined
Jul 8, 2020
Messages
235
How to transfer file from one folder to another or from C: to D: using vba codes... "on MSACCESS using two web browser on AccdbForm"
<<<Dim FSO As Object
Dim FromPath As String
Dim ToPath As String>>>
...nice and quite good, now i have three ways of copy/transfer files using "My Accdb File Transfer Form" to any hard disk partition of my CPU....
 

Attachments

  • accdbfiletransfer.png
    accdbfiletransfer.png
    136.9 KB · Views: 190
  • accdbfiletransfer2.png
    accdbfiletransfer2.png
    186.7 KB · Views: 192
  • accdbfiletransfer3.png
    accdbfiletransfer3.png
    192.5 KB · Views: 186
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:20
Joined
May 7, 2009
Messages
19,175
just select any folder/file on one window, and drag it to the other.
 

vhung

Member
Local time
Today, 07:20
Joined
Jul 8, 2020
Messages
235
just select any folder/file on one window, and drag it to the other.
for quite sometimes; but dragging is not the main goal even right click is also applicable, but my goal is to select any file by clicking it or by typing object name then click a transfer button with permissions...
 
Last edited:

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 09:20
Joined
Feb 28, 2001
Messages
27,003
To select a file by clicking, you have a couple of options.

One involves you providing a list of potential files from something your program does. In brief, use the DIR() command to create a collection of files; make that collection feed a combo box; select one from the combo box.

The other involves using the file system object to give you a fully browseable window where when you click on a file then click OK you select that file name. Or double-click the file name and you don't need the OK.

Which way were you heading?
 

Isaac

Lifelong Learner
Local time
Today, 07:20
Joined
Mar 14, 2017
Messages
8,738
...nice and quite good, now i have three ways of copy/transfer files
So was this post a question and a request for help? Or just to share that you have 3 successful ways of copying files? I'm confused.

Just in case it was actually a question, the 3 things that come to my mind are
  1. FileCopy
  2. Name As
  3. Scripting File System Object

I generally prefer the File System Object. The reason is that if I use the other ones, inevitably after a while I realize more file-related code is needed to check this or that, etc., at which point if I already have the fullest-featured method queued up (FSO), it's easier than using a different method and then having to queue up FSO anyway.
 

Dreamweaver

Well-known member
Local time
Today, 14:20
Joined
Nov 28, 2005
Messages
2,466
.nice and quite good, now i have three ways of copy/transfer files using "My Accdb File Transfer Form" to any hard disk partition of my CPU..
You could alway post it to the examples I'm sure there are quite a few who would find it interesting.

mick
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:20
Joined
May 7, 2009
Messages
19,175
check the image the OP shared, he is using 2 webbrowser control.
he needs to know which file name, using the webbrowser controls, he clicked, so he can
do the manual copying (fso, vba, etc).
 

vhung

Member
Local time
Today, 07:20
Joined
Jul 8, 2020
Messages
235
You could alway post it to the examples I'm sure there are quite a few who would find it interesting.

mick
sir: thank you...
 

Attachments

  • accdbfiletransfer.png
    accdbfiletransfer.png
    136.9 KB · Views: 197
Last edited:

Users who are viewing this thread

Top Bottom