CRM 3.0 Implementation
I am interested in the experiences of others with implementing Microsoft CRM
3.0. I am a one man development team who has been tasked with implementing
CRM 3.0 with 30 users initially.
Our organization has been running on Lotus Notes for quite a while. We moved
to echange for e-mail over a year ago but still use Lotus for custom
databases. The first step will be pulling the data from Lotus Notes to CRM.
I have looked into the Microsoft CRM 3.0 Certification. There is a company
that offers a 10 day CRM 3.0 boot camp. Is this a good idea, and at what
point should I take it? We would lik...Web query timeout setting.
I fill an Excel table using data that I take from an Internet
Unfortunately, this site is very slow and so I often get a "query did not
provide any data" error message.
How can I increment the default web query timeout limit?
Thanks in advance,
...crm 3.0 error 03-01-06
I'me getting this error while installing crm3.0 for SBS:
"error writing to file microsoft.mshtml.dll verify that you have access to
That file is in the C:\Program Files\Microsoft.NET\Primary Interop
I (and 'everyone') has full access to that dir.
What can I do about this??
...Macro for Sharepoint List and another Table?? Same # records?
I am creating a database which we have a form made up of prepopulated data
(from a sharepoint list) and also data input needed by a user (for example,
I have two tables: one sharepoint list that is linked to sharepoint website
and another table that houses the additional user inputs [table 2]. I have
linked the files based on the primary key. So, every record in my table 2
has a plus sign and it will expand and you will see the linked data from the
Is there a way that I can automatically create a record for every
corresponding record ...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Comments to print on invoices and packing lists
We have a client with a specific need for printing customer comments
and item comments:
1) They want to store comments on Customer Master. When a sales order
is entered these comments should default on the sales order with an
option to change. They want to mark these comments to be printed on
sales order, invoice, packing list and pick ticket.
2) Items are stored with item specific comments. These comments need
to come to the sales order when the order is entered with an option to
change. They want to setup comments with similar setup where they
print on order, invoice, pick ticket and packi...CRM 3.0 Login Problems
Some specific users are constantly getting prompted for CRM login in Outlook.
We are using desktop client (online) online. This happens randomly. We have
CRM 3.0 with rollup update 2 and IE7. We have also applied this fix
http://support.microsoft.com/default.aspx/kb/934243/en-us. Also added the crm
site to local intranet zone.
set the authentication in IE
check rollup update 2
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
>...Showing 3:54PM instead of 3:54:03PM
How do you get rid of the seconds in the time area. I have changed the
formatting in the time. I use the excel file as a data source. I include the
time in the mail merge. It always shows up with the seconds in the time. Very
it may be formatted as text, so won't respond to changing the time format.
if it is text, the TIMEVALUE formula will convert it to a decimal-based time
value which can then be formatted by using Excel's normal Number formatting--
to get rid of the seconds.
> How do you get rid of the secon...Hyperlink problem #3
I've got two workbooks on a shared drive with hyperlinks
linking the two. When a user clicks on the hyperlink on
the first workbook, it takes him to the second workbook.
Fine. However, when the user clicks on the hyperlink in
the second workbook to go back to the first, the error
message says that that workbook is already open and it
cannot open two files with the same name. Help is
I just tried a small test in xl2002 and it worked ok for me. I use
Insert|Hyperlink to create the links.
Are you sure that the hyperlinks point at the file you want--same folder and
e...Outlook Client #3
I have recently installed crm outlook client for one of my users and then
also installed the 2 rollups for version 3.0 . Unfortunately outlook is
still restarting even after the rollups. Kidnly advise the necessary
solution that resolve the problem.
Please clarify, outlook loads and then crash "restart"? Has Office applied
with latest Office update?
Frank Lee, Microsoft Dynamics CRM MVP
"Faiz Amir" wrote:
> Dear All,
> I have recently installed crm outlook client for one of my ...Rounding Numbers #3
I have a list of values as below:
I would like to create a formula that rounds the values to the nearest 0.05
eg. Round 476.14 to 476.15, 361.99 to 362.00, 375.36 to 375.35 etc…
Is there anyway that I can do this?
> I have a list of values as below:
> I would like to create a formula that rounds the values
> to the nearest 0.05 eg. Round 476.14 to 476.15,
> 361.99 to 362.00, 375.36...Report to show Item Class Distribution Amounts
We would like to create a report, using Crystal Reports, that would show the
following: dollar amount break down of the Sales Distribution accounts (COGS
and Sales) per item class based on a date range. What is the most accurate
way of going about this? We could only think of this method: (in short) sum
the Ext Price based on SOP30300.CSLSINDX and SLSINDX and hope it matches the
SOP10102 summed distribution amounts. Any advice would be appreciated.
Thanks in advance.
With the SLSINDX you would use the Extended Price and the CSLSINDX you would
use Extended Cost. You would probably ...SetWindowsHookEx #3
Could someone explane to me what is the purpose of dwThreadId, the last
member of SetWindowsHookEx function?
I've expected that this is a thread id with which hooks is associated. That
means that hook is getting only messages produced by this particular thread.
But it looks like I'm getting system wide messages anyway. so could somone
make it clear for me?
In fact I need to process a mesages of only one window. I know the thread id
of that window. But! this thread is not in my process! And I don't want a
real system wide hook because it slows down the box.
Ok, I think ...RMS 1.2 vs 1.3, plus integrate with Great Plains
1.) I am working on an assessment for upgrading our current RMS software from
1.2 to 1.3. My assessment will take in account the benefits, broken down by
store operations (Retail) and the benefits to IT. Also, list risks and
potential problems that might be experienced. We currently have 28 stores
with 3+ registers per location with another 22 new stores on the schedule
over the next 2 years. Are their other in this group of similiar size that
have done this upgrade to the new version?
2.) If we do not upgrade the software, can we still integrate the RMS to
Great Plains? Would we...Determine a result of one column based on conditions in two column
Col A Col B Count the number of a's in Col B only when an x is in
x a Result should be 2
z p I can't figure it out
x m Thanks
Hope this help
Please click the Yes button below if this post have helped answer your needs
> Col A Col B Count the number of a...SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would:
1. Set the Restock Level for all items to be equal to the current on-hand
quantity for each item.
2. Set the Reorder point for all items to be equal to 1/3 of that items
I'm currently doing this manually, or using a formula in excel when items
are initially imported into the DB, but there are still several thousand that
need to be retro-fitted like this...
Thanx in advance!
UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)
UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)
Ne...Format List Box!
Can I format a list box which has a query,so if one of the fields called
[Spelling] had the word "Spelling" it will change the colour of the font for
Thanks for any help....Bob
It's not possible with the native Access ListBox control. Instead, setup a
Subform control to resemble a ListBox and use ConditionalFormatting to
achieve the desired look. I think Arvin has a sample on his site here:
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can ben...List the UNIQUE certain fields from the database
Please help related to the above subject.
From this discussion, got the following formula which is work well and
faster for small of database.
where $G$1, the first row of DATA.
how to convert it to VBA as this time i have a huge database.
for Tab Data, Advanced, Unique Record only (works well also, but i need the
basically we would like to do similar like this:
B...distibution list / updating
when we update our contacts how can we get outlook to
update our distribution lists at the same time.
What do you mean exactly? Can you give an example?
Also what version of Outlook are you using?
>when we update our contacts how can we get outlook to
>update our distribution lists at the same time.
That's what the Update Now button is for.
"wayne" <firstname.lastname@example.org> wrote in message
> when we update our contacts how can we g...Print a list of movies
I have a spreadsheet with 2 columns (No and Name of Movie). There are 322
rows. I would like to print this so that I have the first 44 rows on the left
side of the page and the next 44 rows on the right side of the page. I would
like to keep this setup on all pages. These cells have color formatting and
numbers that I need to keep with each cell.
How do I do this?
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/...How to export users list from MS-Exchange AD Users&Computers?
I want to export my exchange mailbox-enabled users list with their Given
Name+Surname and e-mail address..
I get this kind of list from ActiveDirectory Users&Computers but I can not
I know that there is a program somewhere that does what I want, but I can't
remember it's name..
Note: I don't mean LDIFDE tools..
Thanks for your help.
As always...be careful and test things in a lab first, please.
LDIFDE tools can be pretty ugly...
CSVDE will work and it is possible to limit the columns that are output by
CSVDE. Note: If you have a large ...Query involving Strings : How To Return Matching Data From Both Ta
I have tried my best on this but am unable to figure it out.
Table A contains only one column titled [District].
Let's assume that there are three rows here:
1) Bay Area Rapid Transit
2) San Diego Zoo
3) San Mateo
Table B contains other data with these fields:
[GeoCode] , [CountOfHourlyEmployees], [CountOfSalaryEmployees].
Let's assume that there are three rows here:
1) West Coast | CA | Bay Area Rapid Transit , 154, 205
2) CA | Southern | Bay Area Rapid Transit , 105, 206
3) Southw...Inventory list columns
There needs to be more columns avaialble in the inventory and other lists.
It would also be nice to be able to print from the inventory lists.
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/dgbrowser/en...return max date from list
I thought this should be easy enough, but it's been years since I've
done serious excel work and I have gone into brainlock trying to figure
What I want to do is, find the date of the last occurance of a value, in
this case a number. For example:
A B C D E
1 23 32 44 01-JUL-03
2 3 7 56 03-AUG-04
3 12 34 45 23-OCT-05
4 23 26 58 24-MAR-06
5 15 37 79 23-JUN-06
6 11 32 39 28-DEC-06
I have a list of all possible numbers in another location, 1 thru 200,
and I want to put a formula beside each number that will find the last
date that number occurred in the array, in any ...