HTTP Error 401.3
I hope someone can help me. CRM worked fine for a while, but suddenly
everybody, except the CRMAdmin account gets the following error:
HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the
The website is runnning on SBS2003 and i created the website myself before
installing CRM. The folder where the webdata is stored is :\inetpub\MSCRM
IUSR account does have the right permissions..
I cannot find any messages in the IIS website logfile
I found some articles about this error, but i do not know where to start
because they assume you have the w...Formula so that response is >value
The same cell has two formulas, IF(D3>0,LOG(C3/F3),IF(D3<1,LOG(C3/10)). For
example, if C3 is 1.0E+06, D3 is 100, then F3 will be 1.0E+03 (due to another
formula), and the response for the first part should read 3.0. If D3 is 0,
F3 will be <10 (due to another formula), and the response should read >5.0,
not simply 5.0.
I'm not sure I follow your formulas as described, but if you're looking to
have your results display the ">" character along with the value, then maybe
this example will lead you in the right direction:
Let's say cell A1 contains ...Exchange 2003 + Out 2K3 with connector Pop 3
I have one server windows 2003 with exchange 2003.
I have xx pc with windows Xp pro and Outlook 2003.
When i send a mail i choose when account send my mail, if a mail for
email@example.com i use a pop account, and if i send a mail for user
exchange i choose exchange account.
But i have a problem when i send a mail with email address and
exchange account, i choose a pop account for send mail, but a exchange
account does not receive this mails. And when i have choose a exchange
account for send this mail, the mails cannot send whis this account.
what solution ??
ygar...Need help getting files from Exchange Server.
We have a computer that had an account on Outlook
attached to a Microsoft exchange server.
Apparently for the moment, this computer and the
server are inextricably tied together. Outlook cannot
even be started without logging into the server
because information store or whatever is missing.
How do you get the information out of the exchange
server to wean the computer from it?
tom <Spamblocker@ameritech.net> wrote:
> We have a computer that had an account on Outlook
> attached to a Microsoft exchange server.
> Apparently for the moment, this computer and the
> se...Charts #3
If I want my chart to read from 50 to 100 instead of 0 to 100 How do I do
Be Nice to Everyone Everyday
Be Nice to Everyone Everyday
"jr" <firstname.lastname@example.org> wrote in message
> double click on the current chart axis values on the
> desired chart axis. You can set the scale in the popup
> >-----Original Message-----
> >If I want my chart to read from 50 to 100 instead of 0
> to 100 How do I do
> >...Sorting with Column has Formula
I never imagined that the formula in the column would affect the sorting
order in any way, but it does in my case.
Below is the formula in that I have in Col I, and I'd like to sort it in
Ascending order, but the result is that it sorts with all the empty rows on
top and the one with the result from the formula at the bottom. I assume it
consider the "I" in the "IF" function in the formula, but I'm not sure.
Can anyone tell me how to fix this please?
#1",IF(...Do You Need Visitors
Frustrated by the lack of traffic coming to your site?"
Let's talk face to face! The reality is, even if it's true that at this very hour there exist hundreds of millions of surfers on the Internet, it's just not true that it's easy to get them to visit YOUR web site!
If I would tell you that after months of research, I just got my hands on the most hidden secrets...
Pssttt, yes precisely those secrets that the wealthy web masters are using now to get their millions of hits every day.
And let me tell you, it works... It's incredible to see all the ...Please help, I know nothing
I am a very new at this and it is driving me crazy.
For example, I want to add all of column A + column B and I want the answer to go in C. I want this action to always happen automatically. How do I do this...in easy, non-math language??
I understand the basic concept of the formula, but it will only do it in C1, e.g
I also get the error #name? Where do I enter this "name" and what is it referring to
I would appreciate any and all help
your question is a little vague
do you want c1 to add a1 & b1 then c2 to add a2 & b2
If yes then in c1 type in
o...I need the fix for Knowledgebase ID: 810999
Where can I get this from?
In the last exciting episode, "Stephen Aldous"
>Where can I get this from?
Other from Microsoft Product Support Services as stated in the
article? No idea.
-- ROT13 for valid SMTP address --
Call Product Support Services as listed in the article. If all you're
looking for is the hotfix, then the call should be free.
"Stephen Aldous" <email@example.com> wrote in message...Help with ActiveX
I am just getting my feet wet using MFC and am having trouble with an
ActiveX control I created. Essentially, I need an ActiveX control that
is a container for local controls. What I have is a set of instruments
with slightly different communications needs. My plan is to have
separate controls for each instrument so that I can use a single exe for
all of them. The exe provides the user interface while the ActiveX
provides instrument feedback. There are no input fields on the ActiveX
but there are several text fields and a progress bar. I am managing the
text fields and progress bar in...Cannot enter an array formula
I'm trying to help a user on a toshiba laptop with array formulas.
For some reason he cannot create an array formula. The formula
evaluates on everyone else's laptop but his. He has Windows 98 and
Office XP Professional. Has anyone encountered this?
If he can't create it then you wouldn't know that it doesn't evaluate, so which
is it? What's the formula? and can he actually create it but it doesn't appear
to have the right answer. If you hit F9 does the right answer appear?
Ken....................... Microsoft MVP - Excel
...time formula question
This formula works great if the ending time is before 0:00.
$C$9:$C$11 is my starting time i.e. 20:00
$E$9:$E$11 is my ending time i.e. 04:30
How can I get this to work if A21 = 20:15?
"David" <dfizer@r...Microsoft CRM 3.0 and Microsoft VPC
Dear Forum Members:
I have installed Microsoft VPC 5.3.582.45, but I can't get Microsoft CRM 3.0
(VPC image) up and running
on my external hard drive. Does anyone know how to point Microsoft VPC to
the Microsoft CRM VPC image loaded
on my external hard drive?
I think the CRM3 VPC has expired
"Caseroo" <Caseroo@discussions.microsoft.com> wrote in message
> Dear Forum Members:
> I have installed Microsoft VPC 5.3.582.45, but I can't get Microsoft CRM
> (VPC i...Removal of Outlook 2000 from XP home Help
I am attempting to remove an unauthorized version of Office 2K from a Win XP home computer. The Removal went fairly normal except that now when accessing any E-Mail client, the Windows installer is attemtping to install something from the Win 2K premium disk. Is there a Registery entry causing this problem? Is there a way to stop this from happening?
do you know what it's installing and does it fix it if you give it the disk?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: ht...Help me create sales chart based on state and quantity
We have a production report on excel. It shows the details for our clients.
Part of that data includes the state in which the client lives. We are trying
to create a chart showing the percentages of each state( so we know where the
most deals are closed)
this sounds like a job for a pivot table, using Average as the data
Or, depending on your version of Excel, you can use AVERAGEIFS (in Excel
2007) or calculate an averate with a combination of SUMIF divided by
To be more specific, it would help to s...Help with formula #28
I have an excel spread sheet with formulas that work correctly, when I email
them to another person and they open the attachment all looks ok. When they
save the excel file to their PC and open it the formula cells now all have
#Name in them. Anyone know what is causing this???
The error message gives us a clue: Excel can't find something - things to
1. Make sure the receivers all are using the same add-ins as the sender
2. Make sure that personal.xls is the same for the receivers as the sender
3. Make sure all defined names are the same
"Play...need help Combo Box with duplicate entry.
I have a combo box with unique and non-unique entries. (search field)
00010 | john | smith | 12345 | 00002
00196 | jane | doe | 0120 | 00001
00196 | Jone| wood| 0220 | 00005
I would like the following to happen.
1) user types the number needed ( 10 )
2) the combo box zero fills the field (00010)
3) then selects an entry from the combo box. (12345)
if the select is incorrect ( one of the non-unique numbers was selected -
the user will open the combo box and select the correct entry. (jone wood)
add the info will be put on the form.
the following code works if the user ente...delayed email #3
I am running server 2k3 and exchange 2k3. When I send out an email message
to everyone in our email group I get a message that a few of the people did
not receive the message
This is an automatically generated Delivery Status Notification
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESENT YOUR MESSAGE
Delivery to the following recipients has been delayed.
And then it lists a few people that the email has been delayed to. Except
the message never gets to these people
Any help would be appreciated
A bit more information, if you please. Can you define "eve...Sort Need
A B C
1 206 S. Harbor Dr. 206 S. Harbor Dr.
=LEFT(A1,FIND(" ",A1)-1) =TRIM(MID(A1,FIND(" ",A1)+1,255))
First equ immediately above is in B1 =LEFT(A1,FIND(" ",A1)-1)
Second is in C1. =TRIM(MID(A1,FIND(" ",A1)+1,255))
A1 is address in column of addresses to be sorted.
Equ starting: =LEFT pulls out the street address number
Equ starting: =TRIM pulls balance.
Problem: In this example, Sort places C1 in rows
starting with l...How to get the handle of a Help file belonging to other process.
In my application,I want to change the Index of a HTMLHELP
file which belongs to a dialog running in other exe.In order to do this
I need to find whether the Help file is open or not & get the handle of
that to use HH_DISPLAY_INDEX .Is there any way to do this??
Note: I dont want to use FindWindow() as it is giving rise to some
problems in my application..
Thanks in advance
...Help with cells auto formatting
I have posted a similar question before however I never really got this
sorted so sorry for repeating myself.
Basically I use two spreadsheets daily at work all with various information
on and various formats in each Column. My problem is when I close the
spreadsheet and reopen it the cells that are formatted as 'general' or
'number' turn into Euro currencies.
Does anyone know why this happens or how I can stop it? The spreadsheets
aren't stored locally they are stored on a serve that only myself and my boss
can get onto and we both have the same p...Help on adding values to a bar chart
Here is my problem. I currently have a bar chart that has 8 X-axis
bars. I need to add 2 more to the X-axis. The labels for the x-axis
are based on cells within another spreadsheet, but are not consecutive
cells, they are spread apart. So when I go to add the two more cells,
I can only add one. When I click on the second cell to add it to the
list, all of the previous cells get unselected. I have even tried to
manually add these two values in. Is there a limit to how many values
can be on the X-axis? Please Help!!!
To select non-consecutive cells: select first cell, h...protect formatting #3
I have a shared workbook with many worksheets in it that many people need to
fill in. How can I protect the formatting of it so that they cannot change
it. Also when they copy and paste things into the worksheets I would like the
format to revert to how I have set it??
I have a spreadsheet with three tabs.
Tab 1 needs to perform summary calculations
Tab 2 & 3 are ODBC connections with source data from other files.
Tab 2 is a sql query that is a cross tab with columns 1-4 representing row
data and then the remaining columns are employee ids with a productivity
value in their column. Not all columns have the same value as they correspond
to a job/service performed on a specific date.
My problem Tab 1, column 2 contains "completion dates from 1/1-current and
refreshes based on tab 2 each time it opens. I need a lookup formula that
wi...Excel spradsheet automation help
there are 3 sheets in an excel spreadsheet say the names are 1,2 AND3
layouts ar ethere for all 3 sheets.
the first sheet is used as input and based on certain fields/columns in the
first sheet i need to populate entries in the second and 3 rd sheet.
teh main purpose is taht based on the first sheet the 2 and 3 sheet should
be automatically filled. wat kind of formula / macro should i be using ..
im new to this and jsut know to create macro. CAn anybody help
ON either Sheet 2 or Sheet 3, you can put this formula in any cell and it
will return whatever value is in cell A1 on sheet 1.