Visual basic and emprt fields
I recently converted from Access 97 to 2003. (we're a little behind the
times at my company). Anyway, we have some visual basic code which
interfaces with the Access database in order to populate BOM's in AutoCAD,
My problem is that the code does not like fields with 'null' values. It
didn't seam to mind then in 97? I've since entered a meaningless character
in those fields to get the code to function so the company can still run, but
is there a 'real' fix?
I'm only self taught at VB, but I think it has something to do with an empty
records...Is CRM 4.0 available yet through MSDN?
We are a registered user of CRM 3.0, looking to upgrade to CRM 4.0.
I don't see the download in MSDN online?
Anyone know how I can get the software?
Thanks in advance,
You can download it via Microsoft Download, on the site it includes the Trial
Keys that you can use for now:
Frank Lee, Microsoft CRM MVP
http://microsoft-crm.space...Validation of CRM email addresses in Outlook
Couple of problems that are occuring for us with CRM 3.0:
I am a habitual quick-keyer of e-mail addresses in Outlook; i.e., I enter a
snippet of the individual's first and last names, then press CTRL+K to
validate/underline the address.
Sometimes when I do this, and the person is from the CRM address book,
Outlook 'appears' to validate the address (it appears underlined) but on
attempting to send the message Outlook flashes a message about selecting at
least one recipient for the message. On right-clicking the person's name and
selecting properties, all the...Totals query and Memo field
I want to query a table and only display the record with the latest date.
When I add the Totals row to the query grid, the memo fields cut off at 255
characters. Is there any way around this? The fields display everything in
a regular query but I only want the latest date.
Post your totals query SQL so someone has the best opportunity to help.
Microsoft Access MVP
> I want to query a table and only display the record with the latest date.
> When I add the Totals row to the query grid, the memo fields cut o...CRM 1.2 User Access Error 'The system could not log you in..
My client has CRM 1.2. After some windows updates were done to the server
and possibly some reconfiguration of IIS settings, the users can no longer
log in as the following message appears:
User Access Error:
'The system could not log you in. This could be because : ...etc...'
Even the server administrator and the crmadmin account cannot login.
Is there any particular action that you helpful guys can think of that may
have caused this?
...AD users not available when adding to CRM?
I am trying to add new users to my CRM system and have had no problems on
the first 3 however the final 2 are having some issues?
When I use the wizard from deployment manager and it comes to the screen
where you can slecet users from the AD the people I want are not in the list?
They are in AD though? I have tried starting the 4 CRM services as an AD
administrator instead of the local account with the same results?
Why can I only see a limited list of users from the AD in the deployment
manager? I do think that the people I am trying to add are old emplyees from
our 2000 domain. ...Maxed out CPU on CRM Server
I have recently setup Microsoft CRM 3.0 Small Business Edition.
The install completed successfully but the process
is constantly maxing out the CPU.
The System specs are as follows:
(The System is a single server setup)
Microsoft Windows Server 2003 for Small Business server Service Pack 1
SQL Server SE 2000 SP4
Exchange Server 2003
The Computer specs are as follows:
AMD Sempron(tm) Processor
1.79 GHz, 960MB of RAM
If there is not a problem with the CRM system and the process is using
a normal amount of CPU, I have no problem with upgrading t...exchange crm router rules cleaning tool
I'm working with one server where is installed Exchange, AD, and Exchange
CRM Router, and another with CRM3.0. So I uninstalled the Exchange CRM
router without deleting the deployed rules. I installed the crm router again
but when some users sent emails one email is returned indicating that the
message could not be delivered to the past router's mailbox. I need to know
if it's a tool to delete all the past rules or a way to clean them manually.
You should be able to roolback the Rule - with the Exchagne CRM router tab,
If you dont you can delete the rule eith...Additional Fields for Items
I have a couple of questions regarding the items part of RMS.
1. Is there an open through MS or an addon available to add more custom
data fields on the item database that would be available to put on labels and
sort reports by? To answer in advance I am already using the 3 Sub
Descriptions offered, but I need more.
2. When making custom labels, is there a way to get the 'Notes' area from
the special page to go onto a label?
Thanks for any help in advance
One option is not to use the RMS Labels but use Microsoft Word with Mail
Merge and labels. This allows you t...Sort a numeric field
I want to sort the following in "true value" as opposed to the order that is
provided below. My import document provides this format. Maybe not the best
explanation, but can you help?
Thanks as always -
On Sun, 26 Jun 2005 09:16:02 -0700, "sdmccabe"
>I want to sort the following in "true value" as opposed to the order that is
>provided below. My import document provides this format. Maybe not the best
>explanation, but can you help?
>Thanks...Updating mapped fields
I made a mapping from account to a contact. The fields that are mapped
are the general adress fields. When I create a new contact from an
account the adress values from the parent account are used for the new
contact. So far so good.
My problem is that I want to automatically update the adress fields of
a contact when the values change in the parent account. This isn't
done automatically by MS CRM. Is there a way to do this? I've tried to
create a manual workflow rule that will do this, but that won't work I
Does anybody have a solution or some pointer for me?
Thanks in a...Microsoft Dynamics CRM Connector for Microsoft Dynamics GP is now available
This is a multi-part message in MIME format.
Microsoft Dynamics CRM Connector for Microsoft Dynamics GP is now =
Microsoft Dynamics CRM team is excited to announce that a packaged, =
out-of-the-box connector between Microsoft Dynamics CRM and Microsoft =
Dynamics GP (formerly Microsoft Great Plains) is now available. =
Customers can download this connector from CustomerSource =
(https://mbs.microsoft.com/customersource/support/downlo...CRM Deployment Manager SNAPIN
We are getting the following error when we try and use the
"The Selected snap-in did not initialize properly"
We have checked all the services and they appear to be
running correctly, we had tis problem in the past and were
able to resolve it by re-installing CRM, but the problem
has re-occured and we would like to find the cause of the
error and not re-install the software each time.
The event viewer has the following info for this error
"The description for Event ID ( 0 ) in Source ( DMSNAPIN )
cannot be found. The local computer may not have the
...Upload attachments to CRM notes via post to SRF
I'd like to be able programmatically upload an attachment=20
to a CRM note.
I know this is not available as a method in the SDK. =20
I've asked about this before on the message board and=20
someone suggested "posting to the SRF".
I've done the research, put together some code to do that=20
and have hit a wall. It seems that no matter what I do,=20
the SRF (MSCRMSERVICES/NoteUpload.srf) is returning back=20
to me this bit of html:
Error</body></html&g...CRM 1.2 Database on a server, and CRM 3.0 installed on a new server... how to move content?
does it possible to move the content from a CRM1.2 database to a new CRM 3.0
I can move the accounts and some information using CSV files, but not the
what can I do?
ideally you would upgrade the original system to crm 3.0 as well then use a
tool like scribe migrate to move data between the two systems
Microsoft CRM MVP
"Jeje" <firstname.lastname@example.org> wrote in message
> does it p...Separating field information
I need some help. Can this be done with queries?
Database has 13,000 records
All records are identical except for the History Field that will contain one
number 1, 2, 3, or 4
In a query that contains no records with a history of 2 select the records
with a history of 1 but not 3 or 4.
In a query that contains no records with a history of 1 select the records
with a history of 2 but not 3 or 4.
Thanks for your help.
That is unclear to me. You must be leaving out some necessary detail,
since the way I read your post all you need to do is apply criteria of
=1 for t...CRM 4: Queue items dupliccated both under the queue and in progress items
Is there a way to stop queue items being duplicated in the queue and under
the queue owners "in progress2 items. If it is deleted/assigned from either
place it remains in the other.
It seems similar to this http://support.microsoft.com/kb/919419 in CRM 3.
Or should the queue owner be an inactive user such as the system
All help much appreciated,
MR ICT Ltd - http://www.mrict.co.uk
...which sqlcedatareader method should I call for a numeric field?
I am developing a sql server 2005 ce appliaction. I have a numeric(18,10)
filed in my db table.
When I call oReader.GetDouble(0) after oCmd.ExecuteReader() and
oReader.Read(), I got a sql exception: invalidCastException.
So I am confusing... Which other method should I call for numeric field than
Thank you in advance.
> So I am confusing... Which other method should I call for numeric field
> than GetDouble()?
SQL Server numeric and decimal data types map to a .Net decimal. See
http://msdn.microsoft.com/en-us/library/4e5xt97a(VS.80).aspx for a com...Resources for CRM Workflow Sales Processes
Is there a good site or resource information to help with
ideas for building Rules Templates or Sales Process
Templates? I am new to CRM and have built a basic one
but don't really know what else might be possible.
In the MS CRM MOC they reference a company that does just that, and they have
some examples there as well: www.solutionselling.com
"Shauna Koppang" wrote:
> Is there a good site or resource information to help with
> ideas for building Rules Templates or Sales Process
> Templates? I am new to CRM and have built a basic one
> but ...Move CRM configuration to Test Environment
What do I have to do to move the configuration and VERY small number of data
to a test environment of the CRM to do some development etc. with?
"b" <email@example.com> wrote in message
> What do I have to do to move the configuration and VERY small number of
> to a test environment of the CRM to do some development etc. with?
Reinstall it. And then create some test records or load the standard demo
data. The data is hooked into the Active Directory so cannot be easily
relocated, except maybe with redeploment...Contact address fields Outlook 2002
I've converted my Outlook 2000 contacts to Outlook 2002, the address
information seems not to be right.
The City-info is in the ZIP-field, the state info in the city-field and the
zipcode in the state-field. In the 'All fields'-tab the information is in
the right fields.
I've migrated from Outlook 2000 SP3 English to Outlook 2002 Dutch. It seems
some programmer/translator mixed up the addressfields in the
contactinformation-window. I need this information for my program. Is this
solved in a servicepack/upgrade, or is any workaround available?
It seems to be a common probl...How sort recordsets with fallback tiebreak fields
Access 2007 developing 2003 database
I have a recordset I want to sort in ascending order of field
"localOrder" (Long). Sometimes there will be ties. In such cases I
want it to decide on ties by sorting on UrgencyID (Long). If there
are still ties, I want it to sort by "whenAssigned", which is a Date
I tried the following code,
Set rst = CurrentDb().OpenRecordset( _
"SELECT taskID, whenAssigned, UrgencyID, localOrder FROM
tbl_tasks " & _
"WHERE personIDassignedTo = " & myID & _
...Summing fields between two dates
I think I know how to do this but any extra help would be appreciated.
I have a table with four fields - net sales, payin date, payin number, and
payin amount. What I want to do is create a query that will summarize all of
the amounts in "net sales" within a specified date range. I thought an
expression reading SUM([net sales]) BETWEEN [start date] AND [end date] would
work, but it doesn't.
Für Elise - Support the Breast Cancer & Heart Foundations
SELECT SUM( [net sales] )
WHERE fieldWithDateHere BETWEEN [start date] ...Hardware for CRM 1.2 and SBS 2003 box
I'm just getting into MS CRM and would like to build a box with SBS 2003 and
MS CRM 1.2 but the hardware spec's seem to be a bit much. I'm looking for low
costs alternatives, any ideas?
You can exist with lesser hardware, but performance will be impacted. The
compenents all use a lot of resources (especially SQL & Exchange), so it all
depends on how much usage the box will get. I run my demo environments off
Virtual PC images hat run on my notebook, so it can definately be done.
MVP - Microsoft CRM
---------...crm form object
Does anyone have, or have a good idea how to get, a reference to the crm
I can figure out crmForm.fieldname.value Ok, but I would also like to know
about SubmitCrmForm enums, etc.