I
IdeaMan
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