Access 2000: Can I use a key to pick up a picture?

  • Thread starter Thread starter C.C.
  • Start date Start date
C

C.C.

Hallo all,

If this is not the correct NG to post this, please let me know.


To keep my question short and simple:

1st field, Key (length 8), something like AZ532018
2nd field, Photo (Ole-object, linked)

Matching picture is: f:\pic\AZ532018.jpg

Is it possible to (automatically) get this picture using the content of
the key-field?

Greetings,
C.C.
 
Hallo all,

If this is not the correct NG to post this, please let me know.


To keep my question short and simple:

1st field, Key (length 8), something like AZ532018
2nd field, Photo (Ole-object, linked)

Matching picture is: f:\pic\AZ532018.jpg

Is it possible to (automatically) get this picture using the content of
the key-field?

Greetings,
C.C.
Click to expand...

Add an Image control to the Report.
In the whatever section the picture is to be displayed in, code it's
Format event:

Me!ImageName.Picture = "f:\pic\" & [KeyFieldName] & ".jpg"
 
Fred said:
Add an Image control to the Report.
In the whatever section the picture is to be displayed in, code it's
Format event:
Me!ImageName.Picture = "f:\pic\" & [KeyFieldName] & ".jpg"
Click to expand...

Thank you for answering.
I'm afraid though I don't know what to do, because I'm very new at this.
I'm trying to learn Access for an upcoming project and worked my way
through a basic course the last few days.
In the meantime I'm also looking ahead to the 'problems' we might
encounter and this question is one of 'm.

I'm not familiar _yet_ with programming in Access, although I do
understand that in the above line you're building the filename of the
picture. It looks simple, but I don't know how or where to put this
line.

I hate to bother folks with futile questions, so if there's anyone who
knows of a site where I can get more info about this stuff, please let
me know.


Thank you,
C.C.
-----------------------------------------------------------------
For email:
put an extra 'e' in the mailaddress. 'kes' should read 'kees'




----Original Message---------------------------------------------
To keep my question short and simple:

1st field, Key (length 8), something like AZ532018
2nd field, Photo (Ole-object, linked)

Matching picture is: f:\pic\AZ532018.jpg

Is it possible to (automatically) get this picture using the
content of the key-field?
-----------------------------------------------------------------
 
Back
Top