can't access public folders with OWA
I have Windows Server 2003 and Exchange Server 2003 Installed
everything works fine, except when trying to access Public folders via
Outlook Web Access, after going to the location its asks for username
and password - this works ok and the folder is displayed, but when
trying to add a folder or post a note or do anything I get:
You are not authorized to view this page
You might not have permission to view this directory or page using the
credentials you supplied.
I have tested on client machines, remote machine and the exchange
server as administrator with no luck.
does anyone have any...formula help 02-10-10
Would like to accomplish:
How do I add number 2 infront of the above ISSUE numbers as I have thousands
of line to do.
If your number is in column A then in column B type
=2 & A1
and copy it down.
Please rate when your question is answered to help us and others know what
> Would like to accomplish:
> 2...Secondary axis help
I am having some difficulty in Excel 2007 Charting. I have a stacked
bar chart that I would like to add a horizontal secondary axis on. How
do I do this? I'm trying to do what the Help says but there is
something that I am not getting.
1. I click on the Chart and select the Format Tab
2. In the Current Selection section, there is a Chart Elements drop
down and I select Horizontal (Category) axis.
3. I go to my sheet that has the data for the chart and I select the
data range that I want per the instructions.
I'm lost after this.
well, the Help s...Using MS Access information in Outlook
I have an MS Access DBase that contains our companies contact information. I
want to be able to use that information in an Outlook contact folder. I do
not want to import the information into Outlook. I want it to be
Is this possible?
...how do i calculate 10% of a total in an access query
I am working in access 2007 and have a goal amount that i need to calculate a
10% increase.. I cant figure out how to do this!!
Increased Price: ([YourField] * .1) + [YourField]
Build a little - Test a little
"confussed student" wrote:
> I am working in access 2007 and have a goal amount that i need to calculate a
> 10% increase.. I cant figure out how to do this!!
On Mon, 25 Feb 2008 09:13:10 -0800, confussed student wrote:
> I am working in access 2007 and have a goal amount that i need to calculate a
> 10% increase.. I cant figure out how to do...SQL General Help
I have been experimenting with using ADO to work with Excel data. I had some
obstacles with the SQL until I stumbled across a web site that mentioned the
table name needed a special format. Instead of using a table name like DATA,
instead I had to use the format of [DATA$].
So I was wondering does anybody know of a source (document, web site, etc.)
that explains all of the peculiarities of using SQL with Excel?
...BOB? More Craps Help
Been spending some time on the code you sent and I think I
found some errors. Can you check the code below to see
what you think? I think it is now working according to
the correct rules...
'Excel Craps V1.3
Application.ScreenUpdating = False
Application.ScreenUpdating = True
[B5] = [B2]
If (([B5] = 2) Or ([B5] = 3) Or ([B5] = 12)) Then GoTo
If (([B5] = 7) Or ([B5] = 11)) Then GoTo FirstLucky
cellvalue = 0
...How to organize access to PWA for external user?
I have Project Server installed in "standalone" configuration.
Is that possible to organize access to PWA for CUSTOMER (person who
role of Project manager in customer organization) with observance of
1.CUSTOMER should have ability to have access only to those files,
regards HIS organisation.
2.CUSTOMER should'not have rights to change any data in those files.
from your question I understand that you want to provide access to external
users may be they are customers , partners and remote users.
First tell your Network Administrator...In excel when inputting dates 10/4/04 (10/april/04) data converts.
In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
I think I'd try chaning my windows regional settings.
In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in d...Change background color of query results from access in worksheet
I have Excel 2007 and selected Date => From Access and then navigated to an
Access DB and selected a query. I chose "Table" view. The query results now
appear in my worksheet which is great. However, I want to change the
background. Right now it alternatives by row between a light blue and a
darker blue. I want the results to have a white background with black
borders but have been unable to change the format. If I go to Home and
select No fill for a color background nothing happens. Is there a way to
change the query results?
Could be the r...SUMIFS help
Hi. Hope you’re able to help. I’m having difficulties the SUMIFS function.
Either I’m using it incorrectly or perhaps it’s the wrong function for me!
I’m trying to total the money amounts in column E as long as conditions in
columns A (cell A6 in this example) and column H are True. However, I’m
finding that the function is not totalling up the money amounts it should be
totalling in column E. Instead, it’s just returning a single money amount in
column E and ignoring the rest! This is the function as I’ve written it:
=SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!...What is the basic format of a Access VBA module
I am almost completely new to Access VBA so pardon me if this question
is asked before.
Anyway, I came across somewhere that I have read before that before I
exit an Access VBA module, I am supposed to clear the database or do
something to free the database is it? May I know how it is done and
why should I be doing that?
<firstname.lastname@example.org> wrote in message
> I am almost completely new to Access VBA so pardon me if this question
> is asked before.
> Anyway, I came across somewhere...CRM & Data Matching
We are going to populate our MSCRM with various data sets. Because of this
there will be duplication of customer data. Is there any mechanism within
Microsoft CRM (or easily available elsewhere) to match the data from the
diverse sources against each other and to arrive at a single instance of the
Microsoft CRM V3 only offers merge capabilities which means you have to
locate the duplicates - crm can then merge the records two at a time. ISV's
have produced other solutions
Microsoft CRM MVP
http://codegallery.got...outlook mobile access broken #2
I noticed this morning that my OMA was give ASP application error
reports when a device tried to connect.
I put it down to changing the installed .net framework at the end of
last week - using the aspnet_regiis.exe command located in the C:
\WINDOWS\Microsoft.NET\Framework directory, I changed from v1.1.4322
So I reverted back to v1.1.4322 hoping it would resolve the issue, no
all I get is a 404 page not found - even though there are files there
- now I'm a bit stumped.
What is going to be the easiest way to fix/repair/recreate this
Any pointers would ...Calcs & Data Validation
Looking for an easy way to complet the following. I imagine their must be a
quick & easy method.
Cell A5 has a drop down list which corresponds to a range on another
worksheet. It has 300+ entries. In cell B5 i will enter a number/qty. What i
would like is that as each of the items in the list has a corresponding cost
(on other worksheet), i would like to know an easy way to calculate the cost
(in C5) based upon the qty entered (B5) & the cost of the item selected.
I have done it before with 'IF' function for a small selection, but figure
there must be an easier...Access 2007 Attachments
I have a form, with a subform.
The subform has an "attachment" field.
This subform is displayed in datasheet format on the main form.
I have code on the main form ,attached to a cmdButton, that sends an email.
I now wish to amend that code so that the attachment is attached to the
email - if there is one.
Dim App As Object
Dim Itm As Object
Set App = CreateObject("Outlook.Application")
' all str variables defined and represent values on the main form
' get the attachment name if there is one ????? (this is what ...Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of
hours ago under "Chart Type".
It is URGENT--for a presentation for which I am already late!!
Hi Sat - Take a look at what I just posted and see if it helps.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------...newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...Employee Training Help
I am creating an employee training database where I can run reports and
queries about who has taken what type of course.
What kind of relationship should be created between the tables? Based on the
some of the discussions I have seen here, I have created three tables:
1: tblemployee (with employee id set as primary key)
2: tbltraining (with trainingid set as primary key).This table has no
3: tlbcompletedtraining (in this table I have employee ids with the id's of
the training courses that they have completed)
I am unsure of what ki...Need Help with Formula #3
I need help trying to come up with a formula for a friend
of mine. This is what he wants -- Using any 9 numbers --
he wants Excel to come up with every possible 3-digit
combination of numbers that are divisible by 7.
Is there anyone who could assist me with a formula that
will perform this calculation? Can Excel do such a
Thanks so much for any assistance you can offer.
In A1, enter the number 7.
Edit>Fill>Series, Step value 7. Format>Cells>Custom, "000".
If with "using any 9 numbers" you mean you don't want any zero...Help with formula containing text
I need some help on the following.
I have a column of text, linked to other worksheets, that is
continuously changing. I need to be alert if the same piece of text
appears in the column more than twice, e.g.
mlhynes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=12959
View this thread: http://www.excelforum.com/showthread.php?threadid=401787
Visit Chip Pearson's site for much help on duplicates.
Fin...Formatting doesn't follow data sort
I was just recently updated to 2003 MS Office Pro. I can't remember
what I use to have, but I used to be able to Data Sort info and the
borders around cells would follow the appropriate text. It doesn't do
that anymore, and I can't find out how to fix it in the online help,
and my IT guy doesn't know off the top of his head. Can anyone help or
have I wasted a full day and a half putting borders around information
for no reason?
kanimalhouse's Profile: http://www.excelforum.com/me...Rota's and Daily Shift Pattern's
I've got a basic rota sheet with Mon-Sunday along the top and the names of
the staff down the side.
Each day a memember of staff is either AM, PM or OFF.
I'me trying to create a sheet that just has monday at the top with all th AM
people on it. Then a sheet with all the PM people on it.
Thanks in advance
is this just for printing out? if so i would use the autofilter (data /
filter / autofilter) - choose the drop down for MONDAY, choose AM print
results ... choose PM, print results ....
"Scott Cheesman" <Scott Che...Supporting Access 97
A prospective client has sent me a set of database files that he would
like me to support & upgrade occasionally. They are all Access 97
files. When opening them, all bar one gave me the option of converting
to Access 2003 format. Why did one file not give me that option?
Also, I can only make changes in these new versions of the files, but
they will presumably be useless to the customer unless he upgrades his
version of Access. Is that right?
After you change the database, you can convert it back to Access 97
format ... make sure you use the
I created a simple report that has a Report Header, Detail and Report Footer
section. My report should only be 1 page but it goes on continuously to no
end. Can anyone tell me what I'm doing wrong? The page is formatted on a 8.5
x 11 page landscaped. Any help is greatly appreciated. Thank you in advance.
In the report properties change from continuous to page report and set
ForceNewPage (right click on the body of the report) to after section.
> I created a simple report that has a Report Header, Detail and Report Footer
> section. My report should o...