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

vhung

Member
Local time
Today, 08:34
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: 233
  • accdbfiletransfer2.png
    accdbfiletransfer2.png
    186.7 KB · Views: 243
  • accdbfiletransfer3.png
    accdbfiletransfer3.png
    192.5 KB · Views: 227
Last edited:
just select any folder/file on one window, and drag it to the other.
 
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:
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?
 
...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.
 
.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
 
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).
 
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: 243
Last edited:

Users who are viewing this thread

Back
Top Bottom