Can I view the image and select it rather than use a combo list ?

[DBenz]

Hi,


I have a database which shows aircraft fuselage codes, numbers red outlined in white, yellow outlined in black etc, I have to choose the path to the small .png image from a combo dropdown list, so D drive address ending YOBK 4.png is yellow outlined black for a 4.

I wish to click and view the actual image set, select one, hit ok and have it entered into the field that way.

I also have crests emblems etc. in another field.

is that possible ?

Cheers

Steve

[CJ_London]

Not a clear enough explanation of the requirement to offer a possible solution

what is an ‘image set’? Do you mean you are using windows explorer to view a folder?

[DBenz]

Hi,
I have on D drive on my Pc a folder called ACCESS PICS. Within that I have a folder called FuselageMkgs400%AsPng and within that are raster images such as YOBK 4.png for a raster image of a 4 yellow with a black outline.
If I have a record of an aircraft and it has a 4 on its fuselage in the photo of that aircraft , and its yellow outlined in black, I have a control window (if thats the right term for a box that can display images) that can show that image if the path to that control has the address to that image selected from a combo drop down list of all the paths of those various .png images in that folder.
Its a pain to have to look for e.g. BKOR 6 when needing Black Outline red number 6 image as a .png
I use .png as they can have transparency for the numbers background, so it looks correct sitting on my forms bckground image which is a mottled camouflage scheme !
I want to , within the form view, click something and see the images, select the one I want and that loads the path into the field for that image control.

What I found I could do was to go to that folder, view the number, double click it, that launches a microsoft viewer, right click the number 4 I want and choose copy path to clipboard, then go back to access, click in the field that has all the D drive image addresses, and paste from the clipboard the address, go fwd then back one record to refresh, and behold my chosen number appears.
But wouldnt it be neat to just click something on the form, select the image and have it appear.

Hope that explains it.

DBenz

[CJ_London]

use filedialog to navigate to the folder - plenty of examples about.

You can provide an initial starting folder and within the filedialog change to view for list to icons etc as you can with windows explorer.

https://learn.microsoft.com/en-us/of...ion.FileDialog

it will return the full path and file name as a string which you can then assign to your image control