How to insert OLE OBJECT (WORD) from the submit button into a table

[sunilvedula]

Hi All,

i am designing a database for my company. They enter all the details and also they will require to attach a word doc which needs to be looked whenever necessary. for example they should be able to enter all details like acct no, refe no and along with this the doc associated with the item. What i want is end - user should be able to input a word doc (which already exists) and if he does a search based on the refnumber given for the item he should be able to get that doc and once clicked should be able to view it. Is it possible. i have tried with ole objects but since i am very new i did not know how to insert the object into the table using code or retrieve it .

 

[DCrake]

Here is a file that looks in a specified folder for any type of file you specifiy. This can be hard coded or not. It displays them in a list box and if you then double click on an item in the listbox it will open up the document in its native software.

You should be able to adapt this to meet your needs.

David