By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,110 Members | 990 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,110 IT Pros & Developers. It's quick & easy.

Where are Access icons located?

P: 42
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.

Share this Question
Share on Google+
8 Replies


ADezii
Expert 5K+
P: 8,675
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

P: 42
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
Expert 5K+
P: 8,675
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
Expert 2.5K+
P: 2,653
Why not to grab them directly from screen?
Nov 11 '07 #5

ADezii
Expert 5K+
P: 8,675
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

P: 42
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
Expert 5K+
P: 8,675
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
Expert Mod 15k+
P: 31,662
A new question related to this one has been posted as :
Work on Access Icon.
Jul 9 '12 #9

Post your reply

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