473,385 Members | 2,044 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

REQ: HELP WITH OPENING A PRESENTATION FROM ACCESS

daD
I am using an access front-end to open a MS P{werpoint presentation.
My problem is that when I am finished with the presentation and use
the "back" button on the toolbar to return to MS Access, MS Powerpoint
remains open. Everytime I open another presentation, the problem
repeats. Is there any way to tell Powerpoint to close or to close the
prentration when done. Thanks!
Jun 7 '06 #1
4 2129
Click the X in the upper right corner of the PowerPoint window. If there's
not one, use ALT-F4 to close the app. In your presentation, but a button on
one of the slides that closes the app. There are probably some other ways,
too.
Jun 7 '06 #2
On Tue, 06 Jun 2006 22:21:22 -0400, daD <JA********@COX.NET> wrote:

Perhaps you can share some code - I don't understand how you are
launching the PPT file (I use Automation. You?) nor what the Back
button has to do with it - smells like you're using a browser?

-Tom.
I am using an access front-end to open a MS P{werpoint presentation.
My problem is that when I am finished with the presentation and use
the "back" button on the toolbar to return to MS Access, MS Powerpoint
remains open. Everytime I open another presentation, the problem
repeats. Is there any way to tell Powerpoint to close or to close the
prentration when done. Thanks!


Jun 7 '06 #3
daD
Thanks Tom. In the button properties, I set the hyperlink address to
launch the specific file I am interested in (in my case, I open a map
in Powerpoint). When I open the map, there is a "back" button
generated that is on the toolbar in Powerpoint. If there is a way to
open a document by building an event in Visual basic, could someone
share it? I'm not too hot with VB. Thanks again!

James

On Tue, 06 Jun 2006 21:27:03 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Tue, 06 Jun 2006 22:21:22 -0400, daD <JA********@COX.NET> wrote:

Perhaps you can share some code - I don't understand how you are
launching the PPT file (I use Automation. You?) nor what the Back
button has to do with it - smells like you're using a browser?

-Tom.
I am using an access front-end to open a MS P{werpoint presentation.
My problem is that when I am finished with the presentation and use
the "back" button on the toolbar to return to MS Access, MS Powerpoint
remains open. Everytime I open another presentation, the problem
repeats. Is there any way to tell Powerpoint to close or to close the
prentration when done. Thanks!


Jun 8 '06 #4
On Wed, 07 Jun 2006 22:21:29 -0400, daD <JA********@COX.NET> wrote:

This is the Automation way of doing things:

From a code window, use Tools > References to set a reference to PPT.

In a form, have two buttons: cmdOpenPPT and cmdClosePPT.

At the module level:
Dim objPPT as PowerPoint.Application
Dim objPresentation As PowerPoint.Presentation

In the click events:
private sub cmdOpenPPT_Click()
Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True
set objPresentation = objPPT.Presentations.Open("c:\test.ppt")
end sub

private sub cmdClosePPT_Click()
objPresentation.Close
set objPresentation = nothing
set objPPT = nothing
end sub

If you install all options of PowerPoint, you will get a help file
that describes the entire object model.

-Tom.
Thanks Tom. In the button properties, I set the hyperlink address to
launch the specific file I am interested in (in my case, I open a map
in Powerpoint). When I open the map, there is a "back" button
generated that is on the toolbar in Powerpoint. If there is a way to
open a document by building an event in Visual basic, could someone
share it? I'm not too hot with VB. Thanks again!

James

On Tue, 06 Jun 2006 21:27:03 -0700, Tom van Stiphout
<no*************@cox.net> wrote:
On Tue, 06 Jun 2006 22:21:22 -0400, daD <JA********@COX.NET> wrote:

Perhaps you can share some code - I don't understand how you are
launching the PPT file (I use Automation. You?) nor what the Back
button has to do with it - smells like you're using a browser?

-Tom.
I am using an access front-end to open a MS P{werpoint presentation.
My problem is that when I am finished with the presentation and use
the "back" button on the toolbar to return to MS Access, MS Powerpoint
remains open. Everytime I open another presentation, the problem
repeats. Is there any way to tell Powerpoint to close or to close the
prentration when done. Thanks!


Jun 8 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Dariusz | last post by:
I want to use arrays in my website (flat file for a guestbook), but despite having read through countless online tutorials on the topic, I just can't get my code to work. I know there are...
2
by: John F Dutcher | last post by:
Can anyone comment on why the code shown in the Python error is in some way incorrect...or is there a problem with Python on my hoster's site ?? The highlites don't seem to show here...but line...
0
by: Tim Sawlor | last post by:
I am looking for an XML document management systems that might meet my requirements. The group I work for produces a great deal of reports and documents. These documents can be quite long (~300+...
1
by: Les | last post by:
In ancient times I had a desire to make a game and I started to do so, I quickly found the project was beyond the hardware's capability for that era (even in assembler) and had to shelf the...
8
by: Rut | last post by:
Does anyone know how to start powerpoint from vb.net without the ppt screen appearing. I want to keep it hidden? Using this code: Try pp = New PowerPoint.Application pp.Visible =...
7
by: dad | last post by:
REQ: any utilities for designing front-ends for databases
4
by: Peppie | last post by:
Hi all, I created a button in an Access form that opens MS Word. Now I want this button also to open a specific file. How do I code this? Would it also be possible to let the user select the...
10
by: james121285 | last post by:
I am having a problem with this program, I have been trying to do it all week and am stuck. I am writing a program that will take ten values from an input file, find the max and min then print them...
3
by: The Frog | last post by:
Hi guys, I have never touched really on this area before with forms and reports, and now I would like to be able to incorporate some graphs / charts for a new little app I am building, and I...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.