Macros in Access

[LLMc]

I have been trying to learn MS Access. I am trying to do some macros and I am having trouble and was wondering if I could get some help. I am trying to use a macro to open a certain PowerPoint presentation. I am able to open PowerPoint, but I can't open it with the presentation I want. It opens with a blank presentation and I don't know the path to open it and run a certain presentation. Your help would be a greatly appreciated.

Lou

[smurfy]

Try something like this...

Dim myPPT as Object
set myPPT = GetObject("c:\path\filename.ppt")
myPPT.Application.Visible = True
...
set myPPT = nothing

[LLMc]

Try something like this...

Dim myPPT as Object
set myPPT = GetObject("c:\path\filename.ppt")
myPPT.Application.Visible = True
...
set myPPT = nothing

Thank you for your reply. I really don't understand this, so I think I've gotten in over my head. It seems this is more like programing, which I really know nothing about. I asked a friend of mine and he said that it should open by typing the path to the PowerPoint presentation. He said when it gets to the presentation that windows should know what to open it with. I doon't know why it's not working. I'm going to try a few other things and see what happens. What I am trying to do is to set up a database with our youth group praise and worship songs. I wanted to do a macro that would open the song's presentation right from the Access database. Again, thank you very much for replying. I was beginning to think I wasn't going to get one.
Lou