473,320 Members | 1,707 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.

10 35111
ADezii
8,834 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,834 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,834 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,834 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,556 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 <Snip> and I will order everything.

*** Admin Edit ***
We don't allow sharing of email addresses publicly in the forums so anyone interested should please use the PM system to get in touch with Jordi instead.
Sep 28 '21 #10
NeoPa
32,556 Expert Mod 16PB
It's a little unusual to allow such interjections into a thread but I can see how this might be interesting to others who may be interested in the same problem so I'll allow it.
Oct 12 '21 #11

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

Similar topics

1
by: Bill W. | last post by:
Trying to make the transition from VBA in MS Access 2000 to VB6. I noticed that the icons for the command buttons in Access are apparently not available in the VB6 environment. Am I missing...
2
by: Deano | last post by:
Where is the file that holds the icons in Access 2000? I'm suffering from the old "object variable or with block variable not set" problem and so I need to browse to where the icons are. ...
0
by: John Sims | last post by:
I am currently working for a commercial software producer who is using C#. Some of the icon files on the GUI are part of the standard resource libraries provided by the Microsoft Visual Studio. ...
0
by: Dragos Dutu | last post by:
Hello people! I have a quite complicated question. While creating a ToolBar in code, it is possible to pass the standard icons located in COMMCTRL to the image list of the ToolBar. I'm talking...
1
by: Sonya | last post by:
Hello, I have trouble connecting to Access database from my web service. Database is located in a subdirectory of where service pages are. Code below produces the following exception: "No error...
1
by: Henrik | last post by:
I'm sorry to trouble you once again but somebody must know how to get a list of the desktop icons and their respective positions. I know that I have to look into shell but I have no idea how to...
17
by: John Salerno | last post by:
Ok, I've been browsing through the MySQLdb docs, and I *think* I know the kind of code I need to write (connect, cursor, manipulate data, commmit, etc. -- although I probably need to get more...
2
by: TyBreaker | last post by:
Is there a way to access icons within Windows XP for use in projects? -- ______ ___ __ /_ __/_ __/ _ )_______ ___ _/ /_____ ____ / / / // / _ / __/ -_) _ `/ '_/ -_) __/ /_/ ...
1
by: sheenaa | last post by:
I want to use AJAX features in my ASP.NET with C# website application 2005. For that i have already installed the following onto my pc. ASP.NET 2.0 AJAX Extensions 1.0 ASP.NET AJAX Futures...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.