Pictures in tables in Access

[dsmith910]

Hi

I'm building a dbase which will eventually run a catalogue (I hope!). Each item has a picture to show what it looks like.

Can I store the pictures in the dbase, or do I reference it somehow, or.....?

As you may be able to tell - I'm pretty new to Access.

Any help would be appreciated.

Thanks

Doreen

 

[hymn]

have a look at
Thread702-289543

Hope this helps
Hymn

 

[dsmith910]

Hi Hymn

Golly!! have had a quick deckers at the thread you mention and its clear I will need to sit down with a bit of time, a slab of chocolate and a good pot of tea. Its going to take some reading.

Will let you know how (or even 'if') I go on!

Thanks

Doreen4

 

[hymn]

Yes there's lots of reading the basic thou is to LINK the pics Not to store them in the db it bloats just like me at the thought of that slab of chocolate never mind eating it

1. Place an image control on your form "imgPicture"
2. place a text box on your form "Link"

Private Sub Form_Current()
Me!ImgPicture.Picture = Me!Link
RefreshDatabaseWindow

3. Place a cmd button on your form
place the code below on the button

Me!ImgPicture.Picture = Me!Link

this will display the pic when you first type in the path if you click the button
if you keep all the pics in a single folder it will make life a little bit easier

You then need to Look up Common dialog box

two slabs of chock for that

If you get stuck let me know i will paste the code I borrowed of BillPower Fantastic Programmer who used to post here

Hope this helps
Hymn