MS Access & Powerpoint VBA Code

[Gijsbert]

Dear Accessors,

My name is, as you can see, Gijsbert, and I'm from Holland.
I've made databases from Access for a University, a logistic organisation, a yoga-studio and more.
My intention is to give help to those stumbling with code and query's.
Yet I'm building a base with all songtexts from church to display them in a PowerPoint Presentation.
Although it works, the template to use is a problem to solve.
Any help is really welcome!

With kind regards,

Gijsbert

 

[PlayMisty]

Re: Dear Accessors

Although it works, the template to use is a problem to solve.

Can you explain this a lot more.

And welcome to the site.

 

[Sue22]

Re: Dear Accessors

Welcome aboard, your project sound interesting

 

[Gijsbert]

Re: Dear Accessors

Can you explain this a lot more.

And welcome to the site.

Dear Misty, yes I can:
Probably you're able to help me with this.

I have a PowerPoint Template with two fields named Liturgie and Tekst.
I want to open a new presentation
Dim ppApp As PowerPoint.Application
Set ppApp = CreateObject("Powerpoint.Application")
Dim ppPres As PowerPoint.Presentation
Set ppPres = ppApp.Presentations.Add(msoTrue)
Now I want a template use while filling in the Liturgie and the text of a song.
Those I have in variables and they have to be on a specific place on the template.
The textfields on that template are named Liturgie and songtext.
If I say:
ppPres.ApplyTemplate ("D:\Files\StartsjabloonBoZ.pot")
the template is not taken, but how it will?
I don't know yet. Glad you will help!

With kind regards,

Gijsbert

 

[Gijsbert]

Yet I'm busy to make my own solution:
I create a standard PPT with all forms the same.
Then I open it in Access and fill in all fields.
Maybe I can remove not used slides later.
Thanks to PlayMisty for thinking with me and writing my own problem down.

Gijsbert