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...Prevent clicking on a cell
I want to run the code below to prevent a range of cells from being selected
if the Range("Q7") = 1. I have all cells on the worksheet locked but the
user must be able to click on the locked cells to trigger a userform so I
have to check Select Locked Cells. So is there any way make the
If Range("Q7") = 1 Then
Range("B5:C5").Locked = True
>So is there any way make the
> Range("B5:C5") unselectable?
No but you can stop them staying there.
Private Sub Worksheet_...if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...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" <email@example.com> 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...Drop-down list #5
I created a drop-down list in a separate sheet in my workbook. I named it
Vehicles. Now I want to add to the list, but I can't figure out how to do it.
I know ig must be so easy, but I'm stumped. Please help.
If it's a one-time occurrence, you can press Ctrl+F3,
click on the name, and extend the formula. Otherwise, I
would make the range dynamic. You can learn how to do
>I created a drop-down list in a separate sheet in my
workbook. I named it
>Vehicles...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...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.
...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:
&...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
<>>< ><<> ><<> <>>< ><<...How do I extend a underline across an entire cell?
When working on a financial statement, I was curious how to 1. Have a line
extend across an entire cell even if the number is only 2-3 digits and 2. How
to apply a double line under a number without using the = sign in the
Look on the formatting toolbar for Borders
Regards Ron de Bruin
"Lindsay" <Lindsay@discussions.microsoft.com> wrote in message news:F4C9ED6C-7F2D-4277-86CC-6FA46D315DA5@microsoft.com...
> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire ce...Content of emails is changing without any reason !
I changed operating system last week. From Win XP to Win 7. Used to work
with Outlook Express at full satisfaction.
I could transfer most of my emails automatically with export/import features
of Microsoft software.
But I suddenly discover 1 very big problem (bug ???)
I am used to work with several maps, and hereby go to several levels deep.
Such as :
Date of action
Name of patient
So sometimes maps can go several levels deep.
When I check ema...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...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 firstname.lastname@example.org> 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...How do I copy the result of a check box into another check box?
I'm trying to copy the result of a "check box form field" into another check
box. For example: if I check (or uncheck) one box in a form, another box
later in the protected form will also be checked (or unchecked) , much like
the ref + F9 command for the text form field. Is this possible? Thanks.
This cannot be done without macros. If your project will allow macros - see
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
G...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...cell contents revert to 0 when i click on the next cell
I put a number into a cell click on the next cell and the first cell reverts
to 0. If I format to number with 2 decimal places it will be ok but when I
try to take out decimal places it goes back to zero,
You haven't said what number you are trying to put into the cell, but I
suspect that the number is less than 0.5.
A quick test shows that if you set the cell to no decimal places then enter
a number less than 0.5 it is displayed 'rounded down' so it will show as
zero, if it's 0.5 or above it displays as 1.
If you need to put numbers less than 0.5 into youe c...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this:
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?
Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for
any and all empty cells in A2 to A9. It no longer matters if any of the
cells are empty, the formula correctly gives the correct addition of A1
plust a sum of everything between A2 to A10 without any #VALUE! results.
Was hoping to have the formula above als...Moving Exchange #5
I am needing to move my Exchange server off of the SBS box that it is
currently on and move it to another, new server. I cannot keep the servers
the same name as I need the old server to continue to run SQL. Are there
white papers on how to do this?
On Fri, 18 Aug 2006 08:43:40 -0700, scottdog129
>I am needing to move my Exchange server off of the SBS box that it is
>currently on and move it to another, new server. I cannot keep the servers
>the same name as I need the old server to continue to run SQL. Are...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...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" <email@example.com> wrote in message
> how can i edit the positioning of the balloon comment in a mi...