How to programmatically load/ref pics in DB?

[victorcamp]

How do I programmatically load or refresh images in an Access 97 OLE field?
The images are BMP and displayed using a Bound Object Frame.

I can't find any direct code (e.g., AppendChunk, etc.), since Access always
converts the image to its own internal structure.

I've tried SendKeys followed by the DoCmd.RunCommand acCmdInsertObject
statement, but no matter how I send the keystrokes (e.g., SendKeys "%(FE)",
True), when it then opens the Insert window there's no sign of the
keystrokes sent (whether I say True or False). It's like it takes so long
for the Insert window to open that it forgets the sent keys.

Surely there's a way to do this?

--Vic

[Larry Linson]

Take a look at the sample databases at http://accdevel.tripod.com -- they
illustrate three approaches to handling images in Access, one of which is
with OLE Objects. But, if you are using bitmaps, either of the techniques
using Image controls will work even if the graphics filters aren't loaded.
There's an article included in the download discussing considerations in
choosing which approach to use.

Larry Linson
Microsoft Access MVP

"victorcamp" <vi*******@worldnet.att.net> wrote in message
news:JH*********************@bgtnsc05-news.ops.worldnet.att.net...

How do I programmatically load or refresh images in an Access 97 OLE field? The images are BMP and displayed using a Bound Object Frame.

I can't find any direct code (e.g., AppendChunk, etc.), since Access always converts the image to its own internal structure.

I've tried SendKeys followed by the DoCmd.RunCommand acCmdInsertObject
statement, but no matter how I send the keystrokes (e.g., SendKeys "%(FE)", True), when it then opens the Insert window there's no sign of the
keystrokes sent (whether I say True or False). It's like it takes so long
for the Insert window to open that it forgets the sent keys.

Surely there's a way to do this?

--Vic