MS Access - Insert Object > Create From FIle > Link

[jkpalmer52]

I have a MS Access database table that contains two columns. My table definintion description for this post is structured as Fieldnameatatype:Comment.

ID:text 12 rimary key
PDFImage:OLEobject:none

I have a folder (C:\PDFFolder) that contains many files (PDFs).

CCS12311.PDF
CDS12312.PDF
CES12313.PDF
and so on

I'd like to create a process which will insert a row for each file in my PDFFolder giving the ID the value of the filename (8.3) and which creates a link in the PDFImage column to each PDF in my C:\PDFFolder.

I can create process to insert into the table the ID values, but I'm having trouble finding any examples of VB code which will populate the PDFImage column with the valid link.

Can't seem to find the proper class/method to do this programmatically.

Help would be appreciated.

-jP

 

[BillPower]

Hi jkpalmer52

Not absolutely sure what you're after but I have a working example of how to create a Hyperlink to a file at

http://www.wpower.fsbusiness.co.uk/

The files to look at are CommonDialogAccess97.zip and CommonDialogAccess2000.zip

With a little tweaking I'm almost certain this will do what you want.

Bill