changing the xsi:type
I have an arraylist with up to 4 different classes that can be
It's largely working. The output is:-
<anytype xsi:type="xmlcar" />
<anytype xsi:type="xmltruck" />
<anytype xsi:type="xmlmotorcycle" />
<anytype xsi:type="xmlrv" />
I've tried changing the element name, the arrayitem name, but I can't
get it to rename from "xmlcar" to ...change menu prompt dynamically
I wanna change the menu prompt dynamically.
how can I do that?
What do mean by "menu prompt"? I'm pretty sure that a dozen of guys is ready
to help ya, but you gotta be more specific ;-)
"monica" <firstname.lastname@example.org> wrote in message
> I wanna change the menu prompt dynamically.
> how can I do that?
If you are doing it dynamically, you need to look at CFrameWnd::OnMenuSelect
(ie handle WM_MENUSELECT) and WM_SETMESSA...How do I change the color for cell selection in excel?
I just started using Excel 2007. In the older versions when I select a row,
column, or specific group of cells, Excel would highlight the group in a
certain color. In Excel 2007, it simply surrounds the selected group of
cells with a thick black line. I've tried going into Excel Options under
Advanced but couldn't find how to do this. Can you assist me in changing
On Dec 31 2007, 6:52 pm, dminliberty
> I just started using Excel 2007. In the older versions when I select a row,
> column, or specific grou...change cell shading when a number differs from the previous number
I am generally familiar with Excel, but need some help on this particular
Is there a way to apply a format where: whenever the number in a column
differs from the one previous to it, a cell shading color change is applied.
For example, you have a column of numbers in Excel:
5 (cell shading color change applied)
2 (cell shading color change applied)
3 (cell shading color change applied)
It doesn't matter what color is used, just so that it is applied whenever
there is a change from the previous number.
There has got to be an easy answer to this.... ...Script error when tyring to create new crm contact with outlook
I have just installed CRM and web interface works ok, now I started
installing outlook client and it wen't ok, only needed to install xml core
Everything looked great until I started testing from Outlook client, I made
new crm appointment and then I tried to add new contact, I click from button
labeled regarding, then from window that opened I have tried to choose
account and also contact, error is same, anyway after choosing contact or
account I click New... soon new window opens labeled quick create
account/contact, then Internet Explorer script error box opens readin...change field number automatically when printing
We have a form in Excel, it is only one page, but we need a number on the right top corner of the sheet that changes automatically evey time we print the form
Is there any way to do this
You could use a Workbook BeforePrint macro that do that, assume the number
is in cell G1
Range("G1").Value = Range("G1").Value + 1
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("G1").Value = Range("G1").Value + 1
"sponder" <email@example.com> wrote in message
news...Creating forms in Access or Excel that link to Visio Documents
Does anybody have any experience with creating forms in access or excel that
are integrated with Visio? How would I go about doing this?
Access by definition can store 'objects', which can include visio drawings.
If prompted, don't select display icon
a.) create table
add oledb field
add text field for name
b.) open table
select oledb field and right click => insert new microsoft visio
edit the new drawing and close it
c.) create a form based on new table
drag the oledb field onto the form
d.) open the form
what are you attempting to do?
&quo...How can I stop format change when copying data into unlocked cells
How can I stop the format changing when I copy data into an unlocked cell in
a format protected worksheet?
I need to allow people to both enter data or copy data from another source
into cells so I have unlocked these cells but also don't want the format of
the cells to be changed. If you enter data directly the format does not
change but if you copy and paste data it changes the format.
I know you can use "copy paste special values" but would like to know if
there is some system way of doing this.
Copy/paste this into the sheet module.
Right-click on sheet ...Protect but allow changes
I would like to protect a worksheet but allow others to
change column width and format numbers. Is that possible
and how do I do this? Thank you for your help.
It depends on what version of excel you have, when you protect the sheet
check allow format cells and format columns if you have this option
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
<firstname.lastname@example.org> wrote in message
news:a2...How do I create an inventory list?
I need to create an inventory list for sale on a front page website. Do I
use Acces database to do this and how?
You could, but if you are actually going to sell your products online, for
security reasons you should look for a well established ecommerce package
compatible with FrontPage.
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Please reply to the newsgroup for the benefit of others
> I need to create an inventory list for sale on a front page website. Do...How can I change the default paper size of a blank publication?
Publisher 97/98 asked for a choice to be made re paper size and measurements
at setup. This allowed for European A4 to be the paper for the basic blank
publication as opposed to US Letter. Is it possible to make this selection
with PUblisher 2003. If so how?
Do you have these settings available through your printer? If so set it up first,
Publisher will follow along. You can change the page measurements to centimeters in
Options, found under tools.
Mary Sauer MS MVP
"Paramount" <Paramoun...Accidental Saved over Excel File
I was clicking on a help topic and realized as it was
loading the help screen, that I needed to click on the
other topic. I clicked several times and then somehow it
clicked something in the background in the worksheet, my
worksheet is now blank, and all the data is gone. Is
there ANYWAY at all to get the workbook again in the
condition it was before the accidental last save???
Sorry to Say, but AFAIK there is no way to recover your files except of
course if you have made a back up copy.
"Tom" <email@example.com> wrote in message
news:00b001c38fb8$69c6da60$a00128...Save as DBF 4
Can anyone help me, I am required to save my spreadsheet as a "DBF 4"
I don't see this option in my "save as" drop down menu.
using Excel 2007?
> Can anyone help me, I am required to save my spreadsheet as a "DBF 4"
> I don't see this option in my "save as" drop down menu.
> Please reply
> Thank you
I believe most database apps can import comma delimi...I'm trying to change a clustered column to a stacked column
I click on clustered and the columns don't change to reflect the gradient
What do you mean by "to reflect the gradient"?
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"petty" <firstname.lastname@example.org> wrote in message
>I click on clustered and the columns don't change to reflect the gradient
...Can I create an invoice that will number itsself?
I am creating an invoice for someone, they would like it to autmatically
progress numerically as they are used, is this possible?
Try this sample file and use it or use the code within.
"llpc2004" <email@example.com> wrote in message
> I am creating an invoice for someone, they would like it to autmatically
> progress numerically as they are used, is this possible?
J.E. McGimpsey has ...File Save in network
My application has Open,Save,SaveAs menu for its configuration file.
Generally configuration files are created in network server so that they can
be shared and I have trouble in saving an existing file to network server. I
mean, it can create and save as a new file but if I open an existing file
and try to save, then I got warning msg like "Access to
\\server\folder1\folder2\conf.bin was denied"(I have permission to write to
the folder). Do you think this is an application problem? Just for test, I
tried saving in local folder and it works.
...Can anyone give me the form template for the ingenic 6550?
Can anyone give me the form template for the ingenic 6550? Please!!!!!!!
...Outlook 2003 created multiple Identical personal folders
I just installed Outlook 2003 on a new laptop. When I
imported my old .pst file, two "new" personal folders
were created. Both of the folders contain exactly the
same information (inbox, contacts, etc) as the primary.
Deleting from any one deletss from all three. I have
tried the "removing duplicate personal folders" procedure
at Microsoft.com. I can rename to top folder but not the
next two. Outlook won't let me delete either of the second
two because it says that nay of them is primary.
Any help would be appreciated.
I hope...How do i create a pie chart that shows % of time on tasks?
I need to create a pie chart that shows what percent of time my employees are
working on each of 5-6 efforts. Does anyone have a good template for that?
...save as web page #4
Is it possible to save a range of cells to a web page
without having excel put the long and detailed html
I am only interested in saving the text to be reused in
client excel programs --- formatting is not needed for my
...How do I change the color of the Picture fill Speckles ?
I am making memorial folders and I like the picture fill (Speckles)
background option. Can I change the color of the speckles and how? I have
tried but I cannot figure this out. Thanks for any help, Laurie
On Thu, 3 Nov 2005 17:30:10 +0000, lmp wrote
(in article <185807CB-47F2-4C3E-B51D-E972501D49C5@microsoft.com>):
> I am making memorial folders and I like the picture fill (Speckles)
> background option. Can I change the color of the speckles and how? I have
> tried but I cannot figure this out. Thanks for any help, Laurie
You have answered your own question. It is a gif...icon change in the task bar
I run Windows 7 and I have the Outlook program pinned to the task bar at the
bottom of the screen. Up to a few days ago the icon for Outlook in the task
bar was a yellow envelope. It has now mysteriously changed to what appears to
be a generic program icon. How can I make it revert to its original icon.
You probably had a corruption in your icon cache from Windows.
Unpin it and then pin it again from the Outlook shortcut that you can find
in the Start Menu.
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-outlook.com...creating a database in 2000
would it be possible for me to create a database in 2000
and then install it onto a computer that only holds Access
97. if posisble how would i go about this,
If your intent is to have Access 97 open/run the Access 2000 database, no
this cannot be done. To open/run an Access 2000 database requires having
Access 2000 or 2002 (or a runtime installation of either) installed on the
"CLAY" <BUSIHARV@livjm.ac.uk> wrote in message
> would it be possible f...change source data in multiple charts
I have over 30 charts where I need to change the source data and it's taking
ages doing it manually, especially as each chart has 3 or 4 series. Is there
an easy way of doing this, please?
I've tried find and replace, but that doesn;t work
We need a little more detail. 1. Are you modifying all the charts to use
the same new range or does each chart use a different new range? Is the
data compact, that is, if you choose the chart wizard and look at the Data
Range tab does the Data Range box contain a simple reference like
"Tuxla&...Pivot Table Error-"Microsoft cannont make changes because there are too many..."
I've encountered the following error when using the pivot
table. Microsoft Excel cannot make this change because
there are too many row or column items. Drag at least
one row or column field off the Pivot Table, or to the
page position. Alternatively, right click a field, and
then click Hide or Hide Levels on the shortcut menu.
In the layout tab of the pivot wizard I tried to select 9
rows, 2 columns, and 3 data. The first excel document
that I pivoted had approximately 8800 lines (records) and
the pivot table worked. I then tried to do the same
layout criteria for another e...