Microsoft CRM 3.0 Installation 11-08-07
Good Day board,
Quick and to the point. I'm installing a trial copy of Microsoft CRM 3.0
that I got at a computer conference recently and I've gotten everything
to work in the System Requirements dialog except that it's telling me
that "The minimum required version is SQL Server 2000 SP4 (8.0.2026)".
Strange this is that I do believe that I have SQL Server 2005 installed
on the machine.
Any idea how to be absolutely sure of what version I have installed?
Have you choosed the right name of SQL server during installation set-
You have to make it sure if it is ..."View Image Slide Show"
(Running Vista Ultimate 64-bit, SP-2, IE-8, WM-6, WLM-09,
classic mode, dial-up.)
In Windows Live Mail, most of the time when I receive an
email with 2 or more .jpg files attached, there is an option
shown as: "View Image Slide Show". Clicking on that line
brings up a screen which allows me to cycle through the
attached .jpg files, viewing them in sequence, going back
and forth as I desire.
About every 10 or so emails having some .jpg files as
attachments I receive one, with several such attachments,
which does NOT have the "View Image Slide Show" op...Count If Formula #4
I need a formula that will figure the following:
If column C = 3, count all times < 00:45
If column C = 4, count all times < 00:45
If column C = 3, count all times > 00:46
Your description is a bit confused.You have different actions for the same
value (C=3). And where are the times, in a different column than C?
So, making many assumptions, perhaps
(remove nothere from the email address if mailing direct)
"Denise"...Autonumber created.. problems in the future?
I managed to create an autonumber in Microsoft CRM. I did this by
making a field "Number"(in the database "New_Number") and I published
it on the form.
Then I went To the SQL server and I changed the field in the table to
Identity Yes, Identity seed 1, Identity Increment 1.
I locked the field on the form.
I think that this is not supported by Microsoft. But has anybody got
any idea which troubles i could get with this configuration?
Do you know all add-ons for Microsoft CRM? Visit http://www.pimpmycrm.com
The biggest dange...learning Excel #3
I was considering learning Excel as an additional tool for my data analysis
Is it better to use data sets that I have previously used with SPSS and
apply the same analysis tools as in SPSS? For applying the appropriate
tools, I was considering using excel's online help.
The second option I have is to use some excel book for data analysis and
apply the techniques to data sets provided with the book.
...Certain Keys/Characters not recognised when creating a task
I've just attempted to create a task and the edit control for the subject of
the task refused to accept the characters c h s t u and v. I was able to
switch to other applications such as a command prompt and internet explorer
and type the characters quite happily (so there is nothing wrong with the
keyboard) but when I switch back to Outlook it will not recognise them. I'm
using Outlook2003 as installed with Office 2003 Professional (SP1 and all
other updates applied). As a last resort I closed down Outlook and restarted
the program which is now accepting the keys/characters. A...Show date, time & day of week in one cell
Can I show the date, time and day of week in one cell.
09/03/07 8:30 AM
in one cell using the format (Format/Cells/Custom):
[$-409]mm/dd/yy h:mm AM/PM;@
Excel refuses to accept ddd for Mon or dddd Monday at the end of the format
I want it to read:
09/03/07 8:30 AM Monday in 1 cell.
I have Excel 2003.
mm/dd/yy h:mm AM/PM dddd;@
In article <Xns99B8A3CAF9130pencilunlistedcom@18.104.22.168>,
Burp <email@example.comINVALID> wrote:
> Can I show the date, time and day of week in one cell.
> I have:
> 09/03/07 8:30 AM
> in one cell using the for...Columns #4
My columns in Excel have disappeared how do I get them back?
I'm just guessing what you mean.
Tools > Options > General
Remove check from "R1C1 reference style"
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"me" <firstname.lastname@example.org> wrote in message
> My columns in Excel have disappeared how do I get them back?
Another gue...New Record
I'm using the following in the On Click of a command button.
DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
Anyway I can do this without referenceing the Object (Form) name??
DoCmd.GoToRecord , , acNewRec
Mark A. Sam
"JamesJ" <jjy@adelphia_darwin.net> wrote in message
> I'm using the following in the On Click of a command button.
> DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
> Anyway I can do this without referenceing the Object (Form)...explanation of codes in Visual Basic when creating User form
I am trying to create a user form in Visual Basic however I'm trying to
teach myself by reading/watching tutorials. (www.contectures.o.ca, etc)
A lot of the instructions I am seeing simply give the code rather than
explain how to actually write one from scratch.
I need to know what each 'term' means so I can understand how the codes work.
Any help is much appreciated :)
One of the first codes is for the Add button
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PartsData")
What d...Emails #3
I was wondering if anyone knew of any web based email provder that I
could use that wont be bloked but the I.T Filer at my work. I require
use of emails during the day for personal use but work emails are
monitored. I have tired various sites i.e Hotmail, Yahoo, Gmail, lycos
etc but they are all blocked. Does anyone know of any that may not be
picked up buy the web filer.
It is difficult to answer because it depends on what your filter is and how
it is monitored. For instance, if it is actively monitored and somebody
found out you were accessing the site, then it coul...How to create an autonumber field?
i need to create an autonumber field to automate account numbering. how can
i do this?
You can do this using a post callout piece of code so when you update an
account this code is called which calls back into the platform and works out
the last account number then adds one to it and updates the account record.
look on msdn.microsoft.com under crm for examples
Microsoft CRM MVP
"Max" <Max@discussions.microsoft.com> wrote in message
> i need ...Savings a/c cashflow doesn't show withdrawals
When I do a cashflow forecast for my savings a/c it
doesn't take into account transfers to my "cash" account -
the one I use to keep track of what I spend my cash on.
Consequently when I do the cashflow it gives an unreal
projection of savings. I wish I could save $3000 in 2
months but it's not going to happen...
...will CRM load on a 2003 server?
will CRM load on a 2003 server?
Microsoft CRM v1.2 supports Windows 2000/2003 Server.
>> Other Microsoft CRM Online Forum Resources:
>will CRM load on a 2003 server?
No problem. We just completed a 1.2 installation on a 2003 server, without
"Troy Hicks" <email@example.com> wrote in message
> will CRM load on a 2003 server?
CRM 1.2 will also load on Small business server 2003 as wel...CRM menu is dim
The "CRM" menu pad in my Outlook client is dim (disabled). Does this mean my
CRM 3.0 client is not functional.
I got the message following message after installing the 3.0 client for
"An error occurred loading Microsoft CRM functionality. Try restarting
Microsoft Outlook. Contact your system administrator if errors persist."
Many thanks for anybody who can help.
Most of the time, in my experience, this means that it cannot connect to the
Do you have a connection to the CRM server? Try browsing to
http://<yourcrmserver>/mscrmservices/20...Viewing group calendars in CRM
I was wondering if it is possible to view other
employees' activities and appointments in MS CRM? I know
this feature is available in Outlook 2002 and higher
through group schedules but I have a client running
Outlook 2000 wanting this cabability.
No, you can't. not sure if next version will have it. there is an
ISV, http://www.ssyh.com/products_ssyh_MSCRM_GrpCal.html that has
developed a group calender.
we have found this useful for those migrating from Goldmine.
I have this feature implemmented. If you are interested, contact me.
Vin�cius Pitta Lima de Ara�jo
&qu...HOWTO: Customizing CRM
We would like to customize our CRM Opportunity form. We want to
include a OpportunityNumber field, which will be auto-generated when
the new opportunity is created, similar to auto-numbers for Contracts,
Cases, Articles, Quotes, etc. Is it possible and how do we go about
I've looked at CRM Deployment Manager. It's possible to create a
simple custom Attribute for particular object. But I couldn't figure
out how to make it an auto-generated number, like SQLServer
Identity... Could I just modify OpportunityBase table in MSCRM
database? Do I need to change METABASE databas...Reply To Email after installing CRM Outlook Client
After installing the CRM Outlook Client, when opening an email and selecting
REPLY, the current windows looses focus. I know this sounds minor but many
of our power users are in the habit of hitting REPLY and typing without even
looking at the screen. It is not until they look up do they realize that the
window no longer has focus thus everything they thought they typed now has to
Has anyone seen this and know of a quick fix?
Thanks in Advance
Have you resolved this?
I have the same problem, and it is VERY annoying.
"Kenneth Clebak&...Cannot Delete Any Records
We're running CRM 3 Rollup v3 and we have recently found that we cannot
delete any records in CRM. We recently migrated over to a Windows 2003
Enterprise install running SQL 2000 Enterprise. Everything else is working
without issue for us. For example I am a Sys Admin, and I receive a generic
SQL Server error when going to delete an activity? I know that in the past
this was possible, any thoughts?
Sean; sounds like something went wrong with your migration. you can run a
CRM trace or a SQL Profiler trace while performing the deletion to see if
you can pin-point the error.
How do I make Excell tell me the day that the Date
Example: If I have 8/7/03 in a column, I want to be able
to enter a formula in the next column such that Excell
would tell me it is Thursday
Look at the WEEKDAY function.
Serial_number is a sequential number that represents the date of the day
you are trying to find. Dates may be entered as text strings within
quotation marks (for example, "1/30/1998" or "1998/01/30"), as serial
numbers (for example, 35825, which represents...CRM and Outlook Integration 07-22-03
I haven't seen a whole lot of great documentation on this - so if someone
knows where some exists then please tell me - but I'm curious as to how
featured the Outlook/CRM integration is? I see there is an addin for Outlook
that gets installed, but it looks to me like it's nothing more than a
synchronization tool between Outlook and the SQL Server - am I right? It
looks like it syncs Contacts, Emails, Calendar dates, etc.
I've looked through the SDK documentation and I've browsed a couple posts,
but none really say outright in exactly what way does Outlook and CRM
...number format with leading 0
Dose anyone know how to create a number format that would show a leading zero
for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
text format but would like to retain the integrity of the number.
Does that help?
> Dose anyone know how to create a number format that would show a leading zero
> for the numbers 0-9. That is, so that 1 would show as 01. I can do with a
> text format but would like to retain the integrity...How can I create Schedule Chart?
I have simply an activity list which shows START and FINISH date of
related activity. I need to put this information into a Chart, so
i will get a bar chart highligting the line between the START and
FINISH date of the activity.
It is very similar to what we can create in Microsoft Project.
Do you know a specific chart type for this?
It's called a Gantt chart:
"mezzanine1974" <firstname.lastname@example.org>...how to create a multiple conditional formula
I am trying the find a solution for the following multiple formula (example);
IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
expressions in one formula. I can't find a good solution. Is there anybody
who can help me? Thank you in advance.
"Ad Buijs" wrote:
> I am trying the find a solution for the following multiple formula (example);
> IF(A1="K"; B1+(B1*C10);B1) AND IF(A1="N";B1+(B1*C11);B1). So actually two
> expressions ...View Null Results in Query
i have an access 2003 query
SELECT [AlarmData Table Filtered By 60 Min Trip].[Event Type], [AlarmData
Table Filtered By 60 Min Trip].State,
[Date], TimeSerial(Hour([Date/Time*]),Minute([Date/Time*]),0) AS TimePeriod,
Count(*) AS Total
FROM [AlarmData Table Filtered By 60 Min Trip]
GROUP BY [AlarmData Table Filtered By 60 Min Trip].[Event Type], [AlarmData
Table Filtered By 60 Min Trip].State,