Create Powerpoint Slide from Access VBA

[icepaw]

Hi All,

I'm having a problem trying to produce a powerpoint slide direct from Access that contains a graphic. I have managed to produce textboxes and populate them with data from a table, but when I try to add a graphic image (either from a file on my pc or pulled from the net) I get an error on the code line im using


With .Shapes(2).TextFrame.TextRange
.Text = CStr(rs.Fields("QT_Desc").Value)
.Characters.Font.Color.RGB = RGB(255, 0, 255)
.Characters.Font.Shadow = True
End With

With .Shapes(3)
.AddPicture(CStr(rs.Fields("ML_Image").Value), msoFalse, msoTrue, 60, 35, 98, 48)
End With


I've search the net, and now :banghead:

Any help gratefully received

 

[isladogs]

Try looking at the 5 links at the bottom of this page. I remember AWF member JHB creating a very good example

 

[icepaw]

Thanks Colin

Unfortunately, I can't see the links or images as I have only 2 posts (apparently minimum is 10 to see links) arrrrggggggggghhhhhhhh lol

Anyway it was kind of you to reply I'll try and find the entry from JHB....in the mean time if you can think of a way of posting more clues to the links....I would be very thankful


Cheers

Paul

 

[isladogs]

I was referring to the similar threads section at the bottom of this page. I thought that was visible for new users and also guests.
If not, let me know and I'll add those links in a later reply.

The JHB post was a reply to another user's problem and it's from sometime in 2017 IIRC.

EDIT It's probably this thread Https://www.access-programmers.co.uk/forums/showthread.php?t=291319&highlight=Powerpoint. See post 9

 

[icepaw]

Hi Colin

No …. No links until 10 posts....(I'm 6 away)…..might just try and add some line to other general links.....don't want to get a reputation as someone who adds to forums for the sake of typing rubbish lol

 

[isladogs]

I believe you are wrong.
I just logged out, then returned as a guest to this page.
The similar threads were still visible and active at the bottom of the page.

What you can't do is post a link until you've reached 10 posts.
Anyhow the JHB link I provided may be exactly what you want.

 

[icepaw]

Ok...now I'm feeling really foolish....just seen the section your referring to.....not a great start to my time on here

Will now try and check the JHB link

Thanks once again

Paul

 

[isladogs]

No problem..i haven't looked at any of those links apart from JHB's example.
Ignore the clunkiness of the example. He used the database supplied by the OP.