Using custom fields for better email list view.
I get lots of letters with the same title. I want to group them by topic and
sort on the number of letters in the group. I know that I can do this using
custom fields but I do not know what query to use to get the number of
letters the group.
...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...From Field
Am encountering strange issue: anyone can send e-mail in
any other name, just he has to put in the "from" field
the name of any sender he wants and then the e-mail is
sent in that name.
Please let me know if there is any remedy. I have
Exchange 2003 enterprise edition.
E2k out of the box doesn't allow this, so it sounds like someone may have
mistakenly added users to a group they shouldn't belong to, or has granted
service-level permissions in Exchange to a group that shouldn't be in there.
First, find out what groups these users belong to.
See wh...how do i use an if is null, and if is not null statement together
I have to compare two columns of data, and show the status in column three.
Column1 = enrolleddate, Column 2= DisenrolledDate, Column 3 = Status
If column1 and column2 are null, "Active",
if column2 is not null, then disenrolleddate
Thanks for helping me.
If you were using a spreadsheet, you might need that third column.
In Access you can simply use a query to do the comparison and generate the
Microsoft Office/Access MVP
"latha" <email@example.com> wrote in message
news:A4366DA3-9E0E-48C8-BB30-452...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <firstname.lastname@example.org> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Title & Text Layout Format Issues
I believe this has been answered before but cannot locate. (probably Echo)
On a Title & Text Layout slide I manually reduced the font size so all text
would fit. I saved the file but when re-opening it reverted back to the
large size. The auto correct options are all turned off.
I think you've run into a bug, Fritz. The info at this link offers some
Text size or other formatting is lost when you save, close, and reopen a
Echo [MS PPT MVP] http://www.echosvoice.com
Wha...Button Text not showing :Too many items in Oppurtunity Menubar
It is indeed necessary for me to display the Text for all the buttons. But, there exist a lot many and CRM is hiding the text.
How can i tackle this?
How can MenuITem be useful (if at all.)?
Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 2
This code will hide "Create Invoice" button on "Order" entity form.
var mb = document.getEle...White Text On Black
I've looked through my printer's settings (Epson) and haven't found
anything helpful there. Is there a setting in Word 2004 that'll
reverse the colors? No sense in running through all that black ink.
I'm not sure exactly what you're asking, but my guess is that it's best
answered by simply saying that there is no such thing as "white" ink - at
least not at anything less than special spot color at the commercial
printing level. White on the typical home/office printer simply means the
absence of ink in those locations where it's called ...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...how to draw static text in a dialog
I creat a dilog and want to display some lines in the static text of
the dialog .
this is code:
CWnd *pWnd = (CWnd*)GetDlgItem(IDC_mystatictext);
CDC* pDC= CWnd::GetDC();
but it just display in the dialog and cannot display in the static
I just a newer one to study vc,thanks for yous help.
You dont have to draw anything. Simply call SetWindowText on it:
CWnd *pWnd = GetDlgItem(IDC_mystatictext);
> I creat a dilog and want t...Inserted images and pasted text is the wrong color in publisher.
When I insert a picture (jpg) from file or scan it in, it places it as a
green picture even though I scanned as a full color. Also copied black text,
when pasted into publisheris pasted in green? Am I missing a default setting.
Everything I try to insert or past is green.
Have you looked to see if there is an updated video driver lately?
MVP Microsoft [Publisher]
How to ask a question
"CaryK" <CaryK@discussions.microsoft.com> wrote in message
>...text wrap problem
I'm importing address info into Excel from our in-house database. Th
addresses comes as a block with line breaks which show up as a squar
in Excel (when text wrap is off). I need to change these marks int
commas. Is there any way to do this automatically?
I dont have VBA knowledge but suspect this is where the answer lies.
Apologies if this is an innane question to some but Im stumped.
Message posted from http://www.ExcelForum.com
From a previous post:
Chip Pearson has a very nice addin that can help identify those funny
The headings of some Outlook mail boxed got "mixed up" somehow. I no
lomger have the To, Subject, SendDate columns. I hear that you can use
Field Chooser to restore them, but I can't get it to work. Can anyone
offer some help?
...Text is Truncated With String Variable
If I do this:
Dim theTxt as String
theTxt = Activesheet.Cells(1,1).Text
for some reason the text (which is actually 1849 characters long) is
truncated to 1024 characters.
If I do this:
Dim theTxt as Variant
theTxt = Activesheet.Cells(1,1)
I get the complete text string from the cell.
Can someone tell me why these two approaches are giving me different results?
One uses the .text property, the other uses the default property (.value).
> If I do this:
> Dim theTxt as String
> theTxt = Activeshee...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...No Text Shadow option
Using Excel 2002, Win XP.
I have all the buttons on the Formatting toolbar showing, yet there is
no Text Shadow option.
Any suggestions will be appreciated.
Thanks in advance.
AFAIK there is not such feature for text only.
You can use the Drawing Toolbar to place shadows behind Graphics, WordArt,
Autoshapes and Text boxes.
Gord Dibben Excel MVP
On Tue, 23 Dec 2003 03:46:51 +0200, "Stan" <me@there> wrote:
>Using Excel 2002, Win XP.
>I have all the buttons on the Formatting toolbar showing, yet there is
>no Text Shadow option.
>Any suggestions will...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...refrence field on a table
I am trying to have a button on a form where I push it and it opens the form
matching a field in the original form.
I am starting in "entry" form I click the button "addrun" it then opens the
"run" form. on both forms I have a field [formationid] I am trying to have
those fields match when I open the "run" form.
I tried the following in the where condition of the open form macro.
On Sun, 3 Jun 2007 11:53:01 -0700, Fipp <Fipp@discussions.microsoft.com>
>I am gettin...only returning cells with Text in it
I have a column that returns some text, if something else is true. Now
what I want to do is take only the cells in that column and list them
on another sheet.
The trick is, that ill need to do this with a frmula, since it will be
a hosted template and the user wont be able to use excel functions like
so, if I have 10 cells and 3 of them have test in them, I want to show
only the text in those 3 cells in another sheet.
I hope that makes sense....
Thanks for your help....
Assuming that Sheet1!A1:A10 contains your data, enter the following
formula in Sheet2!A1 and copy do...Label Ranges
Labels seem to work in formulas provided only that the
option is turned on at Tools, Options. What is the purpose
then of the Label Ranges dialog? Obviously it is for
adding ranges thathave labels but what is achieved?
...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <email@example.com> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...Hiding rows with VBA
In my sheet called "insertsheet I have this VBA:
(thanks to some users of Google groups)
Private Sub Worksheet_Change(ByVal Target As Range)
Const nMAX As Long = 10
Dim nRows As Long
Application.ScreenUpdating = False
If Intersect(Target(1), .Cells) Is Nothing Then Exit
nRows = .Value
.Range(.Cells(1, 5), .Cells(1, _
.Columns.Count)).EntireColumn.Hidden = True
.Range(Cells(1, 5), .Cells(1, _