change color in graphs?
I have a graph with a combo box form control, so that the data it
plots changes according to the data set I choose in the combo box. Is
it possible to also change the color of the plot lines according to
what the combo box choice is?
You would need to use VBA to handle that.
If this helps, please click the Yes button
> I have a graph with a combo box form control, so that the data it
> plots changes according to the data set I choose in the combo box. Is
> it possible to also change the color of the plot li...when assemblies in gac change;programs should update themselves
i have an developer server. I write c# code on it and publish programs from
the same server with "only online" option.
I am using same custom library(in gac) for all projects. I want that when i
changed library(assembly in gac);all programs that i publish must update
themselves without buid them again. Is it possible;if not could you offer me
a solution close to i am trying to do.
thanks for answers in advance
> i have an developer server. I write c# code on it and publish programs from
> the same server with "only online" option.
How can I change the default cursor (cross) to a different one (say arrow or
any other custom)?
It's not really an Excel question. You can do this with CSS. Otherwise,
maybe the mouse pointer settings in the conrol panel.
"Benny Halperin" <email@example.com> wrote in message
> How can I change the default cursor (cross) to a different one (say arrow
> any other custom)?
How can I do it with CSS?
"Chris Roberts" <firstname.lastname@example.org> wrote in m...Filter-by-form and Linked Tables
Using Filter By Form on a particular form, some fields only show "Is NULL"
and "Is Not NULL" in the pulldown. I've already set the Filter Lookup option
to retrieve up to 900,000 records for lists.
Turns out I recently split the database. So I then tested this form using a
local (non-linked) copy of the relevant table, and sure enough, when in
Filter By Form, pulldown lists for the fields in question now show actual
data values instead of "Is NULL" and "Is Not NULL".
Is there something else I need to do to get this to work properly using
l...Automatic change a graphic.
I have a problem that seemed to be easy to solve, but it isn't. So i post my
I run every day some kilometers. Some day 5, some day 6 or more. I want to
keep al this date in an excelsheet and have a beautiful graphic of this. The
problem is that everytime I insert a new run, I have to select my graphic
and change the cells where the graphic has to take his data. When I select
the whole row, I have a lot of blank space in my graphic. Is it possible to
make an graphic that shows data inserted in a row, and only shows the cells
that are filled.
Here...Outlook Laptop Synchronization Issues changing Data
I was wondering if anyone has experience the same issue in regards to
Outlook laptop Synchronizing with CRM 3.0
Recently I was preparing a brand new laptop for a user. I setup CRM for
Laptop client and enabled it online. In the meantime the user was still
using the old laptop with the CRM client installed as well. User was still
using CRM while I prepared the new system for use of CRM in Outlook.
The following day we noticed a lot of the Opportunities in CRM were
reassigned for no apparent reason. It did show that the modification was
completed by the user I was preparing the ...Purchase order numbers not defaulting correctly
My users are complaining that purchase order numbers are not defaulting
correctly and they have to manually overwrite it.
For example: Our purchase orders should be in the 10000 series but they keep
going back to 7000 series.
What are the different conditions under which default purchase order numbers
resets itself? What is the way around this? This is Great Plains 9.
if you moved the old purchase orders to history then at the time of purchase
order creation it will bring the old ponumbers this may be the one of the
reasons it is going back to old numbers.
...changed the border style, now I crash
I messed around with the look of my dialog using the editor (border styles,
when I tried to debug, I get an exception on this line:
I have NO idea what any of that is even doing. I jsut starting using MFC a
couple days ago..
If anyone has any ideas what this is all about or where I should look for a
problem, please share. I would appreciate it.
solved. Please Disregard.
"Steve" <email@example.com> wrote in message
> I messed...How to override the default NameSpace when deserializing an xml file
In my company we have a webservice that exposes an OBJECT, the company that
made the webservice gave us the object dll so that we can have there
functionallity (lots of logic).
As a part of some changes we made we wanted to remopve the constrain of the
dll they gave us, so we started using the class exposed by the webservice
and created a special class that will have the functinallity needed for that
The problem is that the object recieved from some queried to the webservice
was saved to a private xml file and is need to be deserialized later on...
Now that we have sta...form field validation
Does anyone know where I can find information - or examples - on how to add
validation to fields that FrontPage doesn't include, such as no special
characters, no commas, requiring an @ for email addesses, etc.
"Adela D" <AdelaD@discussions.microsoft.com> wrote in message
> Does anyone know where I can find information - or examples - on how to
> validation to fields that FrontPage doesn't include, such as no special
> characters, no commas, requiring an @ for email addesses...Email Router / Default Website / OWA?
We installed the Email Router and it looks like the "An
Error Has Occurred" (good lord could they make that red X
any larger, it's not like I did anything THAT bad...)
problem is related to us not installing the Email Router
using the Default Web Site in IIS.
However, the default website in IIS is being used by
Outlook Web Access. There is no documentation to tell us
how any of this will interfere with Outlook Web Access.
Does anybody have a solution - is there a way to setup
the Email Router on a different website than the default,
or does anybody have a solution to ...Need to change to Service account for CRM
Becuase of some problems on our system, I now have the need to changed
the service account for the CRM System. Does anyone have a procedure or
is there a method to make the change easily. Can I just create a new
Account and set the services to use the new Account.
There are two steps:
1. Create the new service account, and add the account to all required
groups on CRM server, SQL server and in AD as per Implementation Guide
2. Set the CRM services to use the new account
"Mykre" <firstname.lastname@example.org> wrote in message
news:email@example.com...Change the source data in multiple charts
I have a monthly report that I publish that has a large number of charts
attached to it. Every month I go in and manually change the source
data in each individual chart. The columns are the only thing that
change in the source data, the rows remain the same.
Is there a way to automate the process or make a blanket change to the
columns in the source data to eliminate this tedious process??????
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
See an example of a dyna...How do I change the default location for importing text files?
In earlier versions of Excel, when I wanted to import text files, I would
click "Data", "Import external data", and "Import data". For the first file
to import, I would navigate to where the file was, and click on it to import
it. After the first file was imported, I would always be in the last folder
from which I imported data when I went to get a new file. Now I've upgraded
to Excel 2002 using Windows XP Pro. When I want to import data, the import
process always starts in the same place -- My Data Sources -- rather than the
last place I used, mean...Chart Default Line colours
Is there a way to predefine what line colours you want to use for each new
chart that you create.
thanks in advance
If you want to change it for all of your graphs
goto to the bottom row of colors and starting on the left, select the block
and modify ti as you want.
"Phil Wales" wrote:
> Is there a way to predefine what line colours you want to use for each new
> chart that you create.
> thanks in advance
Excellent - Thanks for that- my boss keeps telling me off for using standard
default p...xmlDocument.Save " " getting changed changed to "&#10"
I'm using xmlDocument.Save(xmlTextWriter) to create an Excel-readable
file. All works well, except where I've replaced the carriage return
chars in the .innertext to XML-compliant "
"; It gets changed to
"&#10" and doesn't render new lines in the Excel sheet.
Can anyone help?
> I'm using xmlDocument.Save(xmlTextWriter) to create an Excel-readable
> file. All works well, except where I've replaced the carriage return
> chars in the .innertext to XML-compliant "
"; It gets c...Changing the Setup and Utilities Menus'
I was wondering if anyone could quickly detail the process
needed (If at all possible) to delete entries from the
Setup and Utilities menu's in Dynamics 7.0?
To clarify: I'm not talking about the palette's or even
the toolbar, I know these, but the Windows toolbar
directly underneath of the Title bar.
My guess is that it would have to be done through VB
Editor, since it deals with this particular toolbar. I
was hoping someone would know the name of the module or
class that it is in, things like that. I'd appreciate any
help that could be provided. Thank...Re-Post-Refreshing Form with Multiple Forms and Fields
Would anyone be able to assist with this challenge. Thank you.
I have a main screen form that allows entry to start from that location. It
has four subforms and some other fields that are picked from other locations
to filter the record. My challenge is it does not Refresh right away. I
have tried putting Refresh and Repaint etc in the main form code but it still
doesn't refresh. I put a Refresh button on it and that works but it's slow.
Can anyone tell me what would be a more efficient method to get this screen
to refresh right away.
Refresh and Repaint are n...Adding entity in Update Change
Is there a way to add customize entity when defining new rule on workflow
Action> Update Entity? By default, the Update entity of opportunity consists
of account, contact, owner and opportunity. I want to add another customize
Is it possible? How to do it?
when you create a relationship between the opportunity and the custom entity
the referenced entity list will be auto populated. Note that if the 1 to many
relationship exits from opportunity to this custom entity and <opporutnity>
refrence entity will appear when creating rules for the custom e...Formating Comments field in Contacts, Changes often don't stay
I've noticed that I can change the text formatting on words in the comment
field in some of my contacts and not others. For example, if I make certain
words bold, save and come back. Occasionally changes aren't kept. All I
see is plain text. Thanks in advance
...I need to export data from Ms Access form to a text file.
I have a form from which I want to export data using a button to a text
The form contains data from two separate tables and I need the data on
a single text file.
Please help with the code on the button.
Any help with the coding will be appreciated
See help on:
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bright" <firstname.lastname@example.org> wrote in message
>I h...Combo box on user form
How can I get the correspondin record when I have the
first field only in the combo box? Thanks
...Change what style is used for TOC
Right now I have a style called "Chapter Title", and then I have used
Heading 1, and 2 for the sub headings. When I tried to make a table of
contents, it left out the chapter titles and used only the headings.
How do I either:
(1) rename the Headings (so that Heading 2 becomes 3, 1 becomes
2, and "Chapter Title" becomes 1),
(2) get the table of contents to follow a customized set of
stiles (so that my chapter titles will be included)?
In article <email@example.com>,
paws_galuten <jason...Default address list in exhcange 2003
can I delete the default address list to add my own?
Think it through and test before you do:
"Josh" <firstname.lastname@example.org> wrote in message
> can I delete the default address list to add my own?
I do not suggest doing this unless you want to cause full OAB downloads for
your clients. If you want to create your own OAB, create a new one and apply
a filter to it (if you wish). Then make sure that your mailbox stores are
associated with your new OAB, and your c...How do I get one cell to record the time another cell was changed.
I know there's a simple solution to this, but I'm not seeing it. How can I
set up a cell to update the time (or date) whenever another cell has data
entered into it; e.g. cell A1 has new info entered into it, and cell A2
automatically updates the time of that update. Thanks in advance.
"Reigning in Seattle" wrote:
> I know there's a simple solution to this, but I'm not seeing it. How can I
> set up a cell to update the time (or date) whenever another cell has data