One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...If .NET 4.0 is new.....
If .NET 4.0 is a completely new framework, will anything compiled for 1.0 up
to 3.5 work with only 4.0 installed?
The comments I've seen in other places say you must have the previous
versions installed or 4.0 won't install and/or run.
"Tim Munro" <Excelsior@Liamtoh.moc> wrote in message
> If .NET 4.0 is a completely new framework, will anything compiled for 1.0
> up to 3.5 work with only 4.0 installed?
"Jerry" <ChiefZekeNoSpam@...CRM 1.2 Crystal Reports Error: updateViewState failed
When any user in the system tries to display a report, CRM gives the
Your request was cancelled. The necessary security privileges could not be
verified. Please contact your system administrator.
We are using CRM 1.2 on Win S2003.
How can I fix this?
try restarting the crystal services and test again
Microsoft CRM MVP
"Fredr...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...Index CRM with SharePoint Portal Server
I was wondering if there is any way to have CRM data be another content
source for SharePoint Portal Server to index?
It would be very cool to let SPS crawl things like the Knowledge Base
articles so you could search for them from within SPS. Maybe even case
Just wondering if anybody has thought about a way to accomplish this.
To the best of my recollection Knowledge Base articles is already indexed by
the SQL server. It is possible to Index the rest of the database, but I don't
know if it is "legal" in terms of support and l...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <email@example.com> wrote in message
news:firstname.lastname@example.org...Combination Chart #4
I am working in Excel 2003, and I would like to make a
combination chart. I have 4 data series. I would like 2
of these series to be a regular column chart, and the
other 2 series to be combined (in the same chart) into a
stacked column chart. Two of the series (example value is
14 & 27) equal one of the other series which is 41. Is is
possible to combine a column chart and a stacked column
chart? Thank You
Take a look at Jon's example for creating clustered stacks.
sue t wrote:
> Hell...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...Lotus Notes and MS SBS+CRM
Hello to all,
I have one customer who want to use CRM with Notes. He has using NT4 PDC,
NT4 BDC, Fil/Print server, Notes, SQL, AS/400 and Citrix.
Now he is intresting in AD using small business server with MS CRM. I need
idea for this structure who can i make this in working or any other idea for
AD, CRM, Notes and Citrix. *Customer have 45 empoly in local office and
around 12000 empoly in all over the world.
The short answer: No.
The long answer: Not with SBS. He could commit to a full AD configuration,
and add Exchange for the CRM Email functionality, but he'...How do I duplicate numbering on a raffle?
I am creating an event ticket but would like to number the tickets on both
the left and right sides of the ticket.
Create a data base with your numbers. Use mail merge for the tickets. You can
insert a mail merge field on both sides of your ticket.
When you merge have one ticket on your screen. What version Publisher are you
using. Some early versions of Publisher shows all the merge items the same in
print preview. This is a Publisher bug.
Mail, e-mail, and catalog merge
"Candi...Easiest way of moving CRM 3 data to new server
We setup all of our CRM 3 data on an old server. Now that we are using CRM
for real, we have ordered a nice new shiny box for CRM to run on.
Is there an easy way to move the CRM data across from the current box to the
new one? If not, its not a great problem, but would save a lot of boring jobs
for someone here.
Check the Implementation Guide for the recovery options. You can follow
those basic steps to "restore" the data to the new SQL box. Another option
would be to explore the Redeployment Tool.
MVP - Microsoft CRM
"Oliver Marshall" <O...Quit creating duplicate desktop icons when doing upgrades/hotfix
Upon any sort of upgrade or hotfix, RMS creates a whole new set of desktop
icons. What a pain! Pls fix. Ask if we want to create new desktop icons,
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/...How to delete "non-identical" duplicate records in an Access table
How to delete "non-identical" duplicate records in an Access Table? Where
"non-identical" duplicate record means a record in the table that has
slightly different datum in one of the fields, but an identical duplicate
datum in the field that I am concerned with. For example:
SSN MRN CLIENT NAME
001-00-2222 11170419 Smith, Jane
001-00-2222 11170419 Smith, Jane T
001-00-2222 11170419 Smith, Jane Thompson
The data of these two records in the fields SSN and MRN are identical; but
"non-identical" in the CLIENT NAME field (notice...CRM 3.0 Performance 07-02-06
I have a customer who is a bit dissapointed in the performance of CRM in the
Outlook client. CRM is running
on a SBS server and there only is 5 users, no problem with performance, 2 3
ghz processors 3 gb ram.
The problem is that he is comparing it to the financesystem with native
database which responds the same time he click a button. CRM takes some time
to load the first page and also performs slower than what he is used to
opening the next pages of the same entity.
He can't understand why this new product is so slow, tomorrow I have to
explain it to him.
Have any of you had this...New .Net 2.0 Install?
I'm attempting to install Financial Calculator software for my Palm 700w.
When I do I prompted to install .Net 2.0.50727. Will this cause any issues
with CRM 3.0?
I don't want to mes something up that I can't fix.
Are you installing the finance calc on your PC? if so, you are ok because
CRM is a server based app. You use internet explorer (or outlook) to access
CRM, but the processing is done on the web server. So, the framework on your
local pc doesn't matter.
Also, the CRM web server must be configured to use .net 1.1. Note: you can
install .net 2.0...Duplicate ItemLookupcode
Any clues on how I could get duplicate itemlookupcodes?? I found a few of
them recently. No SQL queries have been run to generate them and if I try to
create a duplicate itemLookupCodes I am stopped with a message telling me to
use a unique name. How could they have gotten in the database? Any clues,
boos or comments appreciated.
Thanks for all the help!
This is a multi-part message in MIME format.
As you mentioned, RMS Manager doesn't ...GP 10.0 toolbars not sticking
The "Lock Toolbars" setting does not seem to be working for a GP 10.0
client. She arranges her toolbars, but they don’t stay. Is there a way to
lock the selection, or do they always return to the default? She, also, has
two SmartList icons.
Is this a bug? I have looked at a couple of the more recent service packs,
and they do not seem to address this. The client is on the hotfix that was
released shortly after service pack 2.
This subject was already posted before, the link of the post is shown below:
Why do the songs in my media player library often duplicate or tripulicate
themselves, so i end up with a library three times the size it should be. I
have on occassions gone through and deleted all the replicated songs, but
over a period of time they seem to "grow again" filling my library again with
unwanted duplicates, taking up more space and memory. Is there anyway i can
stop this happening?????
What version of WMP/Windows?
First, make sure that WMP isn't monitoring the same folder twice.
Duplicate songs can appear when, for example, both C:\Music a...Find duplicates in a column
I have 6000 emails addresses in a col and wish to know if there are any
How can I do this please.
I have Excel 2002.
Assuming your emails are in A1 to A6000, in B1 enter
copy down B1 all the way to B6000
Apply a conditional format of red pattern on cells B1 to B6000 where Cell is
greater than 1 and all duplicates will be shown in red.
> I have 6000 emails addresses in a col and wish to know if there are any
> How can I do this please.
> I have Excel 2002.
...duplicate emails received
I've been receiving duplicate emails. This doesn't happen with all the
emails I receive, only with some of them. "Leave a copy on the server" is
not checked. I don't know the reason why this happens. Can somebody help me.
Thanks in advance.
...Delete duplicate record
I have a table with 10,000 rows and 10 columns.
Column 1 has text values, I want to delete the record if they have a
duplicate, that is delete all the records.
So if Column 1 has a two, three, four,... rows with the same value I would
ALL the two, three, four... rows.
I have a query that finds the duplicate, but how do you delete this?
Thanks for your help on this
You could create an exact same table structure without any records. In that
new table make the column 1 the primary key. Then append the table.
> I have a t...3.0 Installation Errors on Vista with Outlook 2007
Trying to install CRM laptop client on vista loaded laptop with Office 2007,
I am getting the following errors:
1. Setup account is not a domain user
2. Unrecognized version of Outlook
It will not let me continue.
The laptop is not on the domain so I logged on as a domain admin and can
start the install that way, but still get the Outlook error.
Outlook works fine.
IE 7 is configured and can access the CRM data that way, but this person
needs the client.
You need to be on the domain for the CRM client to install and function. if
you are using Office 2007, try this client:
http://w...RM00401 duplicated document numbers
We are using version 10.00
There are some batches that don't post correctly. When the posting
process begins, is getting stuck in some point in the progress and
When we search in the tables, the documents appear in both WORK and
HIST SOPs. This case has ocurred before, so, what we do is search and
be sure that the GL accounts are ok, affecting the right amounts and
then, delete the transaction of the WORK table.
The problem we have now, is that every time the batch is trying to
post, creates a docnumbr in the RM00401 with the same number and 0's
added. For exam...Help with CRM!!!
We have suffered hard disk failure on the hard disk which has CRM on it.
We now only have the database backups for CRM. Is there any way to get CRM
data from the databases...?? I have tried installing CRM again, (creating
new databases in the installation) and then restoring these databases with
the database backups, but i then get an error when logging onto MSCRM
stating errors with the record/s....
******Can anyone tell me if it is possible to recover any data from the
database back ups alone......??!!!******
Thanks in advance
The implementation guide contains disaster recove...