Hi,



I have an access 2000 database that's in design mode.  I have a form, that 

should display a picture, along with records associated with it. What I 

want to be able to do, is have them click a command button to open a box 

that will allow them to choose the picture file they want to put for that 

record (similar to the box that appears when you go to File > Open -- in 

vb I guess it's called a Directory List Box) -- but I want to be able to 

choose the drive letter, directory and file.



I'm not sure if I want the pictures embedded at this point (will that 

hinder performance?) -- I can cross that bridge when I get to it.  I just 

want the open box to work so I can import the picture, or somehow link the 

current record to the picture I choose.



Thanks in advance!



ps.-- please be detailed as possible, newbs don't always get all the 

Access lingo



J.

assuming that you have vstudio.



the easiest way to do it is use the showopen from the commondialog control 

(microsoft common dialog control 6.0 in project | components).  this 

actually opens a window that allows you to navigate your disk folders just 

as you would on an office File | Open.



as for embedding the pictures, you end up filling your database with blob 

images and it ultimately has a negative impact on your application 

performance.



best way ive found is to design a good storage structure on some file server 

and save path links to the particular pictures in the database.  but that is 

just my opinion.....



david adams



>

>Hi,

>

>I have an access 2000 database that's in design mode.  I have a form, that

>should display a picture, along with records associated with it. What I

>want to be able to do, is have them click a command button to open a box

>that will allow them to choose the picture file they want to put for that

>record (similar to the box that appears when you go to File > Open -- in

>vb I guess it's called a Directory List Box) -- but I want to be able to

>choose the drive letter, directory and file.

>

>I'm not sure if I want the pictures embedded at this point (will that

>hinder performance?) -- I can cross that bridge when I get to it.  I just

>want the open box to work so I can import the picture, or somehow link the

>current record to the picture I choose.

>

>Thanks in advance!

>

>ps.-- please be detailed as possible, newbs don't always get all the

>Access lingo

>

>J.

You probably don't want to copy the picture into your record if you 

already have them in a table within the same database.  this will increase 

the size

and decrease the speed of your database.  what you can do is when you 

select the picture you want to add to the record, is to add the primary id 

to the record

that you want to add the picture into.  Make sure that you have the 

foreign key in the table first.



good luck,





>>> "Jon" <jsaam@m...> 08/15 8:11 PM >>>

Hi,



I have an access 2000 database that's in design mode.  I have a form, 

that

should display a picture, along with records associated with it. What I

want to be able to do, is have them click a command button to open a 

box

that will allow them to choose the picture file they want to put for 

that

record (similar to the box that appears when you go to File > Open -- 

in

vb I guess it's called a Directory List Box) -- but I want to be able 

to

choose the drive letter, directory and file.



I'm not sure if I want the pictures embedded at this point (will that

hinder performance?) -- I can cross that bridge when I get to it.  I 

just

want the open box to work so I can import the picture, or somehow link 

the

current record to the picture I choose.



Thanks in advance!



ps.-- please be detailed as possible, newbs don't always get all the

Access lingo



J.