Images in Forms

[Hamlet]

I have a Access 2000 database storing user information for access to a third
party application. Passport size photographs of each user, obtained through
the third party application, will be stored in a directory below the
application and database.

A form has been designed to allow the administrator to view/edit an
individual users' details. Can I link an image item on the form to a
photograph in the sub directory using a sub path and variable rather than
embedding a OLE object i.e. ..\images\{picnum}.bmp where {picnum} is assigned
by the application as the users unique ID.

I need to store the photographs seperately for other reasons and this would
cut down on the size of the database.

Thanks in advance.

 

[Klatuu]

Yes, use a Hyperlink data type.

 

[fredg]

I have a Access 2000 database storing user information for access to a third
party application. Passport size photographs of each user, obtained through
the third party application, will be stored in a directory below the
application and database.

A form has been designed to allow the administrator to view/edit an
individual users' details. Can I link an image item on the form to a
photograph in the sub directory using a sub path and variable rather than
embedding a OLE object i.e. ..\images\{picnum}.bmp where {picnum} is assigned
by the application as the users unique ID.

I need to store the photographs seperately for other reasons and this would
cut down on the size of the database.

Thanks in advance.

In Form Single View display?
Use an Image control.

Store the picture name in a field in each record, i.e. [Picnum].
You can then set the Image Control's Picture property in the form's
Detail Section:
Me!ImageName.Picture = "C\PathToFolder\" & [Picnum] & ".bmp"

The above assumes the picture name is something like "2345.bmp".

 

[Hamlet]

Many thanks Fred

Took me a little while to work out the logic, as I am not that familiar with
VBasic, but you certainly pointed me in the right direction.

I have a Access 2000 database storing user information for access to a third
party application. Passport size photographs of each user, obtained through
the third party application, will be stored in a directory below the
application and database.

A form has been designed to allow the administrator to view/edit an
individual users' details. Can I link an image item on the form to a
photograph in the sub directory using a sub path and variable rather than
embedding a OLE object i.e. ..\images\{picnum}.bmp where {picnum} is assigned
by the application as the users unique ID.

I need to store the photographs seperately for other reasons and this would
cut down on the size of the database.

Thanks in advance.

In Form Single View display?
Use an Image control.

Store the picture name in a field in each record, i.e. [Picnum].
You can then set the Image Control's Picture property in the form's
Detail Section:
Me!ImageName.Picture = "C\PathToFolder\" & [Picnum] & ".bmp"

The above assumes the picture name is something like "2345.bmp".

 

[jong]

I have similar case as that I am using OLE object link to display picture on
the personnel data form with MS-Access 2000 but it displays the picture file
name only. I tried the same form with MS-Access 97 and got same result then
I installed the Value Pack for Access97 to fix the problem. My question is
that is there similar Value Pack Access2000? And where can I get it?

Many thanks Fred

Took me a little while to work out the logic, as I am not that familiar with
VBasic, but you certainly pointed me in the right direction.

I have a Access 2000 database storing user information for access to a third
party application. Passport size photographs of each user, obtained through
the third party application, will be stored in a directory below the
application and database.

A form has been designed to allow the administrator to view/edit an
individual users' details. Can I link an image item on the form to a
photograph in the sub directory using a sub path and variable rather than
embedding a OLE object i.e. ..\images\{picnum}.bmp where {picnum} is assigned
by the application as the users unique ID.

I need to store the photographs seperately for other reasons and this would
cut down on the size of the database.

Thanks in advance.

In Form Single View display?
Use an Image control.

Store the picture name in a field in each record, i.e. [Picnum].
You can then set the Image Control's Picture property in the form's
Detail Section:
Me!ImageName.Picture = "C\PathToFolder\" & [Picnum] & ".bmp"

The above assumes the picture name is something like "2345.bmp".