How to stop RichEdit color change overriding default color
I've got a handly little syntax editor going along (that--so far-- is
waaay faster than the examples on codeguru.com (if you'd like to know
how to speed them up, I spotted a logic flaw in two of them. If
you're interested, just email me). I have a question on a different
syntax editor I'm writing for an in-house language though, so you'll
notice some unique features that enable me to take shortcuts.
But I've got a funny little problem. If the user is typing at the end
of the rich edit control, and they type in a keyword and it gets
colored, any text typed after tha...Legend Changes After Save
I am working in Excel 2007. When I delete certain Series from the legend,
save and close the file, the next time I open it the deleted series are back.
How can I stop it from defaulting back? Thanks!
I can't duplicate this problem, why don't you send me a copy of the file
before you delete the item from the legend and tell me exactly what you do,
so I can duplicate it.
Microsoft Excel MVP
> I am working in Excel 2007. When I delete certain Series from the legend,
> save and...Problem changing parent Business unit
WE have re-arranged some business units into a more appropriate hierarchy,
however, we have noticed that a user in a role with deep privileges (own
business unit and children I think) to read users can only see users in his
own business unit and only one of the child business units (there are 2
child business units).
We cannot enable him to see all the users in both child business units.
We tried reassigning the parent business unit to the one child that is not
appearing, but it doesn't seem to make any difference. WE also tried
adjusting the privileges up and down (i.e. Global and local...Printing changes layout
I am printing a booklet on Pub 2002 - when I print one page, it prints a page
where everything has changed - resized, cut off the edges, etc. The worst
part - when done printing, it goes back to normal view and it actually
changes my layout to match what is printed - permanently.
Any ideas what is going on? I printed on both my Lexmark and HP printers,
does the same thing. I have Windows XP.
Look at your page layout, has it changed? I know this will happen to me
occasionally when I change printers. If I change back to the original printer
the publication will revert...Auto-numbering of Opportunities
I have one question: considering that Opportunities are not meant to be
auto-numbered by design, what is the best practice to implement
auto-numbering on such entities?
Thank you in advance,
Try this blog:
"Hrvoje Vrbanc" wrote:
> Hello all,
> I have one question: considering that Opportunities are not meant to be
> auto-numbered by design, what is the best practice to implement
> auto-numbering on such entities?
> Tha...Number of wsheets in an excel workbook???
hey guys, how many wsheets does one excel workbook have? I need to have
about 66 - is that possible?
mariasa's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31726
View this thread: http://www.excelforum.com/showthread.php?threadid=521656
I have created a workbook with more sheets in it that that. obviously
depending on the amount of data on each sheet your workbook could be
getting quite large and possibly unmanageable! I guess you will have to
try it! D...changes to message size limits
On Exchange 2003, one huge annoying feature is that even when I make
configuration changes, it seems to take so long for them to actually go into
effect. This time it's the message size limits. I tried changing them for an
individual user in AD, even told the RUS to resync. An hour later that still
hadn't taken effect, so we moved on and changed the global default in
Exchange's Message Delivery properties. Another hour later and still no dice.
We had a company-wide default of 15 MB (huge, I thought). I increased my
account to 30 MB in AD, and then on the Message Delivery pro...How do I convert time format to text?
I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3
Try the VALUE() fx and format that cell with your choice of Time Formats.
> I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
> cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
> that is formatted as general text. ...Custom Formatting a Chart Data Label
I want to create a chart which will display a zero value on the data label
where there is in fact a zero value, and show N/A on the data label where it
didn't apply. The formula I am using in the spreadsheet uses a nested formula
to make this determination:
Presently, it works but displays the #N/A on the chart where I would prefer
it simply displayed as N/A. Can I do this with a custom format on the data
Thanks so much! I don't know how you all do it but your amazing!
If you can read this, thank a Teacher...
If your read...Font size change
Is there a way to increase the size of the font. I have a large, hi-res
screen and MS-Money insists on using something the size of a 6-7 point font.
In microsoft.public.money, Linda wrote:
>Is there a way to increase the size of the font. I have a large, hi-res
>screen and MS-Money insists on using something the size of a 6-7 point font.
Try changing the font setting in IE to a larger size.
If you want to see the size of the font in money. You must change the
computer's font size.
within money there is no option to do so.
you would have to go to...pivot table changes when data is refreshed.
I have a pivot table with grouping based on a field called "period
which is of date type. I have grouped it into months and quarters
However when i refresh the pivot table whenever the data (which is in
seperate sheet) is changed, the groupings are going out. I want t
preserve the groupings as they are like a template. How do i stop th
changing the format and layout of the pivot table whenever i refres
the data? any ideas? please help.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages d...how to write a number with 0
how to write number starting with 0
for eg. i want to write number 021495566
i had tried but it gives 21495566
pls do the needfu
NITESH G's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1759
View this thread: http://www.excelforum.com/showthread.php?threadid=48272
Try using the custom format: 000000000
"NITESH G" <NITESH.G.email@example.com> wrote in
message news:NITESH.G.1y475y_1131346800.45...Formatting detail section w/two lines
HELP, I'm trying to create the below in a report, but when I align the
"title" field below the "name" field and the "background" field is more than
one line, the "title" is no longer directly underneath the name. Is there
anyway to accomplish this?
Thanks for your expertise!
A couple of things to try.
1- Size Backgroundbigger than two lines and set Can Shrik to No.
2- Combine Name and Title into a single text box and set Can Grow to Yes.
=[Name] & Chr(13) & C...Change default view of Activies to Service Activities.
When clicking on any "Activities" tab, CRM shows list of activities of the
object, and it's the view: "Open Activity Associated View".
Can we customize so that the view "Open Service Activity Associated" will be
shown instead? Only show the Service Activities.
Here is something for your interest. Thanks to Michael.
PLEASE do click on Yes or No button if this post is helpful or not for our
uMar Khan :: CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.word...Default Folder for PST files?
I have a slightly different question relating to the above:
I already have my current & archive pst files stored in my own personal
When I want to open my archive folder I right-click Outlook Today & select
'Open Outlook Data File'.
Everytime, Outlook defaults to its own path (Documents &
Settings\User\Local Settings\Application Data\Microsoft\Outlook\)
This is really annoying & I would like it to default to opening a customised
path, such as C:\Mail\
if you want to displace your pst file, please ...Charts not recognizing source data if original linked data is changed.
I am very frustrated by Excel (2003) at the moment. I'm relatively new
to using Excel in depth. I have always been able to work my way through
most intricacies and pitfalls. But now I have been working in a workbook
with linked sheets (and with linked workbooks too) and have two problems
that I cannot solve.
Right now, I have about 47 sheets that are set up as follows:
detail data: this is the raw data the the user enters
daily totals: this is calculated data from the detail sheets
summary sheets: further sums from the daily totals and a chart object
that charts these sums (a line or sc...center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when
conditional formatting is applied. This did not happen in previous versions
I tried using format painter to apply conditional formats from a control
created in an earlier version, but this failed. The control created in the
earlier version then lost it's centering after saving in Access 2007.
Interesting. I tried to replicate this behaviour but failed, it all worked
as it should.
Try revisiting your form after applying the conditional formatting and
resetting the text box to center text.
...Do a calculation in cells with text data format
I have a few columns of cells having a mixed data format of number and text.
Is it possible to convert the first row of numbers in text data format for
further calculation? Your guidance to accomplish it is appreciated.
"Ray" <NoSpam-ZQLi@GMail.com> wrote in message
> I have a few columns of cells having a mixed data format of number and
> Is it possible to convert the first row of numbers in text data format for
> further calculation? Your guidance to accomplis...Changing Report Fields
What happens to the reports if we change screen fields. Does anyoneknow what
happens in the event of:
- adding a field – presumably doesn’t appear on any report
- changing a field – label or properties
- removing a field?
Any help please?
- Adding a field would change nothing to a report. You will have to alter
the report itself to make it visible there.
- Labels are set inside the report itself, so this won't change if you
change them on the form.
- Removing the field will not change the report, but it will be empty becaus
the user cannot enter data for that field (unless som...Changing of Cell protections after saving Excel File (2002)
This problem occurs when I protect a document using a
macro 4.0 function: =PROTECT.DOCUMENT(TRUE,,,TRUE,TRUE).
When I use the function within a macro4.0 macro, on an
original file, everything works fine. The sheet has
unlocked cells, and when the sheet is protected, it
allows me to access those cells. But if I save the file,
or save.as another name, then the fun begins.
The enable selection of the sheet( view codes) has gone
from 0-xlNoRestrictions to -4142- xlNoSelection. This
locks me out of doing anything in the sheet. When I
unprotect and then re-protect the sheet using the
T...how do I change cell references automatically in formulas
In Excel 2000, I have data in 80 rows and 10 columns. Each week I add a new
row. I have a separate chart for each column with the data range from the
first row to the last.. Each week I have to change the data range to reflect
the new last row for each chart. Is there someway I can do this
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"jnw3" <firstname.lastname@example.org> wrote in message
news:8A3551F9-FBC6-4841-95B4-618AB1893190@micros...Want to see only specific number of records on a form
Hi I have a form with default view as "Continuous Forms". When I openthis form I only want to see the records equal to Recordcount i.e. ifI have 3 records I should only see three records. I dont want to seean extra one record which is blank. The easy way is simply to set the allow additions to "no".(you will still be able to add records via a code, or perhaps a "add" button you provide.Or, perhaps you don't even need add record ability...Anyway...give the above a try..it will remove that extra "new record" entry....-- Albert D. Kallal (Access MVP)...Change the anchor property of a control.
How can I capture the event, when changing the anchor property of the
myPanel.anchor = AnchorStyles.Left & AnchorStyles.Bottom
How can I know, when the Anchor property is changed (which event?) ?
Am 12.06.2010 23:46, schrieb Mr. X.:
> How can I capture the event, when changing the anchor property of the
> control ?
> I.e :
> myPanel.anchor = AnchorStyles.Left & AnchorStyles.Bottom
> How can I know, when the Anchor property is changed (which event?) ?
Like I said, about once o...Cannot remember my e-mail logon password, how do I change it?
I use outlook 2007 and have a need to access my e-mail logon password. I've
got the remember password box checked but can not remember the password
myself. Is there anyway to retrieve this or change or recreate it?
You wuld have to contact your ISP to reset or provide you with the password
"Rviviani" <Rviviani@discussions.microsoft.com> wrote in message
>I use outlook 2007 and have a need to access my e-mail logon password.
> got the remember password box checked but can not remem...Date formats, culture and globalization
We are creating a 3-tier ASP.NET Web Application that needs just to
understand dates as UK shortdate format (dd/MM/yyyy). It will only be
used in the UK on intranet. I often come across web server and client
machine that are incorrectly set up so I want to protect the app from
these incorrectly set up hosts.
I understand the safe date formats for passing through to the
database. SQLParameters pass through a non-ambiguous format and also
that 'yyyyMMdd' is also a safe format. So ignore the database side of
things - I get that.
At the moment all the bou...