SockMonkey
IS-IT--Management
I have created a form that will take the file path information and display a photo in an image frame without storing it in Access, thus saving space. Right now you have to manually enter in the file path and file name information into fields.
Fields:
FilePath Text 255
FileName Text 50
FileDescription Memo
PictureFrame Unbound Image Control
The Problem: I don't know how to create a combo box up to a certain level of directories on our network for the file path (ie. L:\Property\MainSt(12)\Photos) and to paste this information into the FilePath field.
I need the second combo then to lookup files in this FilePath that are only of the extension *.jpg, *.bmp, and *.gif and to place the selected file into the FileName field.
Once this is succesful the image box will display the corresponding property photo.
Thanks in advance for any help & expertise.
Fields:
FilePath Text 255
FileName Text 50
FileDescription Memo
PictureFrame Unbound Image Control
The Problem: I don't know how to create a combo box up to a certain level of directories on our network for the file path (ie. L:\Property\MainSt(12)\Photos) and to paste this information into the FilePath field.
I need the second combo then to lookup files in this FilePath that are only of the extension *.jpg, *.bmp, and *.gif and to place the selected file into the FileName field.
Once this is succesful the image box will display the corresponding property photo.
Thanks in advance for any help & expertise.