G
Guest
I have created a form in my database which I allow users to attach supporting
documentation.
When the documents are attached I change the file name to include the record
ID number, date attached, revision level and then copy the file to a
controlled location on my server. I then only store the file path in Access
to keep the database small and fast.
When the user wants to view the file they select the name from a listbox
with writes the file path as a hyperlink code into a command button. Then the
user clicks the command button to open and view the attachment.
Q1: How could I write the code so when the user double clicks the list box
the file is opened in its correct application without the intermediate step
of clicking the command button?
documentation.
When the documents are attached I change the file name to include the record
ID number, date attached, revision level and then copy the file to a
controlled location on my server. I then only store the file path in Access
to keep the database small and fast.
When the user wants to view the file they select the name from a listbox
with writes the file path as a hyperlink code into a command button. Then the
user clicks the command button to open and view the attachment.
Q1: How could I write the code so when the user double clicks the list box
the file is opened in its correct application without the intermediate step
of clicking the command button?