How do i point to a word document in an access field so that the user can click the icon and see it in word (as you would do from file manager for example)?
The simplest way is to use a Hyperlink field. Just put the path and name
of the document in the field (e.g.
C:\Documents and Settings\Username\My Documents\Folder\File.doc
It's possible to set things up so the field *stores* the entire path as
above, but just displays a more friendly name: see the Edit Hyperlink
command.
