Inserting OLE Object into table via VBA

R

RRetzko

I have a database that compiles international student
information for college entrance. Colleges request
specific student profiles that I send on an xls export.
Creating the xls is a one-click snap. Here's the problem:
After I click on the 'Create xls' button, I want to save
an OLE link into a tblReportsArchive.

I'm using a currentdb.execute(INSERT INTO tblRecords
(col1, col2, col3) VALUES (str1, str2, str3)) command
that does the insert perfectly for the institution, name
of requester, file name, but I don't know how to code
this for the object link.

Any help is appreciated!

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top