jul 25 Microsoft CRM scripts T-SQL tables update

T-SQL Update fields from another table / database

Use the script below if you need to update data between 2 SQL databases or inside the same database, it’s plain and simple when you get the grib on it: Copy the text bewteen Start code and End code into you SQL Management Studio START CODE: update DESTINATION_DATABASENAME.dbo.AccountExtensionBase –Write the database / table you want…

Read more

jul 12 Microsoft CRM

Associating Records in IFRAME

If you need to move menu items from the nav menu on the left then check this guide: http://www.microsoftcrmhouston.com/customization/Javascript.UsingIframes.html?accix=2 Plain and simple Have fun

Read more

jun 29 Microsoft CRM Outlook 2003

Outlook problems after upgrade from Microsoft CRM 3.0 to 4.0

Today I found a solution to an old issue I had in a deployment where I had upgraded the system from 3.0 to 4.0. All the outlook client was installing without any problems and had Rollup 9, but the CRM menu in Outlook didn’t work on all items, so they did not have access to…

Read more

jun 24 Microsoft CRM

Show count of notes on a form in Microsoft CRM

Use the code below if you want to show the number of notes on a form: The Code: //START:Show count of notesvar totalNotes = getTotalNotes(crmForm.ObjectId);setNoteTabName(totalNotes);function setNoteTabName(count) {    /* update note tab */    if (crmForm.FormType != 1) {        var cells = document.getElementsByTagName(“A”);        for (var i = 0; i < cells.length; i++) {  …

Read more