I am building a licensing database in MS Access 2003 that tracks licensing for my company. I would like to add the ability to browse to a license file (a .pdf file) and upload it. Ideally what would happen is the user would click a command button and be prompted with a browse window. They would then browse to the directory of the license and click upload. This would then rename the file to a dynamic name defined by a field on my form. It would then copy that file to a directory also defined by a dynamic field on my form. This field for right now would contain a static directory but at a later time could be re-written with a dynamic directory.
" Original file name: License.pdf
" Name of field on form that contains new file name: [txtRenewalFileName]
" After renaming the file copy it to [txtUploadDirectory]
Then I would just use the FollowHyperlink Me.txtFileLocation command to call the file with a command button.
See attached screenshot for screen example.