I
IdeaMan
Guest
Windows 2000
Access 97
I am working on an issue tracking DB, where I need to link (not attach due
to size) screen prints of various system errors.
I have created a public folder on a network drive to store these images, under the assumption that no one will originally save them to that location. To resolve this, I need to copy the file to this location without possibility of user error in selecting the correct folder (the DB is to be used by many people spanning a great distance). I am using the "API: Drag and Drop from Explorer" code found at http://www.mvps.org/access/api/api0032.htm and have successfully implemented it, where it displays the full local/original path to the file in the listbox on the form you create to house the code. This is a perfect (and user friendly) interface to select the file itself and even allows me to record the original path to where the file was saved, but have been unable to find a way to pass this file name/path to a FileCopy command or even the ahtCommonFileOpenSave dialog box.
Am I overlooking any better, simpler, or more efficient way of doing this-or is it even possible? Out of frustration, the code that I have been experimenting with has become rather incomprehensible so I did not post it with this message. I have searched newsgroups high and low for a solution over the last few days and in turn have said goodbye to a few more hairs on my head.
Any help or examples anyone could provide would be greatly appreciated as I need to resolve this issue quickly and it would also help me better understand how Access code works.
Thanks!
Michael
Access 97
I am working on an issue tracking DB, where I need to link (not attach due
to size) screen prints of various system errors.
I have created a public folder on a network drive to store these images, under the assumption that no one will originally save them to that location. To resolve this, I need to copy the file to this location without possibility of user error in selecting the correct folder (the DB is to be used by many people spanning a great distance). I am using the "API: Drag and Drop from Explorer" code found at http://www.mvps.org/access/api/api0032.htm and have successfully implemented it, where it displays the full local/original path to the file in the listbox on the form you create to house the code. This is a perfect (and user friendly) interface to select the file itself and even allows me to record the original path to where the file was saved, but have been unable to find a way to pass this file name/path to a FileCopy command or even the ahtCommonFileOpenSave dialog box.
Am I overlooking any better, simpler, or more efficient way of doing this-or is it even possible? Out of frustration, the code that I have been experimenting with has become rather incomprehensible so I did not post it with this message. I have searched newsgroups high and low for a solution over the last few days and in turn have said goodbye to a few more hairs on my head.
Any help or examples anyone could provide would be greatly appreciated as I need to resolve this issue quickly and it would also help me better understand how Access code works.
Thanks!
Michael
