can't send or receive emails
this just happened this week. I get this message....The connection to the
server has failed. Subject 'help', Account: 'mail.comcast.net', Server:
'smtp.comcast.net', Protocol: SMTP, Port: 80, Secure(SSL): No, Socket Error:
10060, Error Number: 0x800CCC0E........your advice to to change smtp port to
25 or 587 or 80 does not work????
Port 80 is definitely wrong for that server; whose advice was that?
Comcast wants you to use these email settings:
Note that the outgoing server now requires port 5...Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a
smaller width, but resizing it is completely disabled and renders Access
2007 utterly useless for me. Is there anyway to 'reset' the window?
...Can I copy radio buttons so that the second set is independent of.
I have a group of four radio buttons that all point to one cell. My goal is
to create a second set that looks identical to the first but which points to
a second cell. This is for a questionaire that will have many questions with
the same four answer values. I want to be able to quickly create 100 button
groups that will each update a separate cell for scoring of the questionaire.
There are optionbuttons on the Control toolbox toolbar and there are
optionbuttons on the Forms toolbar.
Each has different behaviors.
If I had to use lots, I'd use the Forms version.
Here's a pos...How can I get 32-bit Integers?
I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so as
to have 32-bit Integers, along with 64-bit Longs?
"Renny Bosch" <firstname.lastname@example.org> wrote in message
> I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
> is just 16 bits, i.e. its max value is 32,767. How can I configure it so
> as to have 32-bit Integers, along with 64-bit Longs?
An Access Integer is 16 bits. A Long Integer is...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...Can you delete Business Alerts?
I cannot see any way to delete Business Alerts, can someone tell me how?
I am using GP 8.0
Try going to Cards --> System --> Business Alerts.
Charles Allen, MVP
"Sheri Salomone" wrote:
> I cannot see any way to delete Business Alerts, can someone tell me how?
> I am using GP 8.0
> Sheri Salomone
woo hoo! Thank you!
"Charles Allen" wrote:
> Try going to Cards --> System --> Business Alerts.
> Charles Allen, MVP
> "Sheri Salo...Office 2007 forms
I am creating a form with office 2007, will those people who do not use
office 2007 be able to fill in my form? should I save it in a particular
Provided you start from the normal template, don't use fonts that were
introduced with Word 2007, and save the form in Word 97-2003 document
format, anyone with Word 97 or later should be able to open it. Use only the
legacy form fields, to which end
http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things
<>>< ><<> ><<> <>>< ><<...OE6 can't start due to message store prob
"Outlook Express could not be started. The application was
unable to open the Outlook Express message store. Your
computer may be out of memory or your disk is full
This happens after I try to copy in backed up .dbx files.
...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...can I snap wrap points to a text box
rather than having to add individual wrap points to the edge of a frame,
which is never as accurate anyway, can they be set to 'snap' to a frame (eg
the ellipse) so that they are perfectly inline, (and which would of course be
a lot quicker)?
Edit points will not snap. There are options for edit points, select a point,
right click. If you hold down control, the cursor will turn into an x, you can
delete a point with a click.
Truly a good draw program would be preferable.
Mary Sauer MSFT MVP
&q...Why ClassWiard can't see my Class?
I created a class(Class-A), derived a class(Class-B) which derived from CWnd
When I used mouse right-click on the new-created class, it shows a
missing "add virtual function" and "add windows message handler". From
ClassWizard I couldn't
see the new-created class either. I tried to delete myprogram.clw & re-issue
it doesn't help. Anyone can help ? Thanks,
"EagleChen" <xx@xx> wrote in message
> I created a class(Class-A), derived a class(C...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...Excel Grid Lines in Outlook Preview Pane
Is there any way to send a spreadsheet to a mail recipient in the body
of the message and not have the grid lines show up in the Outlook
preview pane when the recipient views the e-mail? If you open the
e-mail in Outlook, the grid lines disappear, but in the preview pane
they are there.
Using Excel and Outlook 2003.
Uzytkownik "Kimberly" <Blackrose73@gmail.com> napisal w wiadomosci
> Is there any way to send a spreadsheet to a mail recipient in the body
> of the message and not have the grid lines show up ...Publisher can not save file
I recently started having troubles with my Publisher 2003. Whenever I go to
save my files now, using save as or just the save button, it gives me a
dialog box that says "Can not save file." It does that twice, then it
disappears. I also noticed that when it does this, it leaves the .tmp files
in the directory where I tried to save. I can change the name of the files,
and sometimes it will save it. Most of the time not though. I have NAV, and I
noticed that it was said there was an issue with Publisher and NAV. Is this
the same with the 2005 version, and is this anything anyone...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...how can i edit the positioning of the balloon comment in a word fi
how can i edit the positioning of the balloon comment in a microsoft word
please reply on my email
What you can do is adjust the space reserved for the balloons in the margin.
In Word 2007, on the Review tab, click Track Changes, and then click Change
Tracking Options. Change the "Preferred width" setting.
Microsoft Word MVP
"melikelmalik" <firstname.lastname@example.org> wrote in message
> how can i edit the positioning of the balloon comment in a mi...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Report Can Grow not aligned horizontally
I have a report where I have 1 row of text, memo, number, and date fields.
The memo field can contain up to 4-5 lines of wrapped text. I have set all
teh rows to "can grow". However, on my report, the conditional formatting
For instance, the fill (which I have set to a gray color) in the memo field
is about 3 lines deep when there is a lot of text in the memo field, but the
text and number fields associated with that record are actually only 1 line.
This essentially looks like a mess, small gray filled boxes for the text
fields and a large gray ...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...How can I print on 8 1/2"x17" paper?
I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
change the paper size to accept and print anything bigger than 14." any
suggestions would be greatly appreciated
First make the size settings in the Printer Setup. You may need to use the
"mickilena" <email@example.com> wrote in message
>I have cut down an 11x17 paper to 8 1/2" x 17". I cannot figure out how to
> change the paper size to accept a...