analytical accounting lookups should only show valid codes
When entering AA transaction distributions, the code lookup window should
only show valid code combinations. It's not intuitive for the user to have
to select a code and get an error message to discover which codes are valid.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the mess...Outlook shows offline during dial up
Having a problem with outlook 2002. Over the WAN
everything works fine. Dial up and connect to the
network (VPN) internet work fine. Outlook will sync up
however, a red x shows up in the bottom right hand
corner. Outlook shows offline, I can send and receive
but must hit send and receive. I have reloaded the
computer from scratch and still have the same problem.
Could it be a Excange setting? Any Ideas?
Thanks for the help,
If you hit File | Connect to Exchange Server what happens?
Ben M. Schorr, OneNote-MVP
**I apologize ...Show Window
I am currently developing a MFC SDI application. I want to integrate a
tray icon with it. When the application is minimized it hides by
ShowWindow(SW_HIDE) and then when double clicked on tray icon shown by
But the problem is if some other application is activated after my
application is minimized, ShowWindow shows it but it's behind some
screen. I have tried with SetFocus didn't work.
Please help me to solve this problem.
In addition to Ajay's idea you can also use SetFor...Information Stores show dismounted yet mail is still flowing...
Windows AD Mixed moded. Exchange 2003 installed on to a 2 node Microsoft
cluster. 1 Front End server...connecting to the primary cluster node.
Windows 2003 Standard on, FE Windows 2003 Enterprise Server on BEs
(<---cluster) no service packs on either. Exchange has SP1 installed on both
nodes and the FE. There are still Exchange 5.5 servers in the environment
although they are not being used.
.....the information stores and public folders all show that they are
dismounted...yet email is still flowing into and out of the server without
any issues. I just...Show a blank result in a cell when there is no value in the "Lookup" cell
I apologize if this question has been asked, but I have been unable to find
an answer searching the topics.
I'm using the following formula in cell C3:
When I type in an employee ID in A3, his/her last name shows in C3.
However, when there is no value in A3, C3 shows error "#N/A".
Is there a way to show a blank cell in C3 until a value is entered into A3?
Thanks in advance!
On Aug 5, 10:45 am, "Michael Slater" <mslater...@comcast.net> wrote:
> I'm using the following formula in cell C3:
> =INDEX(LastNam...reminder still shows up
when I run Outlook.exe /cleanreminders it simply opens Outlook, I am running
"Toppro" <Toppro@discussions.microsoft.com> wrote in message
> when I run Outlook.exe /cleanreminders it simply opens Outlook, I am
Outlook version? The Windows version isn't as important and that of Outlook.
Brian Tillman [MVP-Outlook]
...Delete Row ABOVE
How would I delete rows if
Then I would like for it to delete Row 2 and Row 1?
In column C, use the foll. formula in cell C1
=if(or(B2="Void",B1="Void"),"delete",1). Copy this all the way down. Now
select the column and press Ctrl+G > Special > Formulas > Text. This will
select all the cells which have delete. Now you may delete these rows
Microsoft Excel MVP
"Donna" <email@example.com> wrote in message
news:EBE2120C-722E-4648-8DE9-...Using ajax call to fetch multiple results from multiple queries and showing them 1 by 1 as the results comes.
I've 20 labels in a 2x10 table on a page. for each label, data comes by
individual queries. (total 20 queries for the page.) and it takes about
30-40 seconds for the page to load, and it's not comfortable for the user to
see blank page. I want that each cell will show loading.gif images. As and
when data comes from query, the images should go visible=false, and the
label should display the values one by one. How do I do this task using
Some ASP.NET code example will be helpful for me, as I'm a kind of beginner.
...Results show as a minus. WHY?
I have an application that was developed by another developer using VB.net
which reside in a SQL table. I need to use some of the data from this table,
however the data shows as -0.5 or - 0.99 or -1.70 etc in my Access tables.
How can I get those numbers to show as a percentage with only one decimal
point to the left? Example: 3.6% or 31.4 %. Any help would be greatly
appreciated. No matter what I do it shows that dang "-" at the beginning.
You can use the Abs function to strip off the negative
And you can format that as percentage either using th...show comments when cell is highlighted Vs when cursor runs over? #2
How do you make the comments appear when the cell is highlighted opposed to
when the mouse cursor runs over the cell?
You can press Shift/F2, or Insert/Edit Comment. If you wanted to see it
"automatically", when you select the cell, you'd need a macro, but I don't
think this is what you're asking.
> How do you make the comments appear when the cell is highlighted opposed to
> when the mouse cursor runs over the cell?
To at least Excel 2000, if you have the Tools, Options, Comment Indicator Only
you will see the co...EXCEL ROW DELETIONS
I have a workbook with 10,000 rows of zipcodes, every
other row is blank. I need to delete these blank rows. Is
there a way it can be done all at once instead of
selecting each one?
You could sort and delete all at once.
"Laine" <firstname.lastname@example.org> wrote in message
> I have a workbook with 10,000 rows of zipcodes, every
> other row is blank. I need to delete these blank rows. Is
> there a way it can be done all at once instead of
> selecting each one?
"Laine" <elipari@da...how to show numbers that begin with 0 in excel
I need to type numbers into an excel spreadsheet some of them begin with a
zero some do not. How can I have excel show the 0 in the numbers that begin
with 0. If I type 0236547 the number shows as 236547. I don't want all the
numbers I type to begin with zero.
I am using Excel 2003. Thanks very much for your help.
use a custom format with how ever many digits you need, 000000
"Dee" <Dee@discussions.microsoft.com> wrote in message
>...Comments not showing
When a SharePoint workflow is edited and a comment is added. The comment does
not display in the workflow status screen under workflow history.
It shows as follows: Task assigned to Andre Wessels was completed by System
Instead of: Task assigned to Andre Wessels was completed by System Account.
Comments: Please update to the new company logo.
This happens for all standard SharePoint workflows (Approval, Collect
Feedback). Any custom workflows does show the comment. The comment field is
update in the task item. It just does not show.
There is no error in t...Report Server shows 'Service Unavailable'
before install, the SRS setup, send me a warning, some like "the Windows
Sharepoint Services are install and not permit initialize a Reportserver
i skip wiht the installation, so..
I can't run
http://<localhost>/Reports and http://<localhost>ReportServer
show a message "Service Unavailabe", but the ReportServer service is running
How initialize that or what do i do?
> before install, the SRS set...Show more time in weekly view?
On default the weekly view is only showing until 4 PM without scrolling
down. I know there is a way to let you see into the evening hours also
...Relationships, duplicate values
Hi, I'm getting the common message "The changes you requested to the table
were not successful because they would create duplicate values...." I think
my table relationships are causing this and don't know how to get around. I
have 4 tables: tblCustomer, tblWorkOrder, tblClientBuildings and
tblClientBuildContacts, the last three are related to tblCustomer by
CustomerName(Primary key in tblCustomer). I have a form frmCustomer that has
a subform that is a continuous form that is bound to tblClientBuilding. On
this subform there's a command button that opens a pop...TransparentBlt doesn't show the bitmap in ME?
The following doesn't print the bitmap on ME while it works on 2k/xp,
can someone help me? Though the status returns TRUE.
CDC *hdc, bghdc;
//loads bitmap into memory
bgBitmap.LoadBitmap(IDB_BITMAP5); // this bitmap has no needles
// get bitmap info
hdc = m_obj->GetDC();
BOOL status = hdc->TransparentBlt(0, 0, 80, 80, &bghdc, 0, 0, 80, 80,
if (st...Showing a Null result
I have a parent table linked to several child tables via a unique text string
The report shows reults from the main table, and has subreports for the
Some records in the parent table have no equivalents in the child tables.
Can I insert some code to produce the subreports with a "None" or "NA" text
string, without populating the child tables with these terms?
My problem is that, I need to run "counting" queries on the child tables,
but the "N/A" records skew the numbers by adding records where there should
I'm not su...mail box rights it only shows "SELF"
Once the user has been created, checking the Email address tab show nothing
(empty), I pointing rus to the right DC, this solve that problem, but i have
still have the next problem:
under the mail box rights it only shows "SELF" where as all
the other account show 8 or more system users?
On Tue, 21 Feb 2006 13:10:27 -0800, "Marco"
>Once the user has been created, checking the Email address tab show nothing
>(empty), I pointing rus to the right DC, this solve that problem, but i have
>...Clear Data>Security Resource Description table not showing in list
GPv10 Logged in as sa. Go to Maint. >Clear Data>System and in the
Tables list the Security Resource Description table is not there. Is
there something I need to do to get access to that table? Thanks.
Never mind....I figured it out. You have to change the Display to
...Show Data Field After Hiding
I found a note from someone with the same question regarding reshowing
data that was hidden after it was deselected from the drop-down list.
And yes, it is easy enough to drag it back on from the field list, but
if it involves anything more than just a sum or count, then you have to
recreate it. For instance, my rows are years. One of my data fields I
would like in the table twice - once as a sum and then again as %
difference from previous year. The reason for wanting to hide one or
the other, is I'm plotting this over time and would like to use the
same chart. Since the scales are ob...Adding a coma to the text data in every row of a column
Adding a coma to the text data in every row of a column
I have an Excel spread sheet that has 6,000 rows of text in one of the
columns. I want to be able to add a coma (,) after the last character
in each row.
Can this task be done automatically?
In additional to posting your solution to this group, can you please
cc: me at email@example.com
The following code did it for me in about 1 second on 7000 rows...
'Adds a comma at the right end of each cell's contents in Column "L" (12).
'For a different column change the L and 1...Sort by Large, Offset from Match, Duplicate values problem
I have a large list of dynamic data, which I am organizing in different
ways. I realize this can all be done in PivotTables, but we have to do this
the olde fashioned way. The table I am drawing the info from looks roughly
Player Buy-In Cash-Out Difference # Times entered
Joe SHMOE $930 $900 $30 1
Sam DOG $0 $0 $0 0
Peter BLAH $100 $1000 $900 22
Doug FINN $500 $0 $500 22
I am using =LARGE, =SMALL on the columns to sort the data, and then MATCH...gp 10 -how to show a list of sop documents for a specific customer?
What is the best way to return all SOP documents for a specific customer
using GP10 list? (not smartlist)
This is our problem:
-we go to the Customers list.
-select a customer and goto > "view transactions"
our problem is that any sop transaction that we click on that is moved to
history, opens the AR transaction instead of the SOP document.
Context? a customer calls and wants to know if something they bought is
under warranty but they have no clue when they bought it. So we will not
know what date is was bought. We are just using SOP, not service management.
J...why is my typing in message not showing up?
i cannot create a new message without selecting font color for each message
even though i have selected auto. how do i correct this?
Are you using stationary? Perhaps your text is set to be the same colour as
"camel" <firstname.lastname@example.org> wrote in message
> i cannot create a new message without selecting font color for each
> even though i have selected auto. how do i correct this?
On 3/19/2010 8:45 AM, Orland, Kathleen wrote:
> Are you using stationary? Pe...