using jpg outside MDB

  • Thread starter Thread starter Benny Eckert
  • Start date Start date
B

Benny Eckert

Hi everyone,

I want to use JPG (pictures) in my forms and reports without actually
inserting them into my tables (since this takes up a huge amount of space).
Is there a way to make a kind of "automatic link" that makes a call to the
jpg-file in a different location each time that record is used?

Thx
Benny
 
Hi Benny,

If you are using Access 2002 the Northwind sample database
uses an example of this on the Employees Form that you can
look at. (Choose Help|Sample Databases)

If it's Access 2000 take a look at the following Microsoft
article that discusses a method to do this (with a bit of
tweaking it may work with Access 97 too)

http://support.microsoft.com/?id=210100
(ACC2000: How to Display an Image from a Folder in a Form
or in a Report)

hth

chas
 
On Forms handle the 'Form_Current' event and load the file into an image control.

On Reports do the same in the 'Detail_Format' event.

The filename can come directly from the table or be generated from an Id, for example. If the images are
all located in the same place then generate the full path in code, eg relative to the DB file itself or
using a configuration variable, or a UNC path on a network.
 
Benny Eckert said:
I want to use JPG (pictures) in my forms and reports without actually
inserting them into my tables (since this takes up a huge amount of space).
Is there a way to make a kind of "automatic link" that makes a call to the
jpg-file in a different location each time that record is used?
Click to expand...

Download the free sample database that shows you exactly how to do this,
with all the code you need.

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top