I Need A Upload Browser File Box, Please Help :-( (Access 2010)

[Alphix]

I am racking my brain on how to do this. How can I call up a upload browser file box?

Actions:
(01) The user clicks on the button
(02) A upload message box pops up
(03) User presses the browser button to find the file to be uploaded
(04) User presses upload
(05) The file is transfered to an unseen folder location for storage

The Main Access database file is held on the main network location.
The saved uploaded files held in a different location.

Please see attachment:
Example Upload.zip (19.5 KB)




Edit Post: 03-11-16
There was an error. I have tried other coded buttons with no success.

I have thought more of what actions I want from this.

I want the user to click the button
Browse for a file
Select the file
The file is transferred to another location folder for storage.
The dialog box closes.

It is almost like when we click the browse button on this forum when we want to upload an attachment.
Except instead the file is not saved to the database but transferred to the off located folder.

Is it possible that this can be done? Please Help :-(
Example Upload Button.zip

[vicsaccess]

what i'm not understanding is where are the files coming from that need to be uploaded to an external file?

[ssanfu]

but transferred to the off located folder

Not sure if you want a copy or a move to happen....

I modified your code to move a file to a different location on your network. See the comments to change it to a copy.

Also, you will need to change the destination path to your destination path.

You can use a mapped (local) drive path:
Const NewFilePath As String = "F:\Forum\Example Upload"

or use the Network path:
Const NewFilePath As String = "\\Server1\Archive1"