Inserting a PPT slide into a Report Form

[Sol]

Hi gurus,
I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job.
What it does:
When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process.
For this, "Blinds" are being inserted between the vessel and the rest of the process.
For this, we have 2 things to help in the planning-stage:
1. Blind list DB
2. Blind List Drawings. (In PowerPoint form)
They are in separate folders.
I managed to fix up the Blind list DB (with my limited experience), but I also would like to have the Drawings appear on the same report form as the blind list report. This would make the DB more user friendly. If some friendly soul could point me into the right direction, I would appreciate that very much.
There are about 600 different vessels and 600 different Drawings.
The DB is made with Access 97. Sorry 'bout that. You know all those oil companies, how poor they are :-).
Any hints on how to marry the DB with Drawings would be greatly appreciated.

Best regards
Frank

[Phil Stanton]

Re: Inserting a PPT slide into a Report Form

It might be worth looking at http://support.microsoft.com/kb/210075

Phil
"Sol" <news.tpg.com.a uwrote in message news:4809d703@d news.tpgi.com.a u...
Hi gurus,
I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job.
What it does:
When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process.
For this, "Blinds" are being inserted between the vessel and the rest of the process.
For this, we have 2 things to help in the planning-stage:
1. Blind list DB
2. Blind List Drawings. (In PowerPoint form)
They are in separate folders.
I managed to fix up the Blind list DB (with my limited experience), but I also would like to have the Drawings appear on the same report form as the blind list report. This would make the DB more user friendly. If some friendly soul could point me into the right direction, I would appreciate that very much.
There are about 600 different vessels and 600 different Drawings.
The DB is made with Access 97. Sorry 'bout that. You know all those oil companies, how poor they are :-).
Any hints on how to marry the DB with Drawings would be greatly appreciated.

Best regards
Frank

[Sol]

Re: Inserting a PPT slide into a Report Form

Thanks for the tip Phil, I will.
Best
Frank
"Phil Stanton" <phil@myfamilyn ame.co.ukwrote in message news:acSdnU1Sq8 IaE5fVnZ2dneKdn ZydnZ2d@plusnet ...
It might be worth looking at http://support.microsoft.com/kb/210075

Phil
"Sol" <news.tpg.com.a uwrote in message news:4809d703@d news.tpgi.com.a u...
Hi gurus,
I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job.
What it does:
When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process.
For this, "Blinds" are being inserted between the vessel and the rest of the process.
For this, we have 2 things to help in the planning-stage:
1. Blind list DB
2. Blind List Drawings. (In PowerPoint form)
They are in separate folders.
I managed to fix up the Blind list DB (with my limited experience), but I also would like to have the Drawings appear on the same report form as the blind list report. This would make the DB more user friendly. If some friendly soul could point me into the right direction, I would appreciate that very much.
There are about 600 different vessels and 600 different Drawings.
The DB is made with Access 97. Sorry 'bout that. You know all those oil companies, how poor they are :-).
Any hints on how to marry the DB with Drawings would be greatly appreciated.

Best regards
Frank

[Steve]

Re: Inserting a PPT slide into a Report Form

Hi Frank,

I would like to see if I can help you. I also worked for an oil company as an engineer in the 90s. When we did turnaround maintenance I too had to prepare blind lists for vessels. If you would like my help, contact me at rlaird@penn.com.

Thanks!

Steve
"Sol" <news.tpg.com.a uwrote in message news:4809d703@d news.tpgi.com.a u...
Hi gurus,
I work for an oil company and need to fix an old DB, which used to work once. It will help us poor operators to do a safer job.
What it does:
When maintenance on a vessel is planned, the vessel needs to be isolated from the rest of the process.
For this, "Blinds" are being inserted between the vessel and the rest of the process.
For this, we have 2 things to help in the planning-stage:
1. Blind list DB
2. Blind List Drawings. (In PowerPoint form)
They are in separate folders.
I managed to fix up the Blind list DB (with my limited experience), but I also would like to have the Drawings appear on the same report form as the blind list report. This would make the DB more user friendly. If some friendly soul could point me into the right direction, I would appreciate that very much.
There are about 600 different vessels and 600 different Drawings.
The DB is made with Access 97. Sorry 'bout that. You know all those oil companies, how poor they are :-).
Any hints on how to marry the DB with Drawings would be greatly appreciated.

Best regards
Frank

[Bob Quintal]

Re: Inserting a PPT slide into a Report Form

Frank,

beware of Steve, he sells himself. Others in this group provide help
for free.

Bob

"Steve" <Email@Invalid. comwrote in
news:brOdnUuEhP no9ZbVnZ2dnUVZ_ qiinZ2d@earthli nk.com:

Hi Frank,
>
I would like to see if I can help you. I also worked for an oil
company as an engineer in the 90s. When we did turnaround
maintenance I too had to prepare blind lists for vessels. If you
would like my help, contact me at rlaird@penn.com.
>
Thanks!
>
Steve

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

[Arno R]

Re: Inserting a PPT slide into a Report Form


"Bob Quintal" <rquintal@sPAmp atico.caschreef in bericht news:Xns9A867D4 3DD82EBQuintal@ 66.175.223.2...

"Steve" <Email@Invalid. comwrote in
news:brOdnUuEhP no9ZbVnZ2dnUVZ_ qiinZ2d@earthli nk.com:


If you are not the same Steve@invalid.c om that was such a pest here
last year, my apologies. If you are the same steve, go away.

Same Steve indeed.

He *should* have learned... <sigh>
Shame.

Arno R

[Tony Toews [MVP]]

Re: Inserting a PPT slide into a Report Form

"Steve" <Email@Invalid. comwrote:

>Go buy a watch and M.Y.O.B. !!!

Yup, same Steve.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Sol]

Re: Inserting a PPT slide into a Report Form

Hi Gurus,

Sorry to stir up old "memories" but the question still remains.
How do I insert a PowerPoint slide graphic into an Access97 report form.
http://support.microsoft.com/kb/210075 tells me that I apparently will need
Access 2003.
Can it be done with Access97? If so, how?
Thanks fellas.
Best regards
Frank



"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote in message
news:p7m11416jd 2h42gs13dgo3ivo 58evkf8nq@4ax.c om...

"Steve" <Email@Invalid. comwrote:
>

>>Go buy a watch and M.Y.O.B. !!!

>
Yup, same Steve.
>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Arno R]

Re: Inserting a PPT slide into a Report Form


"Sol" <news.tpg.com.a uschreef in bericht news:4811937e$1 @dnews.tpgi.com .au...

Hi Gurus,

Sorry to stir up old "memories" but the question still remains.
How do I insert a PowerPoint slide graphic into an Access97 report form.
http://support.microsoft.com/kb/210075 tells me that I apparently will need
Access 2003.
Can it be done with Access97? If so, how?
Thanks fellas.
Best regards
Frank

It is not clear to me what you want with ... "an Access97 report form"
Do you need to display some ppt sheets in a form or in a report?

Code a http://support.microsoft.com/kb/210075 is working with Access97
Just tested that. Follow the instructions
It displays a ppt presentation in a form and you are able to navigate the ppt presentation
You should be able to adapt the code to your needs I guess.

BTW: I guess it would be much easier to display graphic's. No need to open a ppt.
Vessels are numbered (Unique ID like 1234)?
Create jpg's like 1234.jpg. Display the corresponding jpg in a pictureframe.

Arno R

[Larry Linson]

Re: Inserting a PPT slide into a Report Form

"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote

>>Go buy a watch and M.Y.O.B. !!!

>
Yup, same Steve.

Surely does read as if it is. <SIGH Finances must be gettin' tight around
the 'Santus' household for him to subject himself to the exposure and
ridicule he knows that he'll get here. He's got another new e-mail, though.

Larry

[Arno R]

Re: Inserting a PPT slide into a Report Form


"Larry Linson" <bouncer@localh ost.notschreef in bericht news:GOrQj.91$l c6.15@trnddc04. ..

"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote

>Go buy a watch and M.Y.O.B. !!!

Yup, same Steve.

Surely does read as if it is. <SIGH Finances must be gettin' tight around
the 'Santus' household for him to subject himself to the exposure and
ridicule he knows that he'll get here. He's got another new e-mail, though.

Larry

Nothing new Larry. . .
From the website about Steve. Page: 'A few characteristics and facts'
"Steve answered as Kristine, signed as Tom and provided rlaird@penn.com as a mailaddress to send him some code."
This was 2003 <sigh>

Arno R

[Larry Linson]

Re: Inserting a PPT slide into a Report Form

"Arno R" <arracomn_o_s_p _a_m@planet.nlw rote

Nothing new Larry. . . From the website about Steve.
Page: 'A few characteristics and facts' "Steve answered
as Kristine, signed as Tom and provided rlaird@penn.com
as a mailaddress to send him some code."
This was 2003 <sigh>

I guess they had to cut back on the number of flippers at the burger joint.
Pity.

Larry

[Bob Quintal]

Re: Inserting a PPT slide into a Report Form

"Tony Toews [MVP]" <ttoews@teluspl anet.netwrote in
news:p7m11416jd 2h42gs13dgo3ivo 58evkf8nq@4ax.c om:

"Steve" <Email@Invalid. comwrote:
>

>>Go buy a watch and M.Y.O.B. !!!

>
Yup, same Steve.
>
Tony

He must have been released on parole.

--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **