Adding individual photograph toa club membership database

[Guest]

I am trying , with my limited knowledge, to put together a membership
database for my Judo Club.

On each personds record i want their photo

Please help

 

[Guest]

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

 

[Dave]

Hi all.

I was trying to do something similar to this recently, but instead of typing
in the path of the file manually (these can be very long!) I wanted a find
file dialog box to pop up when I press a button, and then take the resulting
path and store it in the record.

After this just modifying the picture property to show the specific file is
pretty straight forward.

My problem was that I couldn't find the VB command to throw up the dialog
box! Any would be welcome.


Dave.

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

-----Original Message-----
I am trying , with my limited knowledge, to put together a membership
database for my Judo Club.

On each personds record i want their photo

Please help


.

 

[Tom]

Dave

look at: http://www.mvps.org/access/api/api0001.htm

Tom

Hi all.

I was trying to do something similar to this recently, but instead of
typing in the path of the file manually (these can be very long!) I wanted
a find file dialog box to pop up when I press a button, and then take the
resulting path and store it in the record.

After this just modifying the picture property to show the specific file
is pretty straight forward.

My problem was that I couldn't find the VB command to throw up the dialog
box! Any would be welcome.


Dave.

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

-----Original Message-----
I am trying , with my limited knowledge, to put together a membership
database for my Judo Club.

On each personds record i want their photo

Please help


.

 

[Dave]

Cheers Tom, worked a treat.

Dave

Dave

look at: http://www.mvps.org/access/api/api0001.htm

Tom

Hi all.

I was trying to do something similar to this recently, but instead of
typing in the path of the file manually (these can be very long!) I
wanted a find file dialog box to pop up when I press a button, and then
take the resulting path and store it in the record.

After this just modifying the picture property to show the specific file
is pretty straight forward.

My problem was that I couldn't find the VB command to throw up the dialog
box! Any would be welcome.


Dave.

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

-----Original Message-----
I am trying , with my limited knowledge, to put together
a membership
database for my Judo Club.

On each personds record i want their photo

Please help


.

 

[Guest]

I found this post really helpful but when I tried it out I got an error on
Me.Text0
I can’t figure out where this Me.Text0 comes in here, maybe I am missing
Something
Thanks

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

-----Original Message-----
I am trying , with my limited knowledge, to put together a membership
database for my Judo Club.

On each personds record i want their photo

Please help


.

 

[Douglas J. Steele]

I'd guess that Me.Text0 is a text box on the form that contains the Id of
the member.

For more information about linking to pictures, the sample imaging databases
at http://accdevel.tripod.com illustrate three approaches to handling images
in Access, and the download includes an article discussing considerations in
choosing an approach. Two of the approaches do not use OLE Objects and,
thus, avoid the database bloat, and some other problems, associated with
images in OLE Objects.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I found this post really helpful but when I tried it out I got an error on
Me.Text0
I can't figure out where this Me.Text0 comes in here, maybe I am missing
Something
Thanks

hi,
store the members photo on your hard drive. you may want
to create a photo directory in your access directory.
in our member's table put the file path to the members
photo in the members record.
put an image control on your form.
to change photo's you have to change the image control's
picture property.
Me.Image6.Picture = DLookup
("[filepath]", "Atesttable", "[id] ='" & Me.Text0 & "'")

-----Original Message-----
I am trying , with my limited knowledge, to put together a membership
database for my Judo Club.

On each personds record i want their photo

Please help


.