Use Powerpoint shapes in Access forms or reports

[Dale Fye]

I'm creating an application that requires a customized chart. I've got most
of the pieces working, but now I need to put an image on the form. If I
create a shape in Powerpoint using one of the shapes (circle, oval, octacgon,
stars, ...), and then copy this shape over to Access, it pastes as an
unboundOLE object, and the Picture property states Bitmap, but not which one.

What I am really looking for is a reference to where these images exist on
my computer, so that I can create the control on the fly, and set it's bitmap
property to correct image file.

 

[Steve Rindsberg]

I'm creating an application that requires a customized chart. I've got most
of the pieces working, but now I need to put an image on the form. If I
create a shape in Powerpoint using one of the shapes (circle, oval, octacgon,
stars, ...), and then copy this shape over to Access, it pastes as an
unboundOLE object, and the Picture property states Bitmap, but not which one.

What I am really looking for is a reference to where these images exist on
my computer, so that I can create the control on the fly, and set it's bitmap
property to correct image file.

Are you simply looking to get an image out of PPT so you can reference it?

In PPT 2002 and later, select the PPT shapes you want to export, right click and
choose Save as Picture. Choose whatever format works best for you.

 

[Dale Fye]

Basically, yes, but I wanted to avoid saving new images if the ones in PPT
are already stored in a WINDOWS or Office folder somewhere.

I'll be running the app with multiple front-ends, and did not want to create
these image files on the front end machines and did not particularly want to
point to the images on the network.

I was hoping that these shape were images already stored in one of the above
mentioned folders.


--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

Steve,

Another interesting point is that when you save these shapes from PPT as you
mentioned, their background color gets saved as black rather than as white,
so you have to edit the image file.

Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Steve Rindsberg]

Basically, yes, but I wanted to avoid saving new images if the ones in PPT
are already stored in a WINDOWS or Office folder somewhere.

No, unless they're linked, they're stored within the PPT file.

 

[Steve Rindsberg]

Another interesting point is that when you save these shapes from PPT as you

mentioned, their background color gets saved as black rather than as white,
so you have to edit the image file.

Which version of PPT? I've run across this in some versions when saving via
code but not when doing it manually.

 

[Dale Fye]

2003, SP3
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

 

[Steve Rindsberg]

2003, SP3

Got a sample PPT (one or two slides, sub 1mb) you could send along for me to
have a look at?

steve at-sign pptools dot com