outgoing mail problem(s)
Ok, so I just got comcast high-speed cable internet, and it's all well
and fine, except for when I try to use outlook to send mail. I
currently have two mail accounts setup in outlook, my college account
(IMAP/SMTP) and my new comcast one (POP3/SMTP). Originally, my comcast
account was setup in outlook express, but since I use outlook for the
calander and stuff, I wanted to use it through there, so when it asked
if i wanted to import the account settings (when i first started it), I
did, and that's where my problems have begun. I've e-mail comcast
repeatedly, and all everything ...Including Totals in Chart's data table
Is it possible to include totals within a chart's data table but not in the
chart itself? For example for you are charting 3 fields across 12 months and
want to show the total of the 3 fields for each month in the data table, is
there a way to do so which would allow the data to be "live" and updated as
the data source changes.
The data table only shows data in the chart. You can add the totals to
the chart, which puts them into the table, and then format the totals
series so it doesn't appear (no lines, markers, borders, fills).
Jon Peltier...Fuel Tank Formula's For Dip sticks
Could you put the question in the message space and be less economical with
Bernard V Liengme
remove caps from email
"DENNIS" <DENNIS@discussions.microsoft.com> wrote in message
I think I have a strong feeling what you need. Is it possible that you
need an Excel formula to calculate the volume in a tank depending on
the height of the fluid (as measured by a dipstick)?
Is this is so, you need to give some more data. What is its
cross-section (circular, elliptical, ...S.O.S.....
I have a spreadsheet set up with column A for the date (one day per row),
and column D as the total daily takings. I want a formula that changes
automatically when I enter each new daily amount, and if I enter a daily
taking of $0, I don't want excel to include that day in the month's average.
So I want it to regognise that the $0 day is not to be included, and only
divide by say 29 days instead of 30 for June. Hope I've made sense...??
Thank you in anticipation.
Here's one way.
Try this array formula** :
=AVERAGE(IF(TEXT(A2:A20,"mmmyyy...CRM should let you change a product's unit group
It is impossible to change a product's unit group once a product has been
created.As a result, if you don't get this aspect of your system configured
correctly at the start, it is very very hard to correct it down the road. I
realize that the unit group permeates the entire database schema, but it
should still be possible to change it without deleting the product
altogether. Deleting the product and re-adding it is not usually an
acceptable option for a mission critical system that has been in use for a
few years. Hopefully you can find a way to let us change the unit group in...How do I not print the column letters A-Z but keep the row #'s
I am trying to print a chart where I want to keep the row numbers but not the
column headings A-Z printed. Choosing Page setup under the Sheets tab only
lists them together not as single choices. Is there a way to customize the
sheet to only list the row numbers?
How about inserting a new A column and adding =ROW()
Bernard V Liengme
remove caps from email
"jgb" <email@example.com> wrote in message
>I am trying to print a chart where I want to keep the row ...Spybot S&D
I threw this question on a previous post,but thing it just got lost in all
the other answers that were part of another question.So hope it is all right
to re ask this anew.I have window's live one care,and malwarebytes. Want to
put Spybot back on computer. when I had it before it did great job,but I got
spooked about it and deleted it. Is is a good one to use. How about AVG.
window's one care apparently does not work very well as I seem to have an
infected computer. Thanks to all who help the helpless.
On 07 May 2010, =?Utf-8?B?ZGlkZWU1OA==?=
<didee58@discussions...Unable to enter "S" or words starting with "S" in cells
Am working with Excel 2000 (Version 9.0.6926 SP-3)
When entering words starting with "s" or just "s", the entry fails and
brings up one of several menus. The menus vary depending upon how many
keystrokes I have made before realizing the text entry failed.
"S" is teh only letter I have found where this problem occurs.
If I double click on the cell then enter the word starting wtih "s", then I
can enter the text. This is cumbersome and very time consuming.
Do you have the same problem with any other programs? It sounds to me like a...How to not plot blanks
I'm plotting a line graph on a range of cells and the formula in the series
of cells is this:
I want the chart to basically add a plot each day so the C column just tells
me that the next day has past.
At the moment when the value in column C is blank it is plotting these cells
as zero and continuing the line. How can I make the line stop when the Value
in C is blank?
Any help would be greatfully appreciated.
Thanks in advance
If you click on Tools -> Options and click on the Charts tab you'll see some
...Invoke external app's UI
I'm writing a MFC app (VC++ 6), which needs to invoke an external
application's user interface controls. What classes should I be using?
E.g. I've Notepad running, from my MFC app, how do I call Notepad's menu
item "View | Status Bar".
"Charles Tam" <CharlesTam@discussions.microsoft.com> ha scritto nel
> I'm writing a MFC app (VC++ 6), which needs to invoke an external
> application's user interface controls. What classes should I be using?
I'm not sure, bu...Outlook's Newsreader disappeared
I have just gotten Office 2003 installed on my pc at work. In the 2000
version of Outlook I was able to view the discussion groups, but unable to
post. That was okay. When I am at work I used the discussion group website to
view and post.
In this new version 2003, (new to the office) I found a Help article that
explained how to set up the Newsreader from within Outlook. I went to the
View, Toolbars,Standard, customize, and chose the Go category, and selected
the News menu item, dragged and dropped it on the Go menu. I clicked on the
new menu item, it opened the Newsreader and prompted...Adding 1 year's difference to user's input of yyyy-yyyy?
If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically
have the cell underneath increase by one year?
i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 and
B4 would show 2007-2008, etc. down the column?
Thank you! :oD
=IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1)
and copy down the column for as many as you need.
Hope this helps.
On May 29, 3:16 pm, "StargateFanFromWork" <NoS...@NoJunk.com> wrote:
> If a user inputs 2000-2001, or 2007-2008, is there a way t...Help! Something adds 1 hour to my datetimes! :-S
For some reason, somewhere in my application 1 hour is added to my dates,
depending in which time zone the application is run...
Because I don't have a clue where this happens, I posted this to the three
relevant newsgroups (vb/ado, sql and xml): my aplogize for this.
I'm doing a Synchronisation between two SQL Servers (2000): All the Data is
read into a DataSet, and exported to an XML-file:
SQL Server -> DataSet (VB.NET 2003) -> XML -> DataSet -> SQL Server
When I run everything in the West Central Africa Timezone (GMT+1, no
summer-time): everything works fine. ...Using custom control from dll's
My goal is to create some CPropertyPage objects and doc/view template
within a DLL. The property pages will use the custom control which is
contained in a diferent dll. The view (a formview) will use the
CPropertyPages objects and that doc/view template will be used from a
MFC application just as another doc/view template would be.
I've got a custom control created by me which works correctly if I use
it within a MFC application.
I want to insert this control in a dll to share it with other
First question: Which kind of DLL (extension or regular) should I use...Mulitple If's in a function ?
Morning all, what I would like to do is when a checkbox is checked, hide
about 7 different controls. I am having success doing it with ONE, but
failing after that. I tried using a function and then calling it from my
Form's On Current AND the Checkbox After Update. With the single line in
there, like this:
Public Function MISLE_only()
If Me.MISLE_case_only = True Then Me.cmdACTSUS_PIW.Visible = False Else
Me.cmdACTSUS_PIW.Visible = True
NO problems, works great. How can i add the other controls I want to close
when checkbox Me.MISLE_case_only is checked?
...If before today's date insert Expired
Using Access 2003. I have a query with 5 fields. I have created an
expression to insert words if the CredentialExpirationDate is after a
1/1/2050 it inserts "No Expiration" or if the date in the
CredentialExpirationDate field is today or before I want it to insert
"Expired" all other dates are as entered I am having trouble with the last
part today or before. I have tried various things I have pulled from other
posts but I keep getting an error. This is my most recent <Now().
Credential Expiration: Switch([CredentialExpirationDate]&g...S.O.S. Need Assistance ~ Is this one possible & how?
I'm trying to create a formula in a range that basically equals
designated percentage which will be used to graph a chart on a separat
The example would be: if a date text is entered into the range, an
once that is populated that particular filled in range will then equa
10% (the date text shows in the range not the percentage) Thank you
Message posted from http://www.ExcelForum.com
FIGURED IT OUT...IT WORK
Message posted from http://www.ExcelForum.com
...will VLookup peek over it's shoulder?
Say I have 8 columns, A thru H
the lookup table is column C
Can Vlookup find the match in C3501, and report the
resultant number residing in B3501?
....or do I cut and paste column c to column a?
which would be a pain in the botty.
rodney at touch88.com.au
Send spam to the FTC at
You can use =index(match())
See Debra Dalgleish's site for lots of instructions:
> Say I have 8 columns, A thru H
> the lookup table is column C
> Can Vlookup find the match in C3501, an...How not to plot zero's
Wonder if anyone can help here.
I use the following formula to create a series for a graph
Now if the data returns an error the cell looks blank.
I know the cell is strictly not blank.
When plotting this series on the graph the value turns to
This is what I want to change.
I don't want to plot the zero's, I know by using NA()
instead of "" returns #N/A which does not plot the zero
point but when this happens the series shows a continuous
line. I need to show the broken series.
In "tools, options, chart"...Charles Schwab's URL's
I live out of the country and have a foreign version of
Money. I want to change one of the financial
institution's URL to Charles Schwab's. Could anyone
please let me know what the three URLs are?
Thanks a million.
The only one I know is www.schwab.com
"Ed" <firstname.lastname@example.org> wrote in message
> I live out of the country and have a foreign version of
> Money. I want to change one of the financial
> institution's URL to Charles Schwab's. Could anyone
> plea...how do i automaticly "save as" using a cell's content as file nam
I'm sure you'll need to use VBA for this. This will save the file with the
name based on the contents of A1.
If you want to specify a save location:
ActiveWorkbook.SaveAs Filename:="C:\Temp\" & Range("A1").Value & ".xls",
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
"cxlough41" <email@example.com...Printer DLL's
Our Dynamics GP graphical reports do not print. They come up on the screen
but will not print to a printer nor our PDF writer. Will come up in
Microsoft XPS Document writer. After much troubleshooting (getting Microsoft
involved), the final assessment is that a printer dll that several (maybe
all) printers have in common must be corrupted.
Question: Does anyone know of a way to identify/list dll's associated with
a printer. We are in deep trouble here, not being to print invoices.
Print a test page. It will tell you the exact driver and version. To print a
test page,...Need help !!! (S.O.S.)
I created a file in MS Word 97 and password-protected it. After long time of
not using it I forgot its password. Is there any way to open a
pssword-protected Word file?
In article <9bUZb.67048$hR.firstname.lastname@example.org>,
"Peter Chernyak" <email@example.com> wrote:
> I created a file in MS Word 97 and password-protected it. After long time of
> not using it I forgot its password. Is there any way to open a
> pssword-protected Word file?
Do a Google search for password crackers. If you're using a Mac (sin...how to get CDialog 's member from a worker thread?
class CMyDlg : public CDialog
UINT m_MyNumber ; // How do I get this number from a worker thread?
UINT MyWorkerThread1( LPVOID pParam )
CMyDlg * dlg = (CMyDlg * ) pParam ;
// this is bad as CWnd and derived classes are not thread-safe object
// What's the right solution ?
UINT n = dlg->m_MyNumber ;
AFAIK, you can access data members but not other things that are related to
"J.N.J." <firstname.lastname@example.org> wrote in message
> class CMyDlg : public...Ignore Zero's
I have used the following to get the average value from a set of data whilst
ignoring zero values within the data set.
I would like to use the percentile command on the same set of data. Is there
a way that I can use Percentile and also ignore zero values ?
with an ARRAY formula
This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formu...