Problems with linked images in access

[chrisse_2]

Hi,

I am working with images which vary depending on what record you are
looking at. The images are linked into my database using vba code. I
would like the user to be able to double click on the image and have it
open up in the respective program on the computer. Is this possible?

Also, i have multiple images for some records. I have no problem
setting up the code to view the images, the problem i am having is when
you are scrolling through the records and come across a record with
multiple images. The form will load these images but when you move on,
or even back, to another record with one picture it shows the image
from the current record you are viewing and the rest of the images from
the previous record. I believe i need some sort or requery happening
with the pictures but can not figure it out.

 

[Guest]

Hi Chrisse,

If you happen to have Access 2002 available, take a look at the Employees
form in the sample Northwind database. This example uses linked pictures,
although it includes just one image for each record. I would think the copy
of Northwind that comes with Access 2003 would be similar, but I don't know
this for sure. (The Access 2000 version uses embedded images, so this example
won't be too helpful).

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi,

I am working with images which vary depending on what record you are
looking at. The images are linked into my database using vba code. I
would like the user to be able to double click on the image and have it
open up in the respective program on the computer. Is this possible?

Also, i have multiple images for some records. I have no problem
setting up the code to view the images, the problem i am having is when
you are scrolling through the records and come across a record with
multiple images. The form will load these images but when you move on,
or even back, to another record with one picture it shows the image
from the current record you are viewing and the rest of the images from
the previous record. I believe i need some sort or requery happening
with the pictures but can not figure it out.

 

[chrisse_2]

Hey Tom,

I do have access 2003 but do not have the northwind database that comes
with it. I have tried to download it from the microsoft website but can
only get a hold of the 2000 version where the images are embeded. Do
you know where i might be able to get it from?

Thanks

Christina

 

[Guest]

Hi Christina,

Have you searched your hard drive? This file might already be installed on
your PC:

Location of the Northwind sample files in Access 2003
http://support.microsoft.com/?id=824265

If not, do you have your installation CD handy? You can select the first
option, which likely reads something similar to what I see for Office 2002:

"Add or Remove Features-Change which features are installed or remove
specific features".

When you click Next, select "Microsoft Access for Windows", followed by
"Sample Databases" and then "Northwind Database". Better yet, left click
"Microsoft Access for Windows", and then select "Run all from My Computer" to
add any missing components.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hey Tom,

I do have access 2003 but do not have the northwind database that comes
with it. I have tried to download it from the microsoft website but can
only get a hold of the 2000 version where the images are embeded. Do
you know where i might be able to get it from?

Thanks

Christina
__________________________________________

:

Hi Chrisse,

If you happen to have Access 2002 available, take a look at the Employees
form in the sample Northwind database. This example uses linked pictures,
although it includes just one image for each record. I would think the copy
of Northwind that comes with Access 2003 would be similar, but I don't know
this for sure. (The Access 2000 version uses embedded images, so this example
won't be too helpful).

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi,

I am working with images which vary depending on what record you are
looking at. The images are linked into my database using vba code. I
would like the user to be able to double click on the image and have it
open up in the respective program on the computer. Is this possible?

Also, i have multiple images for some records. I have no problem
setting up the code to view the images, the problem i am having is when
you are scrolling through the records and come across a record with
multiple images. The form will load these images but when you move on,
or even back, to another record with one picture it shows the image
from the current record you are viewing and the rest of the images from
the previous record. I believe i need some sort or requery happening
with the pictures but can not figure it out.

 

[?????]

Hi,

I am working with images which vary depending on what record you are
looking at. The images are linked into my database using vba code. I
would like the user to be able to double click on the image and have it
open up in the respective program on the computer. Is this possible?

Also, i have multiple images for some records. I have no problem
setting up the code to view the images, the problem i am having is when
you are scrolling through the records and come across a record with
multiple images. The form will load these images but when you move on,
or even back, to another record with one picture it shows the image
from the current record you are viewing and the rest of the images from
the previous record. I believe i need some sort or requery happening
with the pictures but can not figure it out.

 

[Larry Linson]

No, the pictures are not re-queried. They are set in code, and nothing has
reset them. The very best way to handle these is to create a one-by-one
pixel (or few-by-few pixels) image in the background color and set every
control, every record. Set the images in the picture property of the first
few, then set the "no-picture" image for all the others.

Larry Linson
Microsoft Access MVP