473,321 Members | 1,877 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,321 software developers and data experts.

Where are A97 command button pictures stored?

MLH
If I choose a command button on a form in design view,
open the properties box and click the Picture property
and its wiz button, I'm presented with a lengthy list of
pictures. Everything from Add Table, Address Book,
Airplane to Underline, Undo, Undo (Rewind). I would
like to know where they are stored. I thought it might be
c:\program files\microsoft office\office\bitmaps but I
don't think so.

Anybody know where they are stored and if more bitmaps
can be added?
Feb 12 '06 #1
21 12944
MLH wrote:
If I choose a command button on a form in design view,
open the properties box and click the Picture property
and its wiz button, I'm presented with a lengthy list of
pictures. Everything from Add Table, Address Book,
Airplane to Underline, Undo, Undo (Rewind). I would
like to know where they are stored. I thought it might be
c:\program files\microsoft office\office\bitmaps but I
don't think so.

Anybody know where they are stored and if more bitmaps
can be added?


I think the icons used for Access 97 are stored in one of the dll's.

James A. Fortune
CD********@FortuneJames.com

Feb 13 '06 #2
> If I choose a command button on a form in design view,
open the properties box and click the Picture property
and its wiz button, I'm presented with a lengthy list of
pictures. Everything from Add Table, Address Book,
Airplane to Underline, Undo, Undo (Rewind). I would
like to know where they are stored. I thought it might be
c:\program files\microsoft office\office\bitmaps but I
don't think so.

Anybody know where they are stored and if more bitmaps
can be added?


What you see in the Picture Builder dialog is stored in a DLL and cannot be
modified. The icon selection is not the greatest, to be sure.

I found a program called Icon Maker (no endorsement, just a tool I've used)
that will retrieve all the icons from all the various DLLs and EXEs on your
system and let you customize and save them as a .ico (or just make your own
icons from scratch).

http://www.icon-maker.com/

To use a .ico stored on disk, you'll need to modify the control's property
sheet so the Picture property is the full path to where the icon is located,
and set the Picture Type property to "Linked". You can programmatically set
the Picture path if you need to.

At least this is true for AC03 - not sure about AC97.

Feb 13 '06 #3
MLH
You must be right. I cannot find separate files for any of them.
Feb 13 '06 #4


"deko" <de**@nospam.com> wrote in message
news:lJ********************@comcast.com...
If I choose a command button on a form in design view,
open the properties box and click the Picture property
and its wiz button, I'm presented with a lengthy list of
pictures. Everything from Add Table, Address Book,
Airplane to Underline, Undo, Undo (Rewind). I would
like to know where they are stored. I thought it might be
c:\program files\microsoft office\office\bitmaps but I
don't think so.

Anybody know where they are stored and if more bitmaps
can be added?
What you see in the Picture Builder dialog is stored in a DLL and cannot

be modified. The icon selection is not the greatest, to be sure.

I found a program called Icon Maker (no endorsement, just a tool I've used) that will retrieve all the icons from all the various DLLs and EXEs on your system and let you customize and save them as a .ico (or just make your own icons from scratch).

http://www.icon-maker.com/

To use a .ico stored on disk, you'll need to modify the control's property
sheet so the Picture property is the full path to where the icon is located, and set the Picture Type property to "Linked". You can programmatically set the Picture path if you need to.

At least this is true for AC03 - not sure about AC97.

True enough, but if you are distributing the app, you wouldn't want to have
to include icon files. I prefer to embed the icon on the command buttons
where needed.

There are a number freeware programs that will extract icons, in addition to
the one mentioned above. I use one called Icon Ripper. Also another
freeware called IconEdit, which makes it easy to edit them.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Feb 13 '06 #5
> True enough, but if you are distributing the app, you wouldn't want to
have
to include icon files. I prefer to embed the icon on the command buttons
where needed.


I tried embedding them but couldn't get it to work. When the app was opened
on the client machine, the button had no icon. So I just put the icons in
the same location as the database, which is easy enough to find with code.
If the user moves the database around without moving the icons, well, that's
a billable call...

Feb 13 '06 #6
Randy Harris wrote:
to include icon files. I prefer to embed the icon on the command buttons
where needed.


Ahh... I was thinking of new toolbar images. Don't forget that you're
not limited only to icon images for command buttons:

http://groups.google.com/group/comp....9be8a6b757a694

I have one command button with a mushroom-shaped cloud:
Picture: C:\Nuke.bmp
Picture Type: Embedded
ControlTip Text: Nuke

Even though MS has been expanding the pixel dimensions of icon files
they're still more limited than BMP's.

James A. Fortune
CD********@FortuneJames.com

Feb 14 '06 #7
> Randy Harris wrote:
to include icon files. I prefer to embed the icon on the command buttons
where needed.


Ahh... I was thinking of new toolbar images. Don't forget that you're
not limited only to icon images for command buttons:

I have one command button with a mushroom-shaped cloud:
Picture: C:\Nuke.bmp
Picture Type: Embedded
ControlTip Text: Nuke

Even though MS has been expanding the pixel dimensions of icon files
they're still more limited than BMP's.


True, but if you embed a bunch of BMPs you're increasing the size of the
database. With 1k icons, there's no performance difference between Linked
and Embedded, which is likely with a large linked BMP. And linked icons can
be changed without recompiling - and you can test for their existence. So I
could give my MDE app a new look just be distributing a new set of icons.

If fact, this has got me thinking - could I change the background color of a
form by pointing its Picture property to a solid colored icon? With an MDB,
I can programmatically open a form in design mode and change the background
color, but this is not possible with an MDE. And usually the first question
I'm asked is "how do I change the color"?

Feb 14 '06 #8
deko wrote:
Randy Harris wrote:
to include icon files. I prefer to embed the icon on the command
buttons where needed.


Ahh... I was thinking of new toolbar images. Don't forget that
you're not limited only to icon images for command buttons:

I have one command button with a mushroom-shaped cloud:
Picture: C:\Nuke.bmp
Picture Type: Embedded
ControlTip Text: Nuke

Even though MS has been expanding the pixel dimensions of icon files
they're still more limited than BMP's.


True, but if you embed a bunch of BMPs you're increasing the size of
the database. With 1k icons, there's no performance difference
between Linked and Embedded, which is likely with a large linked BMP.
And linked icons can be changed without recompiling - and you can
test for their existence. So I could give my MDE app a new look just
be distributing a new set of icons.
If fact, this has got me thinking - could I change the background
color of a form by pointing its Picture property to a solid colored
icon? With an MDB, I can programmatically open a form in design mode
and change the background color, but this is not possible with an
MDE. And usually the first question I'm asked is "how do I change
the color"?


You can change the background color of a from in an MDE. The change just won't
persist, but then a change to the background image property wouldn't persist
either. I suppose you could make it persist by changing the name of the bmp
file amongst several of different colors.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 14 '06 #9
deko wrote:
Randy Harris wrote:
to include icon files. I prefer to embed the icon on the command buttons
where needed.
Ahh... I was thinking of new toolbar images. Don't forget that you're
not limited only to icon images for command buttons:

I have one command button with a mushroom-shaped cloud:
Picture: C:\Nuke.bmp
Picture Type: Embedded
ControlTip Text: Nuke

Even though MS has been expanding the pixel dimensions of icon files
they're still more limited than BMP's.


True, but if you embed a bunch of BMPs you're increasing the size of the
database. With 1k icons, there's no performance difference between Linked
and Embedded, which is likely with a large linked BMP. And linked icons can
be changed without recompiling - and you can test for their existence. So I
could give my MDE app a new look just be distributing a new set of icons.


Yes, I thought about the size factor. Good point. Usually command
buttons aren't very large so that's not a big problem when they're
placed in a 40 Mb mdb. Hmm... your idea about the new look using a new
set of icons for an MDE is interesting and new to me. I'll have to
consider it.

If fact, this has got me thinking - could I change the background color of a
form by pointing its Picture property to a solid colored icon? With an MDB,
I can programmatically open a form in design mode and change the background
color, but this is not possible with an MDE. And usually the first question
I'm asked is "how do I change the color"?


I haven't tried that either. It looks like I need to do some
experimenting. Thanks for the ideas.

James A. Fortune
CD********@FortuneJames.com

Feb 14 '06 #10
> You can change the background color of a from in an MDE. The change just
won't persist, but then a change to the background image property wouldn't
persist either. I suppose you could make it persist by changing the name
of the bmp file amongst several of different colors.


hmmm...

I could persist it this way:

Private Sub Form_Open
Me.Detail.BackColor = _
Nz(DLookup("FormDetailColor", "tblPrefrences"), -2147483633)
End Sub

and just save the user's selection - made from a variety of text boxes with
backcolors that show the different options available - to tblPreferences.

Combine this with different sets of (linked) command button icons - stored
in folders like "ThemeOne" and "ThemeTwo" in the database directory - and
I've got a decent level of user customization... in an MDE!

Feb 14 '06 #11
I've got apps with dozens of custom command buttons and toolbar buttons.
Works like a charm. I've got some, that open forms, that are actually tiny
pictures of the form. I did screen grabs of the forms, shrunk them way down
with software then embedded them as images on command and toolbar buttons.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
"deko" <de**@nospam.com> wrote in message
news:19********************@comcast.com...
True enough, but if you are distributing the app, you wouldn't want to
have
to include icon files. I prefer to embed the icon on the command buttons where needed.
I tried embedding them but couldn't get it to work. When the app was

opened on the client machine, the button had no icon. So I just put the icons in
the same location as the database, which is easy enough to find with code.
If the user moves the database around without moving the icons, well, that's a billable call...


Feb 14 '06 #12
Ya, don't let Access scale your images down. It has to store the full size
and they can be huge. Shrink them down externally, only embed as big as you
need.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
"deko" <de**@nospam.com> wrote in message
news:pe******************************@comcast.com. ..
Randy Harris wrote:
to include icon files. I prefer to embed the icon on the command buttons where needed.
Ahh... I was thinking of new toolbar images. Don't forget that you're
not limited only to icon images for command buttons:

I have one command button with a mushroom-shaped cloud:
Picture: C:\Nuke.bmp
Picture Type: Embedded
ControlTip Text: Nuke

Even though MS has been expanding the pixel dimensions of icon files
they're still more limited than BMP's.


True, but if you embed a bunch of BMPs you're increasing the size of the
database. With 1k icons, there's no performance difference between Linked
and Embedded, which is likely with a large linked BMP. And linked icons

can be changed without recompiling - and you can test for their existence. So I could give my MDE app a new look just be distributing a new set of icons.

If fact, this has got me thinking - could I change the background color of a form by pointing its Picture property to a solid colored icon? With an MDB, I can programmatically open a form in design mode and change the background color, but this is not possible with an MDE. And usually the first question I'm asked is "how do I change the color"?


Feb 14 '06 #13
deko wrote:
You can change the background color of a from in an MDE. The change
just won't persist, but then a change to the background image
property wouldn't persist either. I suppose you could make it
persist by changing the name of the bmp file amongst several of
different colors.


hmmm...

I could persist it this way:

Private Sub Form_Open
Me.Detail.BackColor = _
Nz(DLookup("FormDetailColor", "tblPrefrences"), -2147483633)
End Sub

and just save the user's selection - made from a variety of text
boxes with backcolors that show the different options available - to
tblPreferences.
Combine this with different sets of (linked) command button icons -
stored in folders like "ThemeOne" and "ThemeTwo" in the database
directory - and I've got a decent level of user customization... in
an MDE!


Sure I save lots of user preferences this way. For instance my main menu as
multiple tabs and some tab pages have sub-tabs. I allow the user to
desginate a "home page" that the menu defaults to at startup. I also store
the width and height of many forms that are resizable by the user to show
more content on higher resolution displays.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 14 '06 #15
MLH
Were you using A97?
I've got apps with dozens of custom command buttons and toolbar buttons.
Works like a charm. I've got some, that open forms, that are actually tiny
pictures of the form. I did screen grabs of the forms, shrunk them way down
with software then embedded them as images on command and toolbar buttons.


Feb 15 '06 #16
MLH
I change Picture property (form background) in mde's. It does not
perform perfectly reliably, but mostly works. Say I open two forms
A & B and suppose B has picture property. If I modify B's picture
property in code, I don't see anything right away. But if I grab A
by its title bar and drag it across B, the drag path 'erases' the old
picture layer, exposing the new picture underneath. Don't ask why.
I have no idea.

I started forcing other objects over the picture to force this to
occur. For instance, I can enlarge a textbox to cover the entire
form surface, then shrink it back to zero size. That'll do the trick.
Feb 15 '06 #17
MLH
Slightly redirected topic...
Say, about those tabs. I just finished posting a Q asking how to move
from page to page in Tab control. How do you handle that on your main
menu?

Sure I save lots of user preferences this way. For instance my main menu as
multiple tabs and some tab pages have sub-tabs. I allow the user to
desginate a "home page" that the menu defaults to at startup. I also store
the width and height of many forms that are resizable by the user to show
more content on higher resolution displays.


Feb 15 '06 #18
MLH wrote:
Slightly redirected topic...
Say, about those tabs. I just finished posting a Q asking how to move
from page to page in Tab control. How do you handle that on your main
menu?


The TabControl has a Value property that corresponds to the the page index of
the currently selected TabPage. Setting that value brings the TabPage with that
index to the front. For example to switch to the 3rd TabPage...

Me.TabControlName = 2

(index starts at zero)

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 15 '06 #19
Oops, sorry. I'm using A2K. I no longer have A97 installed, so I don't
know if that capability is new in A2K.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
"MLH" <CR**@NorthState.net> wrote in message
news:8c********************************@4ax.com...
Were you using A97?
I've got apps with dozens of custom command buttons and toolbar buttons.
Works like a charm. I've got some, that open forms, that are actually tinypictures of the form. I did screen grabs of the forms, shrunk them way downwith software then embedded them as images on command and toolbar
buttons.


Feb 16 '06 #20
Bri

MLH wrote:
I change Picture property (form background) in mde's. It does not
perform perfectly reliably, but mostly works. Say I open two forms
A & B and suppose B has picture property. If I modify B's picture
property in code, I don't see anything right away. But if I grab A
by its title bar and drag it across B, the drag path 'erases' the old
picture layer, exposing the new picture underneath. Don't ask why.
I have no idea.

I started forcing other objects over the picture to force this to
occur. For instance, I can enlarge a textbox to cover the entire
form surface, then shrink it back to zero size. That'll do the trick.


What about a Repaint after changing the picture property?

--
Bri

Feb 16 '06 #21
MLH
I tried Repaint. It didn't do the trick. At least
there's a work-a-round. Sizing a textbox large
enough to cover the entire form area, then
sizing it again to reduce it to zero does the
trick quite reliably AFAIK.
Feb 20 '06 #22

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: bearophileHUGS | last post by:
Hello, I have four things to ask or to suggest, sorry if they seem basic or already discussed. ------------------- I am still ignorant about Tkinter. This little program, after pressing the...
12
by: Wadim Grasza | last post by:
I want to store and display (on a form or a report) multiple pictures per record in an access database. The pictures are not stored within the database. They are stored as files and the database...
4
by: Johnny Emde | last post by:
Hello I'am building an web application that enable users to get data stored in a SQL Server. My problem is pictures. How can I display pictures stored in SQL Server - In the old days, I took...
5
by: howser99 | last post by:
Hi All Ive got an issue with inserting images into a command button from a table that I have embedded a OLE object into. The following is the code Im am trying to use; If bolMenuVisible Then ...
7
by: google | last post by:
I would like to execute a single JavaScript command from within a web service. The command is a mathmatical statement. I have a web page with some client side logic that does this and I'm now...
1
by: DaveF | last post by:
Any Ideas as to this error message. I am trying to learn using ms sql server 7.0 Below is the code I am using for an update to a MS Sql Database. <%@ Language=VBScript %> <% Option Explicit...
14
by: keri | last post by:
Hi, Simple version of the question..... How do I use the where clause of the open form command to show an account with a matching ID to be displayed when the form is opened? Eg. I select a...
5
by: Alexnb | last post by:
Hello I am sure most of you are familiar with py2exe. I am having a bit of a problem. See the program has a few pictures involved and the .ico it uses for the windows. However, the pictures are...
14
by: alnino | last post by:
Hi, I have a command button on a form that the user can use to browse to a file and the user can select that file and a hyperlink to that file is stored in a txtfield for that record. I then...
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.