S
ScottA
I have a database where users store information about
their documents (a mix of Word and Adobe PDF files), and
am having trouble figuring out how to make this work:
From the document record form, I have added a button that
should let the user set the location of the actual file on
the file server, and another button that should display
the document in the application that created it using the
Shellexecute API call.
I've experimented with some of the API code available on
the Access MVP site, specifically the API call that opens
the standard Windows File Open/Save dialog - but don't
quite know where to go from there! How do I take the
results of the Open/Save dialog (the document selected by
the user) and save it to the document record? Should I be
saving the UNC path in a text field or save the object as
an OLE Object (I don't want to save the document in the
database, just a reference to its location on the file
server).
Any suggestions would be appreciated.
Thanks!
Scott A
their documents (a mix of Word and Adobe PDF files), and
am having trouble figuring out how to make this work:
From the document record form, I have added a button that
should let the user set the location of the actual file on
the file server, and another button that should display
the document in the application that created it using the
Shellexecute API call.
I've experimented with some of the API code available on
the Access MVP site, specifically the API call that opens
the standard Windows File Open/Save dialog - but don't
quite know where to go from there! How do I take the
results of the Open/Save dialog (the document selected by
the user) and save it to the document record? Should I be
saving the UNC path in a text field or save the object as
an OLE Object (I don't want to save the document in the
database, just a reference to its location on the file
server).
Any suggestions would be appreciated.
Thanks!
Scott A