Moving CRM but not the data
We have a CRM 3.0 deployment where CRM is on one server, and the SQL
database is on another.
Is it fairly simple to reinstall CRM on a NEW server, and just point to the
current SQL database if we want to turn off the current CRM server?
Small Business Server Specialist
Microsoft CRM Specialist
Microsoft Certified Partner
Yes. Just do the install on the new machine and point to the existing DB's
during the setup. After it's working, you can uninstall from the old
MVP - Microsoft CRM
"Gavin Steiner" <gavin@...Display total of stacked column?
Running Excel 2000 on Windows 2000 Professional
Is there any way to display the total of the elements of a
stacked column at the top of the column?
I have a stacked column chart that shows four elements in
each bar. I chose "show values" on the "Data Label" tab
in chart options. This shows the values of each element in
the bar. In addition to these numbers, I need the total of
the four elements displayed at the top of each column.
Haw can I do this?
Found KB article that works. Just had to create a new
series with the totals and change the format s...multi line edit control
This is a silly question, but the answer has escaped me. I'm building
a CString in code and want to load it in a multi line edit control.
Normally I would use '\n' for a new line but the edit control doesn't
process this. What character should I insert in the CString to start a
new line? The edit control is set to multi line and accept return.
Use \r\n (CR NL)
"NewbProgrammer" <email@example.com> wrote in message
> This is a silly question, but the answer has escaped ...40 Column Receipt WITOUT item comments
OK - I admit I am totally confused.
I was thinking that item comments (CTRL F10 at POS) were not printing out on
the 40 col OPOS receipt register.
However, they are printing and the ~ is in the alignment. ???? The customer
does NOT want them to print. I was thinking that without the ~ (on a windows
printer only) the description would the line wrap and show the comments.
Again, they want the description to print and not wrap to show the comments.
<ALIGNMENT&...Data not showing in combo box
I have a database which uses a combo box with 2 columns, in Access 2007 I can
see the information from both, in Access 2003 I can only see the data from
column 2, if I go to the SQL query and run that I can see both so I know the
data is there.
Strangely if I try in Access 2000 I can see the data no problem, This
database was designed originally in 2000 and has been running fine on all
versions untill now so I am baffled - any suggestions so my colleague can use
in 2003 would be much appreciated. I have tried on a 2nd machine with 2003
and still does not work.
There was a bug...Can the MSDN version of CRM 1.2 be converted to a production system without losing any data?
I have the MSDN version of CRM. If I install it and configure a pilot
system, can I later convert it to a full licensed system without losing any
data? Does it require a new installation or just change the Company Name and
You would need to migrate the data to the new install. The AD objects & DB
Names are tied to the Org Name so you can't change them once they're
installed. You're best bet would probably be to use the DMF to load the
data to the new install.
BTW, I believe, technically, that using the MSDN license for a Pilot is not
I am trying to hide two consecutive columns but get an error message saying
"Cannot shift objects off sheet". What does this mean/what is causing this?
The data in these two columns is no different than the data in the 20+
columns I have been able to successfully hide previously (in this same file).
I've seen this message when there are no free columns in the worksheet.
Check for rogue entries in column IV.
> I am trying to hide two consecutive columns but get an error message saying
> "Cannot shift objects off sheet". What d...Tested hardware VSS provider table for Data Protection Manager
The table at the link below contains the list of VSS hardware provider tested
to be compatible with DPM for protecting virtual machines deployed on
clustered shared volumes (CSV). The fact that a VSS hardware provider for a
certain SAN is not listed below does not mean that it is not compatible, but
that it has not been tested.
J.C. Hornbeck | Microsoft
...Line Column Graphs
I am trying to create a graph from 4 sets of data. I am
looking at departmental success and as such have the
success percentage for 3 individual departmenst in
columns O,P&Q, and a global success rate in R. I want to
create a graph with teh departmental success for each day
shown in columns, and global success shown as a line.
However, when I chose the Line Column Graph from the
list, it only allows me to have 2 columns as opposed to
the 3 I require. Can anyone help?
It will be easier if you create a standard column chart based on the 4
sets of data. Then s...Plots
This is a multi-part message in MIME format.
Are there in Visual C++ plots drawing library like BCB TeeChart?
Thanks in advance.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r&q...External data retrieve timescale
Is there any way to lower the Refresh External Data time to below 1minute?
using application.ontime you can schedule a procedure that will refresh
your data more often than once per minute.
After data is placed in form, it doesn't show up after the form is opened
If i change the properties to NO data entry, the data will pop up again, but
after closing and opening the form again, it disappears again.
The data is in the tables/reports but won't stick in the form.
Message posted via AccessMonster.com
Are you saying that your form has the DataEntry property set to True?
The sole purpose of that property is to determine whether existing records
are displayed. If it's True, the form show...Outlook Format and line spacing.
I write a message/letter on HTML format single line
spacing, and when the Reply comes back to my Inbox my
original message is in double line spacing.
Even when I write a "test" letter to myself, again in HTML
single line space, the letter appears in my "In box" in
double line spacing.
How can we cure this?
...print Grid Lines
when i try to print grid lines they dont print, i have
tried to look at "format cell" then boarders and selected
inside with a solid black line. i have also checked
the "page setup" and the "sheet tab" and chedked "grid
lines" but i still cannot print grid lines. will some one
please help me.
>when i try to print grid lines they dont print, i have
>tried to look at "format cell" then boarders and
>inside with a solid black line. i have also checked
>the "page setup" and th...Macro to change position of chart labels on line chart
I have quite a trickly problem to solve and I would appreciate any
I have a dashboard page in a worksheet which shows financial KPIs
(i.e. sales) as forecast this year versus last year. There are a
number of line charts on the dashboard showing the differing
forecasts; the user of the dashboard can choose a business unit to
What I would like to be able to do is to have the chart labels for
these charts automatically change their aligmnent so that they display
properly. I have set the chart labels to display "Above" for the new
forecast and "Bel...plotting long plots
I have a HP designjet 110 nr plotter. I've created a plot that we nee
to show drilling activity. My first plot was 24"x36". Plot works grea
and to scale. My next plot was to be 24"x72". Now the charts will no
even display in Print Preview. I can scale back the plot where it i
about 48" and it will preview and plot, but I need it to go out eve
futher than 72 inches. I may go out as far as 30 feet.
I have images on the plot area and it will print it just fine at th
-----------------------------------------------------------------------...Importing Data #2
I am new to Money having previously been doing my own accounts in Excel. I
have data that could be used in money - payee, category, date, account,
amount etc. Is there any way of importing this data into Momey?
In microsoft.public.money, Max Scott wrote:
>I am new to Money having previously been doing my own accounts in Excel. I
>have data that could be used in money - payee, category, date, account,
>amount etc. Is there any way of importing this data into Momey?
Money can File->Import QIF and OFX files. QIF is simpler. QIF does
include payee, category, date, and...Creating relationship to Contract Lines
I have created a custom entity for subcontractors and I want to add a
relationship from the Contract Lines entity to subcontractors. i.e. in
service to allow the lookup of the subcontractor from a contract line.
I can add a relationship to the Contract entity but not to Contract Lines.
Any ideas why or how I can do this?
The reason you can't do this is that ContractLine is not a user owned entity.
Contract line is kind of unique. Most entities are 'user-owned',
'organization-owned', and a few are 'business unit-owned'.
The ownership is important becau...External Data Source and Adjacent Column / Data
I have a worksheet that gets it's data from an external data source. On
that same worksheet, the 2 columns immediately to the right of that dataset
are for "Notes" and a date.
My goal is that someone can put notes in that column and it "binds" itself
to that line of data, such that if the data moves to a different row in the
excel worksheet (because of other data changes or whatever), that note stays
with it. And if that line of data is removed from the dataset, a refresh
would also remove the note.
Instead, data in "Note" is binding to the row number...Plotting Data
Hi, how can I plot the analysis data in the document
class, in its related view class. Is it possible to make
plots like in MATLAB (surface plots,mesh plots of a
...Getting charts to automatically pick data from a series
Can I get a chart to always use say the last 9 values of a series?
Does excel also do interactive charts?
Yes you can have Excel chart the last 9, 30 or whatever number of values
that you would like.
You'll need to use dynamic range names to do this. Here are several links
that will get you started.
The idea is to create dynamic ranges that will update as you add data and ...import or query another db to get weekly data for a report
I realize I might not need an import because I don't want to write over the
imported data each week. Do I use a SQL update or append query to get data
from an Access db on our network? I don't see the tables in my query design
tool so I'm wondering how I do the query if I can't see the tables for the
...No signature lines in replies
I have an ongoing problem: If I create new mail my signature line is
embedded all right. But on the other hand, if I reply a message, the same
signature line is not embedded to the mail! I have to do it manually.
I set a signature text up in Tools>Options>Mail Format>Signatures for new
as well as Signatures for replies and forwards i.e. both cases have a
Any help will be appreciated. Thank you.
what version of outlook and are you using word or the outlook editor?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in...Read data from cells in different worksheets
I have a problem with my VBA code when I try to read values from cells
in two different worksheets. When I run the macro the program tells me
that I=B4m out of bound. But everything works when I save the data in
the same worksheet. How shold I write the code so that this simple
thing could work?
The data should be read when the user makes a buttonlick and then it
will be used later on.
The code is simple like this:
Public Sub Button1_Click()
A =3D Worksheets("Page1").Range("N8").Value
B =3D Worksheets("Page2").Range("I8").Value
I want to save the ...Filling Out Cells Based on Data Validation
I have created a drop down list using data validation. What I need to do now
is have cells filled out based on the value selected.
In this case, the list has three values (Cell A1), and I need to have a
range of cells (C7 to C54) populate data based on the specific value in A1.
The other data is on a sheet named "Data Entry."
Is this enough information or would I need to provide more?
VLOOKUP or INDEX and MATCH
Where are the data to pull over located on Data Entry sheet?
Gord Dibben MS Excel MVP
On Tue, 1 Jun 2010 14:33:01 -0700, Ericc =