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,...duplication of forwarded email
let me see which paint and brush I should use : - )
Sorry to reply after so long was on leave but my problem still persists and
so i will keep digging.
There is no forwarding set on his private mail (that would be via MS
Outlook). All forwarding has been set via the ADUC mmc on Exchange.
Just to recap the observed phenomenon:
1. My boss travels a lot and because we dont have OWA for users external to
our network, he uses a public email service (let not worry about whether its
yahoo blackerry gmail hotmail etc as they all behave the same and it means
the issue at hand is not related t...File List Folder Outlook 2003
I found an article which describes how to setup a folder to view any file
system folder in Outlook 2002. I can't find any equivalent in Outlook 2003.
Basically I just want to have an Outlook 2003 folder named something like
"my files" and have its address pointing to a mapped drive. I have tried
setting up a "home page" location on a folder, but it only works for web
addresses, not file systems. Thanks in advance.
At the bottom of the Navigation pane, you should have buttons for Folder
List, Shortcuts, etc. Select the Folder List button.
Op...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...Error during remote deleting records
during deletions of huge amount of records from tables located on remote DB
server following error message is appear:
T0: TCP Provider: The semaphore timeout period has expired.
The DELETE command is executed directly on the SQL server, remotely is
called just stored procedure which is perform the deletion. The DELETE is
made in a batches of 10000 records.
Could you please help me with the problem?
Thank you very much for any response.
You mean that you run the procedure on remote machine to delete the rows ?
"Lukino&quo...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...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...Look up boxes
I have created a look up table and the fields are SuburbID (primary key)
Suburb, State, District, Map Ref.
Then I have created a form that allows me to put in addresses of companies
and my question is - how can I, on this form, select the suburb from a drop
down box and it automatically comes up with the state, district and map ref
in three separate boxes so I don't have to enter this information.
On Tue, 5 Jan 2010 17:07:01 -0800, Chris wrote:
> I have created a look up table and the fields are SuburbID (primary key)
> Suburb, State, District, Map Ref.
...duplicate a field in sub folders
When I add sub folders to the SENT folder they 'by
default' show the FROM field instead to TO, Is there a
way I can tell outlook to use the TO field in all
subfolders of SENT.
Can't think of an easy way to tell it to automatically show field in all
subfolders, but it is easy to set them one by one. In each folder, show the
Advanced tool bar, then select the field choser and drag the fields you want to
where you want them. Any fields you don't want, just drag away.
On Thu, 15 Apr 2004 09:16:58 -0700, "Jan Dykstra"
<email@example.com...multiple duplication of records
Could anyone assist me with the following:-
I have been using the quick reference search tool that can be found at
Using only one table with no problems however I am now trying to use it in a
Two tables linked back to the main table via one too many links.
What is now happening is that multiple duplication of records are being
If you have one table with two records the listbo...For the record: broken Money report
M+ Deluxe Advanced Reports.
Account Balance with Details report, set to show Bank Information. Header
says Bank Name. In other tested cases, the Financial Institution attribute
reports out in this column. In the case of Loan Accounts, the Financial
Institution is not shown but the Comments attribute is.
Not that it's a big deal and not that they are going to fix it, but...
...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 ...duplicate mail sent
An exchange server 5.5 alway sends duplicate mails at the recent weeks, and
I found that there have a lot of mails store inside the outbound conversion
queue, I had check the event viewer and it shown the event id 3038, 4093 and
4128 to me,
An attempt to remove processed messages from the outbound store queue has
failed. The removal will be retried later. If the messages are not removed
before the service is shut down, the mail will be resent at service startup
causing duplicate mail.
The error code 2 was returned when trying to remove the spool file
d:\exchsrvr\imcdata\in\SNJ...Making a compiled list in Excel
I'm trying to create an Excel spreadsheet that can create a compile
list from an existing list. By this I mean there is a list of item
which represents the complete list and each entry has a checkbox nex
to it to indicate whether it has been selected or not, and then on th
same worksheet there is another list which only contains the items tha
have been selected from the first, full list.
Check out these screensheets to get a better idea of what I mean:
I think this should b...REPOST: Contacts/Global Address List/Automated Dialling
We can currently initiate telephone calls from within our contacts folders,
plus some public (contact) folders, by right-clicking and selecting Call
This feature could use our mobile phones (via Bluetooth) but more usually it
uses our BCM office phone system. This all works fine.
However, under this system we are maintaining a lot of duplicate data: 1 x
Active Directory, 1 x Exchange 5.5 directory, and several public contact
We are moving to Exchange 2003 soon which will mean that Exchange will
directly tap into AD, rather than maintain it's own directory. We would als...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...Need to display an error message when a duplicate object is clicked.
Hi all, I'm new to Access and I'm creating a simple IT Inventory
database. My first form just has details on the device, and I want to
be able to have the users select an IP address from a dropdown list.
I have the list and the dropdown working flawlessly, but in my table I
selected No Duplicates, so that no one IP address can be used twice.
What I'd like to do, is that if the DB detects a duplicate, to pop up
a dialog box stating that the IP address is already in use and to
please select a valid IP address. By default, there is an error that
pops up when you try to save the rec...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. ...When the code is chines/ japan or some other I get square boxes
When I run this code below I get square boxes for some code point what does
this mean. ?
I get square boxes for chinese/japanese and some other.
I would say that when the code page exist why is not windows able to display
the character for this code point.
Is it because of the driver to the screen does not support these characters.
I'm just curious ?
byte b = new Byte;
for (int i = 0; i < b.Length; i++)
b[i] = (byte)i;
EncodingInfo ei = Encoding.GetEncodings();
foreach(EncodingInfo e in ei)
...Record time by formula
i want to create excel sheet wherein time has to be recorded multiple time.
Now() formula does not help and i don't want to use macro.
"karim" <firstname.lastname@example.org> wrote in message
> i want to create excel sheet wherein time has to be recorded multiple
> Now() formula does not help and i don't want to use macro.
> Pls Suggest
i want to record start time and e...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...control box list
Hi I have a long list of hospitals, and would like to put a control in
that will fill in as you type to search.
I have tried list box, but can not see how to enter the list into the find
...different color for duplicates!!! how?
i have table full of numbers,
what i need is to find duplicates and mark them with different colors.
so like one numbers with red color, others with green, other yellow and so on.
so each set of duplicates will have own color.
i think it will be easier to see if we have this number so i will then
delete it from all rows.
i just used this formula, but donno how to make scenario above
The following loops through a colour list to highlight cells with duplicates.