I have an application that has an Access table that stores the locations of
slides in a Powerpoint file. This used to work fine when there were about 4
files and 200 slides. The database would open all four PPT files at once,
and would loop through queriers for ever client and create custom
presentations. Now there are 8 files, nearly 500 slides and the computer is
bogging down with trying to open them all at once.
I know that Access can store a hyperlink to a slide or a Word bookmark, and
I have fooled around with it. But I do not want an app where the client has
to click on a hyperlink, I'd like to query out the relevant records, have
Access "execute" the hyperlinks (for lack of a better term) and copy the
contents at the other end of the hyperlink to a file. All this with no user
interaction.
In other words, if the app involved Word docs, when it queried out a
client's records, it would use the hyperlinks to access all of the relevant
info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant
slides to a new presentation.
Can Access do this? I can work with the automation objects and open new
Word, PPT, etc and do the copy/paste if I can figure out how to get Access
to simulate a user clicking on the link.
Thanks for any info.
Alan 6 3932
On Sun, 08 Feb 2004 05:09:55 GMT, "Colleyville Alan"
<ae***********@nospam.comcast.net> wrote:
Have you considered Automation?
-Tom. I have an application that has an Access table that stores the locations of slides in a Powerpoint file. This used to work fine when there were about 4 files and 200 slides. The database would open all four PPT files at once, and would loop through queriers for ever client and create custom presentations. Now there are 8 files, nearly 500 slides and the computer is bogging down with trying to open them all at once.
I know that Access can store a hyperlink to a slide or a Word bookmark, and I have fooled around with it. But I do not want an app where the client has to click on a hyperlink, I'd like to query out the relevant records, have Access "execute" the hyperlinks (for lack of a better term) and copy the contents at the other end of the hyperlink to a file. All this with no user interaction.
In other words, if the app involved Word docs, when it queried out a client's records, it would use the hyperlinks to access all of the relevant info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant slides to a new presentation.
Can Access do this? I can work with the automation objects and open new Word, PPT, etc and do the copy/paste if I can figure out how to get Access to simulate a user clicking on the link.
Thanks for any info. Alan
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:9g********************************@4ax.com... On Sun, 08 Feb 2004 05:09:55 GMT, "Colleyville Alan" <ae***********@nospam.comcast.net> wrote:
Have you considered Automation? -Tom.
Yes - as stated below, I can work with the automation objects and open new Word, PPT, etc and do the copy/paste if I can figure out how to get
Accessto simulate a user clicking on the link.
I am happy to use automation. But I want to know if Access can use the
hyperlinks as a way to get to the data. If I determine that slides 72 and
85 of one file plus slide 63 of another file are what I want, then querying
out some records that have the hyperlinks in them would allow a user to
click them on a form and show the 3 slides. But I do not want them show; I
want them copied to a new presentation. I can do the automation coding *if*
I can have VBA and Access simulate the clicking of a hyperlink. Is there a
command that does this, that takes you to the slide a hyperlink would?
\I have an application that has an Access table that stores the locations
ofslides in a Powerpoint file. This used to work fine when there were
about 4files and 200 slides. The database would open all four PPT files at
once,and would loop through queriers for ever client and create custom presentations. Now there are 8 files, nearly 500 slides and the computer
isbogging down with trying to open them all at once.
I know that Access can store a hyperlink to a slide or a Word bookmark,
andI have fooled around with it. But I do not want an app where the client
hasto click on a hyperlink, I'd like to query out the relevant records, have Access "execute" the hyperlinks (for lack of a better term) and copy the contents at the other end of the hyperlink to a file. All this with no
userinteraction.
In other words, if the app involved Word docs, when it queried out a client's records, it would use the hyperlinks to access all of the
relevantinfo and copy it to a new Word doc. WIth PPT, it woulcd copy the
relevantslides to a new presentation.
Can Access do this? I can work with the automation objects and open new Word, PPT, etc and do the copy/paste if I can figure out how to get
Accessto simulate a user clicking on the link.
Thanks for any info. Alan
I am not familiar with the memory requirements of PPT slides but your
description of the problem hints you have maxed out on RAM and that your
computer is switching data between RAM and the harddrive as needed. Could this
be your problem?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
"Colleyville Alan" <ae***********@nospam.comcast.net> wrote in message
news:DwjVb.249480$na.415331@attbi_s04... I have an application that has an Access table that stores the locations of slides in a Powerpoint file. This used to work fine when there were about 4 files and 200 slides. The database would open all four PPT files at once, and would loop through queriers for ever client and create custom presentations. Now there are 8 files, nearly 500 slides and the computer is bogging down with trying to open them all at once.
I know that Access can store a hyperlink to a slide or a Word bookmark, and I have fooled around with it. But I do not want an app where the client has to click on a hyperlink, I'd like to query out the relevant records, have Access "execute" the hyperlinks (for lack of a better term) and copy the contents at the other end of the hyperlink to a file. All this with no user interaction.
In other words, if the app involved Word docs, when it queried out a client's records, it would use the hyperlinks to access all of the relevant info and copy it to a new Word doc. WIth PPT, it woulcd copy the relevant slides to a new presentation.
Can Access do this? I can work with the automation objects and open new Word, PPT, etc and do the copy/paste if I can figure out how to get Access to simulate a user clicking on the link.
Thanks for any info. Alan
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:jg*******************@newsread1.news.atl.eart hlink.net... I am not familiar with the memory requirements of PPT slides but your description of the problem hints you have maxed out on RAM and that your computer is switching data between RAM and the harddrive as needed. Could
this be your problem?
I have checked and it looks like there is still avail RAM. But it also
looks like PPT is having a problem; "corrupt" may be too strong a word, but
I just ran the Detect and Repair feature and it still is very slow opening
files and when I tried to run a slideshow with only 12 slides, it took about
12 seconds from when I hit "run" until the first slide came up.
My question about hyperlinks still remains since I want to use a similar
approach for managing info in Word docs. Any ideas about whether Access can
simulate clicking on a hyperlink?
<rest of msg snipped>
I'm not sure what you are asking but you can open a file programatically with:
Application.FollowHyperlink [FilePath] & "\" & [DocumentName]
Is this what you are looking for?
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
"Colleyville Alan" <ae***********@nospam.comcast.net> wrote in message
news:cxuVb.120738$U%5.599711@attbi_s03... "PC Datasheet" <sp**@nospam.spam> wrote in message news:jg*******************@newsread1.news.atl.eart hlink.net... I am not familiar with the memory requirements of PPT slides but your description of the problem hints you have maxed out on RAM and that your computer is switching data between RAM and the harddrive as needed. Could this be your problem?
I have checked and it looks like there is still avail RAM. But it also looks like PPT is having a problem; "corrupt" may be too strong a word, but I just ran the Detect and Repair feature and it still is very slow opening files and when I tried to run a slideshow with only 12 slides, it took about 12 seconds from when I hit "run" until the first slide came up.
My question about hyperlinks still remains since I want to use a similar approach for managing info in Word docs. Any ideas about whether Access can simulate clicking on a hyperlink?
<rest of msg snipped>
"PC Datasheet" <sp**@nospam.spam> wrote in message
news:qD******************@newsread1.news.atl.earth link.net... I'm not sure what you are asking but you can open a file programatically
with: Application.FollowHyperlink [FilePath] & "\" & [DocumentName]
Is this what you are looking for?
Yes, I am pretty sure that it is. I want to get to the file, then copy the
contents (e.g. a Word bookmarked section or an individual slide) back to an
open file (Word or PPT). This looks like it will do the trick. Thanks. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: C Williams |
last post by:
Hi,
I am writing some VB.NET code that compiles to a dll. There is some
code within it that manipulates Powerpoint 2003.
The dll I am writing is for smart tags, and I am having trouble...
|
by: John Smith |
last post by:
Is there anyway to convert/export/copy an Access report into a
Powerpoint slide?
I know I can publish via Excel/Word but these remove formatting etc
and therefore always require some degree of...
|
by: Jonathan Trevor |
last post by:
Hi,
For the last couple of releases of a product we're developing we've been
running to very wierd behavior from IE and our ASP.NET web application which
serves up various types of files and I'm...
|
by: C Williams |
last post by:
We are having trouble automating Powerpoint 2003 from an asp.NET web
page. I know that MS officially discourages doing such a thing, but we
are trying nonetheless.
On only one of two servers, I...
|
by: Stefan Weisenbach |
last post by:
Hi there,
I am currently working on a project to display powerpoint presentations
inside a .NET application. As I understand there is no such thing as a
ole control which can embed powerpoint...
| |
by: Viken Karaguesian |
last post by:
Hello all,
I'm making a calendar section in a website. Each month is its own page and
navigated by Previous / Next links. I have it working now with standard
hyperlinks, but I want to learn how...
|
by: PengYu.UT |
last post by:
There has been some lengthy discussion on pros and cons of Word and
Latex on the web. But for drawing figure there are also two set of
packages metapost and powerpoint(visio). I don't see much...
|
by: CodeHulk |
last post by:
This is an office automation project.
I am currently working on a document control project tracking
powerpoint, word, and excel documents. The documents are required to
have a specific style of...
|
by: =?Utf-8?B?UmlkZ2V3YXk=?= |
last post by:
I am using PowerPoint 2000 with a very large presentation with many
Hyperlinks, mostly to other slides but many also to Internet links.
Recently, some of them are not working. I correct them on...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |