Roles and 'Settings' for user interface CRM 3.0
I'm wanting to create a role for a new user that has basic access.
His web interface allows him access to the Settings Tab, which I don't want.
From there he can change 'Business Unit Settings' and other settings.
I thought it was a matter of my selecting the wrong settings in the role
creation, so I created a 'Basic' role with NOTHING checked off and assigned
it to him exclusively. It still gave him access to the settings tab, and
'Business Unit Settings'.
Surely there must be a way to limit user access to this tab.
Have you ...macro embedded in an xml file
Hi, just wondering if anyone knows if you can embedd a macro in an xml file?
I have an xml file that I create with a .net web application and it opens
with Excel, but would be nice to attatch a macro to it as well.
> Hi, just wondering if anyone knows if you can embedd a macro in an
> xml file?
XML isn't a programming language, so it can't have macros in the sense
that you mean them. See http://xml.silmaril.ie/authors/execute/
Some processors (including browsers) may react to special features like
Processing Instructions to...Sumproduct
I should make a condition(AND) in my sumproduct formula with date
format(yyyy/mm/dd), why it dosent accept my condition in one column, like
even I dublicate date column(G) and change the formula to :
but it dosen't work again, any idea to solve this problem would be
I don't see anyting wrong with your formula.
Instead of multipl...Best way to separate user accounts?
We are running Exchange 2003 Enterprise Edition in single server, single site
mode., with AV and antispyware running locally on the server as well. There
are about 500 accounts for faculty and staff and the server runs fine with
little performance issues. The server is a Dell PowerEdge 2850, with a dual
Xeon 2.8 Ghz processor, 4 GB memory, 300 GB disk space, with 250 GB being
free. Just today it was requested that we create Exchange accounts for ~200
graduate students on this server.
Given the information above I am interested in what the experts on this list
think would be the best r...VBA Text Color
I would like to change the text color to Red for a string being returned to a
window through vba when certain conditions are met.
I can see the vbRed control but cannot get it to work, Object Required.
Has anyone been able to change the text color through vba, and how is it set?
I don't believe VBA can directly change the colours on a Dexterity field or
window. You can use the unsupported but very useful method of pass through
Dexterity SanScript to change the colour of the text or the background.
I think you already have the company background colour VBA example. I...cannot reassign record to other user
5 person leave our company. I want to disable their user but before that i
need to reassign their records first. The first attempt works fine. But the
next 3 account raise error message everytime i run reassign records. So
there are only 2 account from 5 account which can run reassign record
Do you know what it might be wrong?
Here are the pop up error message:
"An error has occured.
Try this action again. If the problem continues, check the Microsoft
Dynamics CRM Community for solutions or contact your organization's Microsot
Dynamics CRM Adminis...Highlighting the selected row or column
Is there a way to put the cursor in a cell and have that entire row and/or
column highlighted? I would like the highlighting to be temporary and move
with the selected cell.
Thank you in advance.
Lewis, have a look at Chip's addin at
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Lewis Clark" <lewis_clark_644 @ yahoo.com> wrote in message
If I have two columns of numbers:
How do I write a formula that will sum every number in column B that
corresponds to a 1 in column A.
The answer should be 120.
Thanks for any help.
I believe you will want to use a sumif() function here
if your data starts in A1 then
On Dec 8, 10:19 am, Terry <Terr...@aol.com> wrote:
> If I have two columns of numbers:
> 1 50
> 2 40
> 1 20
> 4 10
> 3 30
> 1 50
> How do I write a formula that will sum every number in column B that
> correspon...Startup script to delete file
I'm afraid I'm not well versed in Windows Server, but I think what I want to
do is very simple.
I need to have the startup of Server 2003 delete a file that may or may not
And here is why - when the server is not shutdown correctly (e.g. power
outage), the .pid file for our rsync service does not get deleted. So when
the server starts up again, the rsync service does not start because the .pid
So I'd like to have the file deleted on startup, just in case it is there.
I've done a lot of research, but am getting very confuse...How to open previous version of Publisher file when I only have 20
Keep getting, "Publisher cannot open files from a different version". I
thooght there was some sort of converter or patch to do this.
Different version does not mean previous. Usually it means newer. There is no
patch or converter for this. You can ask the originator to save it as your
version or send it as a .pdf.
> Keep getting, "Publisher cannot open files from a different version". I
> thooght there was some sort of converter or patch to do this.
...Conditional Formatting with XML
I recently became aware of the possibility of using conditional formatting
to highlight the cells in a spreadsheet which contain formulas. This uses
the GET.CELL method from XML. While it cannot reference another workbook
(like Personal.xls), I have still been able to write a macro in my
Personal.xls folder that sets the name range and conditional references in
the active workbook; while I "wrote" it, I heavily borrowed from others
posts on a website :) The function and sub below toggle this conditional
formatting for the entire worksheet.
Question: how do I set this up so that ...VBA Excel: Move rows which match a certain feature between tabs
I have a hughe matrix of numbers. Such matrix has headers in its
columns (first row). Say that headers are A, B and C ().
What I want to do with a VBA script is to look into the rows to check
if what of them have the value "30" in the column header.
In such case, I would like to move the row from that tab to another
one called, e.g., "Tab_30". An important point is that I need that the
row in the original matrix has to be deleted. I do not like blank rows
in the original matrix nor the new matrix in the tab "Tab_30".
I am not an expert in Excel. I just rec....pst file size limitation
I read somewhere that there is a file limitation for .pst at 2GB..
beyond 2GB in size, the whole file is subject to problems an
I receive a huge amount of emails not to mention attachments in larg
sizes... I reach the 2GB limit within 6months...
Can someone please provide some solution on how I can overcome the 2G
obenix's Profile: http://www.msusenet.com/member.php?userid=401
View this thread: http://www.msusenet.com/t-187096263
Yes, there is 2GB(in exact 1.82GB) PST file siz...Unpack Files to memory and then run them (exe protector style)
Is it possible in anyway to load a file into memory and then run it
from there? I am working on a file compressor
(www.nemokprod.go.ro/nb.htm) that can compress and encrypt and save
multiple files as an exe file that can then run the compressed files
after unpacking them to a temp folder. The problem is that I have to
unpack the files to the hard-disk and then run them from there, making
them vulnerable to user that may try to get the original (unprotected)
So the user shouldn't have access to the file operations in the
background. So I need to keep the original unpacked files hidd...If SUMPRODUCT & Blank cells
I am running Excel 2003 and I am trying to
count a range of data for charting.
I am using the following formula:
It works great....except...
In column $M$3:$M$189 there are also
blank cells and I want to count these a...SUMPRODUCT and OR?
How do you count rows from criterias in two columns where the criteri
shall be OR? I.e. something lik
but where you get a count on number of rows where either (both column
are = Car) or (any of the columns are = Car)?
Message posted from http://www.ExcelForum.com
equirements'!$F$2:$F$10000="Car"))-SUMPRODUCT(('[jisses...adding user control to a cell in a DataGridView
Instead of one of the existing column types I would like to have a user
control appear in a cell in a gridview.
What I have done is created a control
CCTest : Control, IDataGridViewEditingControl
inherits from Control, and implements IDataGridViewEditingControl
I then create a cell class
TestCell : DataGridViewCell
in here I override public override void InitializeEditingControl(int
to set the editing control for the cell.
these get used in a column I create and add to t...Exchange admin viewing users emails
I am the Exchange admin for my company and I need to view the emails of one
of the employees and am unable to do so.
My account is already part of the domain admins and the permissions have
been added on the Exchange System Manager, but when I try to open the Inbox
in my Outlook I get an error. (File -> Open -> Other User's Folder). When I
get the name and select Inbox I receive an error "Unable to display the
folder. The information store could not be opened."
I have even specifically added my own account with all permissions and
received the same error.
Hi, I am currently writing a database and what i want it to do is when one
particular field is filled in eg. Cylinder, then it will pick up only
"cylinder" items. I have tried this code below but it doesnt seem to work.
Could someone please help me.
Private Sub Job_Installable_AfterUpdate()
'If Job_Installable.[Column](1) = "Cylinder" Then
' [tblJob_Consumables SubForm]![Job_Consumable Consumable
ID].ControlSource = "qlkpConsumableCylinder"
'Else...Problem opening files from server
When attempting to open a file from the server by clicking the short cut to
the folder on the server, then the file I get the following message:
Windows cannot find 'L:\name_of-file.xls'. Make sure you typed the name
correctly, and then try again.
If I bring up excel 2007, then click the "folder" to the right of the
'Office Button' (upper left hand corner), it brings up a listing of the
network drives and the files under them. I can click on the *.xls that I
desire to open and it opens it without a problem.
Also, I can click the 'Office Button' and th...Help Debug Complex Formula (SUMPRODUCT? SUMIF?)
I'm really struggling with this one.
I've got 354 rows of data (rows 3:352). In column G there may be a date. In
column M there is a number (1-12) which represents a monthly period, and in
column O there is a dollar amount which represents a montly invoice total.
I need to construct a formula which calculates the sum of O for a specific
period M where there is a date entered (non-blank cell) in G.
The formula below is what I constructed but it does not work. Rather it
calculates the sum of O for the specified period in M but then multiplies
the sum ($16,200) by the num...Storing files in folders
I have Outlook 2002. How do I store all files in a folder to a CD-Rom disk.
I have tons of video clips jokes that people send me. Thanks in advance.
David <firstname.lastname@example.org> wrote:
> I have Outlook 2002. How do I store all files in a folder to a
> CD-Rom disk. I have tons of video clips jokes that people send me.
The simplest say is to close Outlook and copy your PST to a CD. To be more
selective, create a new PST and move the folder you wish to preserve to that
PST. Close Outlook and copy that PST to the CD.
...How to merge 10 files in one step?
I would like to check is it possible to merge 10 files with the same
format together with one step or less steps when compared to opening up
10 files and then copy and paste? I would really appreciate any help
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
There is no way built into Excel to do a merge other than copy/paste. (Well,
there is th...Center a string VBA
I have created this excel VBA function to center a string.
It works but is there a better way?
MsgBox CenterString("Center This String", 50)
Function CenterString(xInput As String, xLength As Long)
xM = Space(((xLength / 2) - (Len(xInput) / 2) + 1)) + xInput
CenterString = xM + Space(xLength - Len(xM))
Function CenterString(xInput As String, xLength As Long)
Dim xM As Long
xM = Int((xLength - Len(xInput)) / 2)
CenterString = Space(xM) & xInput & Space(xLength - Len(xInput) - xM)
Continued from thread at
Is it possible to get SID of AD user and put it to CRM database to continue
use of changed user credentials???
"Peter Lynch" wrote:
> CRM permissions are linked to the SID of the user's AD account, not the
> username (logon name)
> The username (logon name) can be changed anytime
> The SID never changes