Image per id

[rexell]

I have the need to put a separate image per ID on my table/form or a separate link to an image I can put an image on my form but its does not change when I change my clients its the sam e all the time, I have tried linking to an excel book but for some reason it will only show 10 fields, (and it is linked)
I dont mind creating a standard windows folder with my images in but would need to be able to link to each one from my form.
I am not sure which would be the best route to take , any advive welcome
thanx

 

[Uncle Gizmo]

The usual method is to put your pictures in a folder.

Have a field in your table which stores the URL to each picture that relates to each person.

In the form load event you would have some code which will retrieve the URL and use it to populate the image control.

You would also need to call the same code from the on current event of the form so that the image changed as you traverse through the records.

 

[Uncle Gizmo]

If I recall correctly the Northwind sample database has an example of how to do this within it.

 

[Uncle Gizmo]

http://msdn.microsoft.com/en-us/library/8b6y4c7s.aspx

 

[rexell]

thanx for advice but seeing I am teaching my self I feel that the example is a little to advanced for me. I simply need at this stage which would be the way to achive what I need , maybe my original post is not definitive enough, what I really want to do is to have a way of displaying a image for each of my clients the image will be a QR code. I would like to include the code for each client on my form , the image will be a button that will be hyperlinked to the file where the image is located it does not need to be visable on my table.
any advice welcome

 

[Uncle Gizmo]

In your original post you indicated that you did not know the best route to take. In post number #2 I explained the way I understand it is normally done. I pointed you to some resources in later posts. Are you now saying that you don't want to follow my suggestion in post #2, you now you want the image to appear when you press a button on the form?

 

[rexell]

I would seem that I am not making myself clear. I am self learning access via youtubes and on line readings, But have to move at my own pace, Examples are all very well as long as there is someone to talk you through, in some of the northwind stuff it does not let you open in design mode to see how its set up. I stated I did not know what I should be using vb code a query etc. "now you want the image to appear when you press a button on the form?" As I have not learnt how to do this I can only try with my limited knowledge . I can put my QR code, on my form but I also have to include a link to the file source ,so there is litle point of putiing the QR image on the form. What would seem to make sence was for the image to be the link button , when pressed it would hyperlink me to the image source, this same system could be applied to ordanary barcodes or anything else as well, providing and external data source is always available . I am not talking about an infinity DB, but one for less than 400 clients. I must say that I detect frustration at my lack of understanding, if this is the way of the forum then its clearly not the right place form me or any other that are self learning. I do not want to get involved with anything other than finding out how to achive my goal.

 

[Uncle Gizmo]

If you put as much effort into describing what you want as you do into complaining, then I'm sure my frustrations would be much reduced.

If you are finding my method of approaching your problem conflicts with your view of how you should be treated then it's probably best I withdraw from further discussion with yourself.

 

[rexell]

thanks for the attempted support anyway.