Connecting Tech Pros Worldwide Help | Site Map

How to programmatically load/ref pics in DB?

victorcamp
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

re: How to programmatically load/ref pics in DB?


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" <victorgcs@worldnet.att.net> wrote in message
news:JHfpb.25078$Ec1.2267666@bgtnsc05-news.ops.worldnet.att.net...[color=blue]
> How do I programmatically load or refresh images in an Access 97 OLE[/color]
field?[color=blue]
> The images are BMP and displayed using a Bound Object Frame.
>
> I can't find any direct code (e.g., AppendChunk, etc.), since Access[/color]
always[color=blue]
> 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[/color]
"%(FE)",[color=blue]
> 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
>
>
>[/color]


Closed Thread