Log changes to full access permission
Exchange 2007 SP1.
Is there a log, or is it possible to log, whenever anyone is granted full
access to a mailbox or mailboxes?
What do you mean by "anyone"? Please make your request more specific.
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"Adrian" <NoSpam@Hotmail.com> wrote in message
> Exchange 2007 SP1.
> Is there a log, or is it possible to log, whenever anyone is granted full
> access to a ma...How to change the return of a textbox from TRUE/FALSE to YES/NO?
I have a long colum full of textboxes in excel. When the boc is checked it
returns true, and false for unchecked. I would like to change this so that
it returns Yes for checked and No for unchecked. How can I make this happen
You mean Checkboxes?
You can use a helper cell:
Then hide that linkedcell (if you want).
> I have a long colum full of textboxes in excel. When the boc is checked it
> returns true, and false for unchecked. I would like to change this so that
> it returns Yes for checked and No for un...pivot chart, mean and standard error
I'm using a pivot table to calculate the mean and the stdevp of values
collected in different condition.
My problem is to draw the corresponding chart for the means of the
values, and using the stdevp values for the error bars.
Using a stacked histogram, I have something which resembles to what I
would like but I would prefer to have a classical error bar. Is there a
way to manage ? I want to keep something automatic and not static, with
a copy/paste values to draw manually my charts.
Thanks for your help
Misange migrateuse http://www.excelabo.net
mail : http://cerbermail.c...How to change The height of the Split Window in a frame?
I make a 2-rows , 1 col CSplitterWnd i n a frame,
Now i want to hide one of them,
Or change the height of the window to 0,
How to do,?
Check SetRowInfo() and RecalcLayout()
"Jerry" <firstname.lastname@example.org> a �crit dans le message de news:
> Every one,
> I make a 2-rows , 1 col CSplitterWnd i n a frame,
> Now i want to hide one of them,
> Or change the height of the window to 0,
> How to do,?
...Excel asking for save with no changes #5
Dave Peterson Wrote:
> And xl2002 added an option that allows you to have more control:
> Edit|links|startup prompt button.
> check the "don't display the alert and update links"
This sounds like exactly what I'm looking for! Unfortunately, I'
running an older version of Excel. I'll have to hit up my IT perso
for an update. Thanks!
tommy20's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281
View this thread: http://www.excelforum.com/sh...Stacked Line Chart
I have a chart that is predominately a stacked bar chart however I want to
have 3 sections as a stacked line chart as the represent hours for the whole
group. I can sucessfully set it for 2 stacked lines but when I add the 3rd
line if it has either a blank or 0 in the cell it picks up the line from the
previous stacked line. Is it possible to have 3 stacked lines?
Sure it's possible, but I don't know what you mean, "it picks up the line
from the previous stacked line". Stacked means each line's value is added to
the previous total, so if the value of the third it...How Change default "look in" location in EXCEL for Importing Exte.
I am importing data contained in a text file. When I get to Import Data, the
"Look In" folder location always defaults to "My Data Sources". How do I
change that to the folder where my data is? (files are on my computer).
...New Chart in Excel 2007 is NOT showed unless preview
I have a sheet with multiple charts in Excel 2007
one of the new created charts is hidden when I open the file
Unless preview is selected, then finally turned on BUT many formats are
changed and objects on charts (titles,...) can not be moved !
what's wrong ?
Make sure you have installed SP2 for Office 2007 as this fixes some (not
all) chart problems
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Rolando" <Rolando@discussions.microsoft.com> wrote in message
news:0B0A3E5C-AABD-4982-962B-8C5C09A2CC5A@microsoft...How do I create an area and line combination chart?
I want tocreate a combination chart, using the chart types area and line, it
is not listed as a custom type in Excel - is it possible?
Ignore the built-in combinations and create your own.
Start with creating a Line chart with your data. Then select the line
series that you want as an area chart. Right click and pick Chart Type
to select the required Area chart type.
> I want tocreate a combination chart, using the chart types area and line, it
> is not listed as a custom type in Excel - is it possible?
Andy Pope, Microsoft MVP - Excel
http://ww...Track Changes Query
Hi I wonder if someone could help me please with a problem that's been
baffling for a few weeks now.
I am trying to create a query, which in turn feeds a report, that shows
tracked changes. I have previously posted on this forum and got some great
advice that's really helped me along but I'm really struggling with the query
to extract the data. I am relatively new to Access in particular VBA but I am
willing to learn.
What I would like to do is to use a date parameter to extract those fields
with an updated time stamp within a given time period, which in turn I can
sho...How can I change background color of DateTimePicker?
I know that subj is possible because of Borland C++ Builder allow to change
background color of DateTimePicker just assigning a color to Color property
of TDateTimePicker component. When I try to make this subj using MFC I've
got nothing. Can anybody help me?
My code :
m_date.Create(WS_CHILD | WS_VISIBLE | DTS_SHORTDATEFORMAT,
CRect(36, 0, 116, topHeight), this, 1006);
With best regards, Sergiy Yakovyn.
"Sergiy ...Change size of name box
This is a multi-part message in MIME format.
Is it possible to change the size of the name box ? And how do you do it =
Some of my range's names are to long to fit in the actual name box.
Thanks in Advance, and may all of you have a healthy 2004
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HT...changed time and date and messed up appointments
Hi I recently went to UK from Australia, then to italy, I must have
changed the time zones, and now my appointments are all over the place,
Is there a way of getting them back to original times and dates.
for the future is there a better way of handling time zones.
i also use a pocket pc where i probably changed zones as well.
See the following MSKB article for a workaround:
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the mes...Stock High-Low-Close Chart
Is it possible to produce a Hi-Lo-Close chart with reversed axes - ie with
the Hi-Lo bars horizontal rather than vertical? The normal HLC chart has
stocks listed along the x axis and price up the y axis. How would I switch
I want to display a series of stocks listed down the y axis and the hilo
price range given across the x-axis.
Thanks for any advice on this.
Assuming your data is first set up like this and cover the range A1:D8:
High Close Low
Conoco 41 39.5 38
Exxon 42 40.5 39
Shell 41 39.5 38
Baker 40 38.5 37
Halliburton 39 37.5 36
Marathon 40 38.5 37
Diamond 40...Change to foreign currency in POS 1.0 SP 1a
I am new to MS Dynamics POS and would appreciate assistance in changing the
default currency from US$ to Nigeria currency. Simply, I would like the $
symbol change to N.
Thanking you for your assistance.
Thank you folks. I found the answer in Junaid Idrees'response to Tim Simth's
post on 7/24/06.
> I am new to MS Dynamics POS and would appreciate assistance in changing the
> default currency from US$ to Nigeria currency. Simply, I would like the $
> symbol change to N.
> Thanking you for your assistance.
...Year + week => first date of week
I would like Excel to calculate the date for the first day (Monday) in
a week.I have my sheet setup like this:
Cell = A1 = Year = 2009
Cell = A2 = Week = 32
Cell = A3 =DATE(A3,1,1)+7*B3 this gives me the Excel date = 40038
(2009-08-13 Thursday) this is not correct.
Correct Excel date for 2009 week 32 should be 40028 (2008-08-03
I live in Sweden and we use the ISO week that starts on Mondays (first
week of the new year is the first week that contains Thursday). I
don't know if it has got something to do with that the formula above
does not work.
Above formula is the one I ...Opportunities & Opportunity Products 12-02-05
Is there a way in CRM to copy an Opportunity from one Account to another?
If not, is there a third-party add-on that provides this ability?
Is there a way in CRM to select and add multiple products to an Opportunity
instead of selecting them from the price list one at a time? If not, is
there a third-party add-on that provides this ability?
While these features do not exist there are many ISV's on this group who
could write them for you at a price..
Its all down to how much these features are worth to you
Microsoft CRM...Payee change
Not sure how it happened but my version of Money changed the name of my
mortgage payee to another. This affected all my loan payments dating back 5+
years. This entry is generated by a auto bill viewable in bill summary. I
fixed the future transaction by editing the bill but all the prior payments
are wrong. Is there any way to change this as a batch instead of each
transaction? This is very time consuming.
Thanks... & Happy New year
In microsoft.public.money, SCOTT wrote:
>Not sure how it happened but my version of Money changed the name of my
>mortgage payee to...Stop Chart Style (Format) Update
I'm using Excel 2000 and I have a pivot table that aggregates data based on REGION, COUNTRY, ZONE etc etc. Once I have set up the chart they way that I would like it to look, if I then make a change to the selection using the pivot chart buttons, e.g. I select a country and the chart re-formats itself back to what appears to be the default style. I've set my chart style to the default but it still doesn't keep my chart style. What I want is that the chart style remains the same but the new values are just plotted onto the chart.
I'm sure there is an option to turn ...changing character set of a dialog control
Does somebody know how can I dynamically change a
character set that a control in my dialog uses?
>Does somebody know how can I dynamically change a
>character set that a control in my dialog uses?
I suspect you're looking for SetFont (WM_SETFONT)
MVP VC++ FAQ: http://www.mvps.org/vcfaq
I tried the following:
33, // nHeight
0, // nWidth
0, // nEscapement
FW_NORMAL, // nWeight...Remove Spaces beginning Time entry
I am using "=TIME(HOUR(B11),MROUND(MINUTE(B11),I11),0)" for
a time card, but if a space is entered we get #VALUE error. How can
these spaces be filtered out. Input "06:00" or "06:00 am" works, but "
06:00" gives #VALUE error.
Have a look at TimeValue in help.
"Jack Bible" <email@example.com> wrote in message
> I am using "=TIME(HOUR(B11),MROUND(MINUTE(B11),I11),0)" for
> a time card, but if a space is entered we get #VALUE error. How can
> these spaces be filt...Change Y axes (Categories) on line chart
I have a line chart. I am happy with my X axis categories, which say
something like "Term 1", "Term 2", "Term 3" etc
However my Y axis reflects the actual values (eg Points scored) that I wish
to chart, whereas I want it to contain descriptive terms such as "Grade C",
"Grade B" etc
I have read Jon Peltier on how to change axis by creating a dummy series in
a scatter graph. Problem is that if I change to a scatter chart, I lose my
X axis.values that I am happy with.
I suppose that I could then fix this by using Jon's solution twice: o...How do print a chart with smooth lines?
I am trying to paste a pie chart in PowerPoint and print a pie chart with
smooth edges. Does anyone know how this is done?
I've got the same question. Is there any way to smooth the lines?
> I am trying to paste a pie chart in PowerPoint and print a pie chart with
> smooth edges. Does anyone know how this is done?
The only workaround I could come up with was to draw an elipse over the pie
chart. I set the color in the middle of the elipe to no fill and made the
line thickness "2" to cover the jagged pie circle....Sparkline Charts
How can i create sparkline charts in excel 2003
To do it easily, you'll need to dowload one of the many add-ins available.
With a bit of fiddlinh, you can generate some chart types which can be made
small enough to fit in a single, slightly enlarged cell.
Another way is to use a panel chart.
> How can i create sparkline charts in excel 2003
You can use the free Excel add-in I created. Download and examples files are
available at http://sparklines-excel.blogspot.com/.
Sparklines for excel is an open source project hosted by S...SALESRCT journal entries posting to wrong period
This has been happening quite often since upgrading to version 10. After we
close a month and re-open a new one, we have found many incidences of
SALESRCT journal entries that have posted to the previous month AFTER it was
closed, thus causing many accounting headaches.
If I take one as an example, the source doc shows GL, with reference
SALESRCT083898. It was an inventory and a COGS adjustment, which means it
originated from sales, but the user that posted, is showing the AP clerk.
I assume this is due to an invoice posting with a cost variance for an item
that was already...