From: Dustirhode on
How do I show different pictures in individual Access database records (forms
view)?
From: Mark on
You need to store the pictures in a separate folder from the database. Add a
field named PicturePath to your table and record the full path to the
picture for each record. Add an image control to your form. Be sure you have
PicturePath in the recordsource of your form. Put the following code in the
Current Event of the form:
Me!NameOfYourImageControl.Picture = Me!PicturePath.

Steve



"Dustirhode" <Dustirhode(a)discussions.microsoft.com> wrote in message
news:7275670B-9347-45B5-8AC3-B6416D4EBF07(a)microsoft.com...
> How do I show different pictures in individual Access database records
> (forms
> view)?


From: StopThisAdvertising on

"Mark" <notmy(a)email.com> schreef in bericht news:LpudnVw68-G4xvvVnZ2dnUVZ_gOdnZ2d(a)earthlink.com...
> You need to store the pictures in a separate folder from the database. Add a
> field named PicturePath to your table and record the full path to the
> picture for each record. Add an image control to your form. Be sure you have
> PicturePath in the recordsource of your form. Put the following code in the
> Current Event of the form:
> Me!NameOfYourImageControl.Picture = Me!PicturePath.
>
> Steve
>

--
Hey Mark/Steve!! We don't need you here !!
Hey Mark/Steve!! We don't want you here !!

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (updated, mainly the 'abuse-reporting' page...)
Until now 5825+ pageloads, 3650+ first-time visitors
(these figures are real and rapidly increasing)

Why is this ???
Because Steve is the ONLY person here who continues to advertise in the groups.

It is not relevant whether he advertised in *this* particular post or not...
==> We want him to know that these groups are *not* his private hunting grounds!

For those who don't like too see all these messages:
==> Simply killfile 'StopThisAdvertising'.
Newbees will still see this warning-message.

ArnoR
From: Tanya on
Hello Mark
I am trying to achieve the same objective, however I don't fully understand
your instructions.

"Mark" wrote:

> You need to store the pictures in a separate folder from the database. DONE

Add a
> field named PicturePath to your table DONE

and record the full path to the picture for each record. HOW DO YOU DO
THIS, WHAT DATA TYPE IS THIS?

Add an image control to your form I WILL CONTEMPLATE THIS MORE WHEN I
UNDERSTAND YOUR EARLIER INSTRUCTIONS.
.. Be sure you have
> PicturePath in the recordsource of your form. Put the following code in the
> Current Event of the form:
> Me!NameOfYourImageControl.Picture = Me!PicturePath.

Thanking you in advance

Kind Regards
Tanya


From: Fred on
Tanya,

Answering your one question, you can use a text field, and it's simply the
path and file name for the picture. e.g C:\PictureFolder\picture1.jpg

Fred




"Tanya" wrote:

> Hello Mark
> I am trying to achieve the same objective, however I don't fully understand
> your instructions.
>
> "Mark" wrote:
>
> > You need to store the pictures in a separate folder from the database. DONE
>
> Add a
> > field named PicturePath to your table DONE
>
> and record the full path to the picture for each record. HOW DO YOU DO
> THIS, WHAT DATA TYPE IS THIS?
>
> Add an image control to your form I WILL CONTEMPLATE THIS MORE WHEN I
> UNDERSTAND YOUR EARLIER INSTRUCTIONS.
> . Be sure you have
> > PicturePath in the recordsource of your form. Put the following code in the
> > Current Event of the form:
> > Me!NameOfYourImageControl.Picture = Me!PicturePath.
>
> Thanking you in advance
>
> Kind Regards
> Tanya
>
>