🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #449

!!! PROBLEM: Thumbnails/Previews of XLS - DOC files !!!

#449
From: Borealis Beringen Engineering
Date: Thu, 21 Aug 1997 00:00
44 lines
2047 bytes
Hi,

We are using Access2.0.

I have created a database that controls multiple documents of our company.
They where all created in Word or Excel.

There is also a form that makes it possible to search for certain
documents.

Now, here is the problem, they asked me to display a little thumbnail or
preview
of the document in the record that is currently active.

The record contains the directory and filename where the document is
stored.

I tried serveral things:
	
	1. Create a bound OLE field and link the corresponding document.
	BUT	then the database is becoming to big because double information is
being
		stored. (OLE + DIR&FILENAME)

	2. Insert an unbound OLE object in the form where the source automatically
	    is being updated to the DIR&FILENAME when the "ON_CURRENT" event
occurs.
	BUT	i didn't find a way to change the source of an unbound OLE object on a
form.

Is there anybody out there, that has the same problem,
OR EVEN BETTER A SOLUTION,

Please let me know at
bor.ber.eng@pophost.eunet.be
or in this newsgroup

Tnx alot,

BOELEN Werner
Borealis Engineering
Beringen
BELGIUM
Technical Details
Message-ID: <01bcae37$23efbe80$64c879c1@benginet1>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,c4dae634147f5cdd,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,c4dae634147f5cdd,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 102b1d,c4dae634147f5cdd,start
X-Google-Attributes: gid102b1d,public
X-Google-Thread: ff0ac,c4dae634147f5cdd,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: fe218,c4dae634147f5cdd,start
X-Google-Attributes: gidfe218,public
From: "Borealis Beringen Engineering" <bor.ber.eng@pophost.eunet.be>
Subject: !!! PROBLEM: Thumbnails/Previews of XLS - DOC files !!!
Date: 1997/08/21
Message-ID: <01bcae37$23efbe80$64c879c1@benginet1>
X-Deja-AN: 268571357
Organization: EUnet Belgium, Leuven, Belgium
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.formscoding