Linking with other docs

[Guest]

Hi all

I am wanting to create a access database for a call logging system, the user
will fill out the form designed in access but then I want to be able to
link/import excel/word documents into the database.

Is this possible? if so how?

Thanks

 

[Guest]

Yes it is possible, even not too difficult to make happen!

You need to create an event, could be double-click on the given field or a
buton click-event, which would launch the standard Windows File Open/Save
dialog box which allows your user to go and select the file they want. Then
simply take their selection and add it to the field.

For the Windows File Open/Save dialog box take a look at
http://www.mvps.org/access/api/api0001.htm

Whether it be an image, document,... for a database it is all handled the
same way. With this in mind look at
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album
as it uses this technique to allow the user's to add images to the db. You
need only change the filter from selecting images (jpg,gif,bmp) to suit your
needs (doc,xls,...).