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 3879
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: lllomh |
last post by:
Define the method first
this.state = {
buttonBackgroundColor: 'green',
isBlinking: false, // A new status is added to identify whether the button is blinking or not
}
autoStart=()=>{
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: tracyyun |
last post by:
Hello everyone,
I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
|
by: NeoPa |
last post by:
Hello everyone.
I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report).
I know it can be done by selecting :...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
|
by: NeoPa |
last post by:
Introduction
For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |