Images - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Images

Ryan Fazio

8 months ago

I have watched you videos on images. I am looking for a way to specify the image location based on controls from my form.

For example I the a CategoryT with a list a image categories

I then have a ImagesT where i am storing the image name and categoryID

the location where the images are located are as follows:

S:\CAD_Management\Details\

the sub folders under this match the category name.
S:\CAD_Management\Details\trees

how do i get the image source to show the correct image and change the location accordingly

	John Davy @Reply 8 months ago
Hi Ryan, I am not quite sure of your question, but Richard has several videos on images. Each one uses a Pickfile function to show the path and image in a text box and then in an image control. If this doesn't help then please rephrase the question. HTH John

	Matt Hall @Reply 8 months ago
You could concatenate image location, category name, an extra "\", and filename together to build a complete path. Use this as the source for your image control. Exactly how you would do that would depend on how your form is set up. You might check out Concatenation.

	Raymond Spornhauer @Reply 8 months ago
Ryan Rick also has an Imaging Seminar which is very detailed if that will help. -Raymond

	Ryan Fazio OP @Reply 8 months ago
Thank you all for your help. Matt I did end up figuring it our using concatenation.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View