Change default "Show names from the:" option
Clicking the "To:" button in a new Outlook email message
brings up the "Select Names" dialog box. This dialog
displays the contents of contact databases such as My
Outlook Address Book and Global Address List.
Is there a way to change the default database selected in
the "Show names from the:" line from the current Global
Address List to the contacts in my Outlook Address Book?
My version of Outlook connects with an Exchange server to
acces mail, contacts, etc.
Thanks for any suggestions,
You probably meant to post your Outlook version so we coul...Contacts Don't show in new email
I put in a new contact in the contacts file but it will not show up when I
hit "To" for a new email in Outlook. Under Address Book in Outlook, I have
I saw a previous question on the same subject,m but it didn't help. The
emails are NOT underoined and I don't know what being registered means!
What's the problem and howdo I fix it?
This statement of yours requires clarification: "The emails are NOT
underoined and I don't know what being registered means!"
The simple fact remains that if you created a...How show table text, not auto id number
I'm in my alumni database CONTACTS table. Within this table is STATE where I
have the alumni's state listed. It shows the actual NAME of the state, not
the auto id number associated with the particular state.
I can't remember how I set this up to show the name, not id number. I have
another one that I need to change, somehow, to show the NAME instead of just
a random id number.
To show the state name instead of the number:
1. Open the table in design view.
2. Select the field.
3. In the lower pane of table design, on the Lookup tab, set the Display
control to C...only showing Open invoices on statements
For receivables customer statements in GP 10.0, is there is a way to show
only invoices that are open for the customer?
We have a statement ID where the following are highlighted for the "Print
Current Period Balance, Past Due Balance, Credit Balance, and Exclude Fully
And, on the right-hand side of the window, the following are checked under
Print Payment Terms, Messages.
The statement needs to be somewhat similar to the Aged Trial Balance where
only invoices that the customer has not paid need to show.
ch...my case it online , it Show offline
When I open Messenger and put my case it online , it Show offline to
my friends .. not online .. What to do!
What I did was sign in on that website as well as the regular windows live (if you have the newest windows live you can sign on in two places). So everyone could see me as online again, and I could use windows live as I normally do with the web messenger running in the background. I hope we get a solution soon.
my case it online , it Show offline
When I open Messenger and put my case it online , i...Workflow not displaying details -showing empty screen
I had a workflow running in production and everything was fine.
I imported some changes (not workflow changes) and went to go check on
my workflow, it was listed in the manager and when I open it a blank
workflow screen displays when I would expect to see the workflow
Here is what I have tried:
1. trigger the workflow anyway - it fires and completes fine, so it
must be there
2. backed out my changes - both xml and db - still have the problem
3. did a IIS reset - didn't change things
Any ideas as to what would cause the workflow to be fine but just not
display the details in ...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...Multiple Active Result Setc (MARS)
Using SQL Server 2005, .NET 3.5
A simple task;
1. Obtain a result set based on criteria
2. Foreach row in the result set
3. Check the row against another database
4. If 'flagged' Delete the row
5. Next row
In .NET, the enumeration of the result set could use an SQLDataReader, the
deletion of the row could use SQLCommand.ExecuteNonQuery().
The problem is, when you perform the row deletion, you are potentially
affecting the DataReader enumeration. If you try to run this it fails saying
"There is already an open DataReader associated with this Command ...did not return the results.
I have a big problem with my vista-windows mail.A few days ago, after 5
minutes that I had shut off my computer, in order to check one of my
e-mail,I'm started it again.But windows mail gave error and send me error
report that the e-mails not working correctly.Since that day,the content of
the e-mails,attachments not to be seen when you click any of them.Mean it
didn't retun the results.it is a bit urgent.Pls kindly help me.
Try repairing the database. See www.oehelp.com/WMUTil/
If you still have problems after that, see point 3 here
(www.oehelp.c...Null Return on Count Function
I have the following Query:
SELECT IIf(Count(*) Is Null,0,Count(*)) AS [No longer in Facility]
GROUP BY Residents.[Last Status Date]
HAVING (((Residents.[Last Status Date]) Between [Forms]![Open_PIP
Report]![DateStart] And [Forms]![Open_PIP Report]![DateEnd]));
The query is still returning a null value. Many of the other queries in my
project require this to be at least a zero value to calculate properly. I
have tried using the NZ function also. Perhaps I am using it
I don't quite understand your question. First, Count(*) never retu...Strange results
I im working with Excel 2007. I have these numbers
That I like to add. The result should be 0, which is what I get, if i
Unfortunately the numbers are part of a larger amount, and is
determined by another number in a nother column, so I have to use
SUMIF. My SUMIF looks like this =SUMIF(A19:A26,9334,B19:B26)
but the result of this is -7,27596E-12.
I have seen this before when trying to add calculated numbers (due to
decinmal errors), but in this case all the numbers a...Arrow character showing up with some cross-references
A number of documents that we have been working on lately have an arrow
character (we think it's Unicode character 21B1, Upwards Arrow With Tip
Rightwards) immediately to the left of _some_ of the cross-references.
Picture the grey shading that indicates the cross-reference; the arrow shows
up smack dab on the left side of the grey shading. The problem is that it
only shows up (on screen and when printed) when we view/print the document
within Documentum. The same Word file on my desktop appears to have no such
arrow and no arrow is printed when I print from the desktop. A PD...excel graph is only showing numbers not words-how do I change?
I have a chart that has a part number for the x axis. The chart area then
shows the quantity of scrap and the next line shows reason for
non-conformance. This chart will not recognize the reason for the
non-confrormance. This is indicating "0" for them. How do I get them to
indicate the actual words?
...Not plotting null or text data
I am trying to plot data from cells that have a conditional that returns
either a null "" (I could also make it text) or numerical data. I wish only
to plot the numerical data, but the null (or text) data plots as zero no
matter what I do. Since the states of various cells may change, I don't wish
to exclude those cells permanently. Any thoughts would be greatly
appreciated. Thanks in advance.
As far as charts are concerned "" is text and as such is plotted as zero.
Use NA() instead, charts will interpolate the points.
Andy ...Conditional null value
Wondering if anyone can suggest a way to simplify the following code, which
I’m using in the OnFormat event of a report.
If Not IsNull(DLookup("[ICD2]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field192] = Replace(DLookup("[ICD2]", "EntryICDs", "[EntryNum] =
" & Me![PtAcct#]), ".", " ")
If Not IsNull(DLookup("[ICD3]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field194] = Replace(DLookup("[ICD...Contacts and calendar don't show up
On the navagation pane I have the list of my all mail folder it has my
personal folders listed, but the contacts and calander do not show up. How
can I get them there?
Also, above the all mail folder ther is another box called Favorite Folders
adn in it my inbox, unread mail, for follow up and Sent Items. How do I
Sound like you want to switch to the Folder List Navigation. It has a button
on the Navigation Pane or use CTRL+6
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office...How to show sub-toal level?
I used subtotal funtion and it gave the subtotal number but on the lst it did
not show the subtotal level as it used to be. I restarted computer and run
again but it still dow not work. Is there any thing i can do to fix this
Check your other post.
> I used subtotal funtion and it gave the subtotal number but on the lst it did
> not show the subtotal level as it used to be. I restarted computer and run
> again but it still dow not work. Is there any thing i can do to fix this
...ADO Find and Bookmark, inconsistent results any suggestions?
i'm bit frustrated as all my users are reporting a weird behaviour
from one of our access database. It is an ADP application on SQL
Express 2005 as backend using Access 2003.
No problem of this sort has been reported whatsoever, and no change
have been done to either the dbase structure or the vba code since the
problem came out.
to be very concise, when a form open it will load -using the bookmark
method- the first record available. this is the code:
Dim rs As New ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.Find "[IdItemOrdered] = " &...How to show new mail in Inbox and Unread Mail folder?
New mail only shows in the Inbox while the Unread Mail folder remains empty.
What happened? It worked previously.
If you right click the search folder and select Customize and then Browse
typically you should have the Root Folder and the "search sub folder"
"Hans" <Hans@discussions.microsoft.com> wrote in message
> New mail only shows in the Inbox while the Unread Mail folder remains
> What happened? It worked previously.
Also check your View>Arrange by>Current View ...Formatting Pivot Table- when doble clicking to show Detail
Can I modified the format of the detail that I get once I doble click my
Is there a way that once I dobleclick in my pivot table to obtain the
detail, a macro can be fired to apply the format that I want?.
...no cell results from formula
Often, in Microsoft Excel 2003, when I put a formula in a cell th
results do not show in the cell. For example, today it was a simpl
+b6-b7; Each of these cells had numbers in them - 15,000 and 10,00
respectively, yet the cell showed zero. Automatic calc was on.
tried that same formula in several cells and they all showed zero. Ca
Abram's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1524
View this thread: http://www.excelforum.com/showthread.php?threadid=26871
Pe...How do I compute for a person's age in Excel to show also months?.
I am trying to compute in Excel 2007, the length of service of employees.
While I have been able to computer the years, I would like to see the number
of months and days rather than a fraction of the year.
=DATEDIF(A1,TODAY(),"Y")&" years, "&DATEDIF(A1,TODAY(),"YM")&" months"
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Ed Neri" <Ed Neri@discussions.microsoft.com> wrote in message
>I am trying to compute i...ppt slide show problems
when i select ppt viewer to show a slide show, I only get the photos, no
words appear. What am I doing wrong?
I am sorry to hear that you are having problems with your ppt. Just to have
a better understanding, what is the color for your scheme(if you are using
one)? Another thing you might consider too is to check if you are using slide
animations with other objects such as text boxes and buttons. Sometimes the
order of animated object might not be right(for instance, in your
presentation, the pictures might be covering the objects or text in your
The best th...Show closed investments in portfilio
Can I see my closed (sold) stocks in investment accounts? Or in portfilio. I
am using 2006 Premium and believe that in last years version I could do that.
But I dont see how this year. Maybe I am just missing something.
In microsoft.public.money, md wrote:
>an I see my closed (sold) stocks in investment accounts? Or in portfilio. I
>am using 2006 Premium and believe that in last years version I could do that.
>But I dont see how this year. Maybe I am just missing something.
ChangePortfolioView->ShowClosedPositions is a toggle.
Thanks. That works.
...money 2002 show aust banks etc
how do i get money 2002 to show australian banks on it.
and reflect australian tax implications?