Image selector (PowerPoint Clipart like)

[Chicco]

Hi all database folks, how are you? Hope everything is OK with you!

I'm looking for advice (or to be pointed to the right thread/post in this forum, after having searched in it with little luck) about the following issue:

I need an "image chooser" to be inserted into a quotation form, from which the user can select one image only from the ones linked to the database.
I'm looking for something like the "insert clipart" function in PowerPoint and the likes, you know but I only have the "image control" to count on, in Access.

No use to say I thought about designing a form in which I can cycle through linked images and display an array of image controls but maybe some of you can address me towards a better, cleaner, faster solution.

Looking forward to hear your precious opinion, thanks in advance to anyone who will spend some time/effort to answer my question.

Greetings from Rome / Chicc

 

[isladogs]

I thought about designing a form in which I can cycle through linked images and display an array of image controls but maybe some of you can address me towards a better, cleaner, faster solution.

That's how I'd do it with the user selecting an image from the displayed array.
Or quicker still, just use a listbox to select from - you could do this so clicking on a listbox item shows a preview of the image & double clicking selects it.

The attached db may be of help
Click PopulateImageList then select a folder with images to use this

 

[Chicco]

I'm gonna trying your proposed approach Ridders, thank you for sharing idea and code snippet!