How to insert a file shortcut in a form session

  • Thread starter Thread starter CAD Fiend
  • Start date Start date
C

CAD Fiend

Hello,

I am creating a form from a table that is intended to replace the manual
paper-based system of logging in work order requests. My question is
this:

In the table, there will be one field whose function is to allow the
form user to place a "link" or "shortcut" in that particular field.
That way, when we later open up the form (or table) to read it, there
will be the "link" or "shortcut" for us to access the file off of the
server. The actual size of most of the files (90% or so) will be less
than 1mb, consisting of mostly TIFF, JPEG, PDF, or AutoCAD file formats.

I don't want the form user to actually put the file in the database,
though. I'd prefer it if they could just place the shortcut, so as to
minimize the size of the database.

Is this possible?

Or, is there a better way to do this?

Also, since this is kind of a table structured question, should I be
posting it the micro....access.tablesdesign NG instead?

TIA.
 
A shortcut is nothing more than a path to a file that has an associated
program that opens it. So what you need is to store paths. I have 2 demo
applications thaat look for particular filetypes (1 for Word/text and the
other graphics) they are similar in the way they work and either could be
easily modified to build tables to store the paths. You could then open the
files using a file handler. Have a look at the following:

http://www.datastrat.com/Download/DocMgr_2K.zip
http://www.datastrat.com/Download/Picture2K.zip
http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks. I will take a look at these.

Arvin said:
A shortcut is nothing more than a path to a file that has an associated
program that opens it. So what you need is to store paths. I have 2 demo
applications thaat look for particular filetypes (1 for Word/text and the
other graphics) they are similar in the way they work and either could be
easily modified to build tables to store the paths. You could then open the
files using a file handler. Have a look at the following:

http://www.datastrat.com/Download/DocMgr_2K.zip
http://www.datastrat.com/Download/Picture2K.zip
http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top