469,167 Members | 1,979 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Where are Access icons located?

I am building a form to simulate the Access 2000-2003 database window, to use in Access 2007 so my users don't freak out with the new interface.

I have a program called Resource Extractor form Alchemy Mindworks that allows extracting bitmaps and icons from EXE and DLL files, but I can't seem to find which file has the Access icons embedded.

Thanks in advance,
Bill Mitchell
Nov 11 '07 #1

✓ answered by ADezii

I am building a form to simulate the Access 2000-2003 database window, to use in Access 2007 so my users don't freak out with the new interface.

I have a program called Resource Extractor form Alchemy Mindworks that allows extracting bitmaps and icons from EXE and DLL files, but I can't seem to find which file has the Access icons embedded.

Thanks in advance,
Bill Mitchell
Hello Bill, back again with an update. I was partially correct in my 'Common Icon Pool' Theory and here is the entire scoop. First of all, they are not Icons but Bitmap Images (*.bmps), and Office XP stores this hugh collection of Bitmaps as an Office-wide resource as a single 'slab' in one of its .DLLs. Storing them this way saves on Graphics Resources and in addition, Access provides its own set of extra Button Bitmaps mostly for historical purposes. Msaccess.exe provides a Method for retrieving a single Bitmap from the slab which involves an Index into this group of Bitmaps and the subsequent filling of a Byte() Array with the requested Bitmap. I've condensed a large amount of Code and Objects to a single Form, Query, and Module. This will give you the capability to either Save a specific Bitmap from the 'slab' to disk as a *.BMP, or to assign it to the Picture Property of an Object. This functionality will give you access to the 226 Bitmaps used by Access and the 5,700 used by Office. In your case, I assume that you may want to Save them to disk, then load them into selective Controls. In any case, I hope this helps. If you are interested, send me a Private Message with your E-Mail address and I'll send you the Database as an Attachment. The code does use ADO, so you will need to set this Reference.

9 24137
ADezii
8,800 Expert 8TB
I am building a form to simulate the Access 2000-2003 database window, to use in Access 2007 so my users don't freak out with the new interface.

I have a program called Resource Extractor form Alchemy Mindworks that allows extracting bitmaps and icons from EXE and DLL files, but I can't seem to find which file has the Access icons embedded.

Thanks in advance,
Bill Mitchell
I'm not positive, but try the Shared Office .DLL, namely MSO.DLL.
Nov 11 '07 #2
Are you talking about
C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL
that's not the one. It does have a few icons but not the main "stash" that I'm looking for.

Specifically, I'd like to find the icons used for the database window.

Thanks,
Bill
Nov 11 '07 #3
ADezii
8,800 Expert 8TB
Are you talking about
C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL
that's not the one. It does have a few icons but not the main "stash" that I'm looking for.

Specifically, I'd like to find the icons used for the database window.

Thanks,
Bill
Sorry about that, I thought that all the Office Components had a shared 'Icon Pool' and that MSO.DLL was it. Guess not!
Nov 11 '07 #4
FishVal
2,653 Expert 2GB
Why not to grab them directly from screen?
Nov 11 '07 #5
ADezii
8,800 Expert 8TB
I am building a form to simulate the Access 2000-2003 database window, to use in Access 2007 so my users don't freak out with the new interface.

I have a program called Resource Extractor form Alchemy Mindworks that allows extracting bitmaps and icons from EXE and DLL files, but I can't seem to find which file has the Access icons embedded.

Thanks in advance,
Bill Mitchell
Hello Bill, back again with an update. I was partially correct in my 'Common Icon Pool' Theory and here is the entire scoop. First of all, they are not Icons but Bitmap Images (*.bmps), and Office XP stores this hugh collection of Bitmaps as an Office-wide resource as a single 'slab' in one of its .DLLs. Storing them this way saves on Graphics Resources and in addition, Access provides its own set of extra Button Bitmaps mostly for historical purposes. Msaccess.exe provides a Method for retrieving a single Bitmap from the slab which involves an Index into this group of Bitmaps and the subsequent filling of a Byte() Array with the requested Bitmap. I've condensed a large amount of Code and Objects to a single Form, Query, and Module. This will give you the capability to either Save a specific Bitmap from the 'slab' to disk as a *.BMP, or to assign it to the Picture Property of an Object. This functionality will give you access to the 226 Bitmaps used by Access and the 5,700 used by Office. In your case, I assume that you may want to Save them to disk, then load them into selective Controls. In any case, I hope this helps. If you are interested, send me a Private Message with your E-Mail address and I'll send you the Database as an Attachment. The code does use ADO, so you will need to set this Reference.
Nov 12 '07 #6
Thanks, I'm sending you a PM wih my email.

That makes a lot of sense. I can remember finding a "327" bitmap back in the Access 2.0 days that was a slab like you describe, but never found that one in the modern Access file. I'm anxious to see how to extract those individual bitmaps.
Nov 12 '07 #7
ADezii
8,800 Expert 8TB
Thanks, I'm sending you a PM wih my email.

That makes a lot of sense. I can remember finding a "327" bitmap back in the Access 2.0 days that was a slab like you describe, but never found that one in the modern Access file. I'm anxious to see how to extract those individual bitmaps.
Hopefully, you will already have received the Database which I sent to you last night. There are, however, 3 important items that I wish to make you aware of:
  1. If you Import frmButtonPix into a New Database, you will run into a problem. This Form uses an ActiveX Control, the MSForms 2.0 Scrollbar. I think the Reference to it in code is hsb. When you Import this Form into a New Database, the Form will Import correctly, but the Reference to the MSForms Library is lost. There is, however, a simple fix to this problem, place another MSForms Control, anyone will do, on the Form once you have successfully Imported it. The correct Reference will be magically re-established. This seems to be an on-going problem with Importing Forms containing ActiveX Controls.
  2. If you are changing the Picture on a Button permanently, you will need to Open the Form containing that Button in Design View, then save the changed Form. Programmatic changes made to Forms at run-time are not saved with the Form. I'm sure that you are probably aware of all this, but mentioning it just in case.
  3. Again, don't forget a Reference to the Microsoft ActiveX Data Objects X.X Library is required.
Nov 12 '07 #8
NeoPa
32,167 Expert Mod 16PB
A new question related to this one has been posted as :
Work on Access Icon.
Jul 9 '12 #9
jordimarsa
2 2Bits
I have developed a method to extract about 6000 bitmap images and save them into a table as text encrypted as base64. In this way I have a form with 1024 butons and I can load the images in a matter of seconds and scroll to see all the images. Then you can select one of them and it will open the form in designing mode with and the first control will show the image selected. In this way you can copy that control in any Access application and use the image desired.

It has been really useful to use the same office icons to ease the recognition of each action.

The problem is that it has been developed by myself using information of many webs and a little bit of own knowledge and everything is messed up. So if you want me to share it send me a mail to jordi.marsa@e2m.es and I will order everything.
7 Hours Ago #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Bill W. | last post: by
reply views Thread by John Sims | last post: by
1 post views Thread by Sonya | last post: by
2 posts views Thread by TyBreaker | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.