Importing an OLE object using VBA

[rainbowrabbit]

I have a small database designed to log requests for work my team receives. One of the requirements is to be able to attach files to each request (*.msg, *.xls, *.txt, *.doc, *.pdf etc etc) and the name of the file.

I know I can do a form and the users can right click to import an object however it doesn't import the filename.

I would like the users to use the open file dialog functionality to select a file to import. I can get the dialog box to work fine to select the particular file and get the filename but I am struggling to find out how to actually embed the file into the database.

Anyone got any ideas if this is possible?

 

[MajP]

You can do this, but I would recommend strongly against it. You call it a small database, it will not be after importing a few OLE. If you add .5 meg file your db will increase in size far greater than that.
You can do whaterver you want this to do by storing the path. You can show it in the database without problem, why embed it?

 

[rainbowrabbit]

why embed it indeed!!

thanks for waking me up to myself MajP!