Populate OLE Objects from VBA

[Roy]

I'm using Microsoft Access 2002. I have a table with a
field called [Image] with a data type of "OLE Object". I
can create a simple form with a bound image control, run
the form, right click on the control, create a link to a
photoshop image file. All works nicely.

How do I do this directly from VBA? So that I can run
through several thousand images and populate the [Image]
field with a reference to the photoshop files without
going through the manual process above? I've looked
everywhere, and the closest I get is a reference to an
OLE Moniker - now I'm stuck.

Any help greatly appreciated.

-Roy
(also posted in "active.documents" forum)

 

[Oz]

Just testing a pet theory - this forum results in a HUGE
increase in virus-loaded spam. From 20 or so assorted
messages without viruses per day to 200+ messages loaded
with trojans and other nasties. All within a few hours of
posting here. Mostly it's the fake Microsoft Update email.

Makes me wish I'd never posted here - 'specially since I
solved the problem anyway.

 

[Oz]

Well, there you go - Proven!

Within 2 hours of posting with a unique email address, I
received my first set of virus-loaded emails! Folks, this
place is virus hell!

Learning: NEVER use a real email address in forums like
this. I guess I knew that before but never had the
experience of such a concerted attack to hammer home the
reason!

Anyhow, bye everyone!

Oz is signing off... forever... well, I don't really
exist... do I?