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

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

Phil
"Sol" <news.tpg.com.auwrote in message news:4809d703@dnews.tpgi.com.au...
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

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

Phil
"Sol" <news.tpg.com.auwrote in message news:4809d703@dnews.tpgi.com.au...
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

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.auwrote in message news:4809d703@dnews.tpgi.com.au...
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

Frank,

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

Bob

"Steve" <Email@Invalid.comwrote in
news:brOdnUuEhPno9ZbVnZ2dnUVZ_qiinZ2d@earthlink.co m:

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 **

"Bob Quintal" <rquintal@sPAmpatico.caschreef in bericht news:Xns9A867D43DD82EBQuintal@66.175.223.2...

"Steve" <Email@Invalid.comwrote in
news:brOdnUuEhPno9ZbVnZ2dnUVZ_qiinZ2d@earthlink.co m:


If you are not the same Steve@invalid.com 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

"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/

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@telusplanet.netwrote in message
news:p7m11416jd2h42gs13dgo3ivo58evkf8nq@4ax.com...

"Steve" <Email@Invalid.comwrote:
>

>
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" <news.tpg.com.auschreef 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

"Tony Toews [MVP]" <ttoews@telusplanet.netwrote

>
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

"Larry Linson" <bouncer@localhost.notschreef in bericht news:GOrQj.91$lc6.15@trnddc04...

"Tony Toews [MVP]" <ttoews@telusplanet.netwrote

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

"Arno R" <arracomn_o_s_p_a_m@planet.nlwrote

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

"Tony Toews [MVP]" <ttoews@telusplanet.netwrote in
news:p7m11416jd2h42gs13dgo3ivo58evkf8nq@4ax.com:

"Steve" <Email@Invalid.comwrote:
>

>
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 **