Extracting the images in Access Image Gallery

[arnelgp]

sorry, yes you are correct, the os does not recognize the image.

 

[seemick]

It's odd because I came across a database online (I can't remember exactly where I got it) that has a couple of records in there for built in images that work fine. I am trying to add a couple more images or at least figure out how to. The 2 I have are the down arrow and the filter.

I can't for the life of me find where I got it.

 

[arnelgp]

from what i "googled", it is likely an .ico file.
extract it and rename it as filename.ico

after renaming, go to https://www.freeconvert.com/ to convert it to .jpg.
(actually it did successfully convert it).

 

[seemick]

How do I extract built in .ico? I don't want to extract the existing 2. I want to add new ones.

 

[arnelgp]

I want to add new ones.

by all means do add new ones.

 

[seemick]

I think I am completely misunderstanding you. I haven't been able to solve my query and I don't understand your last 2 post.

 

[seemick]

How do I add built in images into the MSysResources table?

 

[arnelgp]

you already did it, put the image first as embedded then later as shared.

now the resulting is an .ico, which you cannot open.
suggest you extract it (using the code i gave) and rename it as filename.ico.
then use online converter to convert it to .jpg (or any format).
you can now view your image.
if you want you can use this converted image back to your access app as your image.

 

[seemick]

Ok, that makes sense...Let me try it

 

[arnelgp]

convert it to png so it will not loose any transparency (the one i converted to .jpg has black background).

 

[seemick]

Wow...It works. Thanks for your help. We got there in the end. I can be a bit slow at times.

 

[isladogs]

The main purpose of the Image Gallery is to store small images that can be used in multiple places in your database. As already stated, use the Shared setting. Do not embed the image or it defeats the purpose of using the image gallery

 

[seemick]

Thanks for the tip. As previously mentioned I am only using this to store a few icons to be able to change the picture properly of a button at run time. (2kb each) Are you aware of a better option rather than having multiple buttons and hiding the unused ones?

 

[tvanstiphout]

You can change the picture by changing the Picture property of the button:
Me.myButton.Picture = "otherPictureInImageGallery"

 

[seemick]

Have you tried this with the default available pictures?