Here is fix for Windows file problems
If you have installed a Windows update and started having problems opening,
closing, copying files, see:
A better solution is offered at
http://support.microsoft.com/kb/918165 "Problems in Windows
Explorer or the Windows shell after you install security update
Patricia Shannon wrote:
> If you have installed a Windows update and started having problems opening,
> closing, copying files, see:
> http://ww...Problem with CFTPConnection
I've an application that connects to an FTP Server and uploads a big
directory (size over 500 MB). Now what happens is that after sometime the
application stops uploading files and stays idle. The FTP server connection
timeout value is set to 2 minutes. So the server seeing the connection idle
for two seconds, disconnect the session and no more file is uploaded. On
debugging I found out that after some time CFTPConnection.PutFile() method
hangs on some random file and stays like that for 5 minutes (default send
timeout value of CFTPSession). During this time the server connection
I am trying to concatenate two fields and then add text in brackets to the
end. Here is what I have:
StaffFullName = ([Me.LastName] & ", " & [Me.FirstName] & " (Mgr)")
I want the end result to be: Smith, Mary (Mgr)
How do I achieve this?
What you've done will work. You can also use the "+" operator if there is a
possibility that there will be a missing first name:
StaffFullName = ([Me.LastName] & "," & (" "+ [Me.FirstName]) & " (Mgr)")
That will avoid an extra spa...Excel 97 Win XP calc problem?
I have a machine running office 97 and Win XP.
I have seen posts stating it runs fine, but I don't know how man
people use spreadsheets that require a hard calculation:
Excel will not force a calculation. i.e. ctrl-alt-f9 does not cause
full workbook calculation as required.
Meaning cells do not update and it doesn't calculate unless you clic
in the cell to edit and hit enter.
neither does the "Calc Now" button.
Auto or manual calculation mode has no effect.
Anybody else have this problem
Message posted from http://www.ExcelForum.com
Make sure that both the SR1 a...Date display in Excel
Format column of cells as Date, display as mm/dd/yy. Date
entered into cell, shows up correctly in the text entry
field at the top of the screen, but the data on the
worksheet displays as "33747", or similar number. Only
happening on one workbook.
Try tools|options|View tab|uncheck Formulas.
> Format column of cells as Date, display as mm/dd/yy. Date
> entered into cell, shows up correctly in the text entry
> field at the top of the screen, but the data on the
> worksheet displays as "33747", or similar number. Only
> happening on one...CRM Outlook Client Configuration Wizard Problem
CRM 4.0 - Microsoft Outlook Client
We've Microsoft CRM 4.0 Server roll up 8 as well as CRM Outlook Client on
the same roll up version. Our Internal Web Access works without problems
users get to it and they're automatically authenticated. IFD Development is
the same way except they're prompt through a login page for their username
and password when they're coming from an external network.
Ever since we moved to a new facility users are experiencing problems
connecting to CRM using their outlook client, I have a test machine where I
have the CRM Outlook Client ins...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...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...Problem with Update function of CRecordSet class
When I use from Update function of CRecordSet class, it apply to table
after a few time(for example 1 second) when I need to see it at time.
...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...OL2002 Problem : HELP, SOS, MAYDAY
I have an IMAP account and OL2002 as client.
I have checked for my account ( tools, send/receive
settings, define send/receive groups, <my_account>,
edit) download item description only.
It works only the first time I start OL2002, but it does
not work anymore for subsequent automatic/manual
Please could someone really help me ?
Thank you in advance,
...request to solve my problem #5
hello friends this is vijay,i got a problem while doing my project
based on vc++ (i.e)"How to implement Fit Window feature in VC++6.0 in
an MDI Application" if any of you got any idea about that please do
reply me with the proceedure.i will be waiting for your reply
...Excel. I am having a problem with hidden text
As I type text in some cells, it does not always dispaly if it exceeds the
cell length. I wish to keep the cell lenghts for the entire document, but do
wish for teh text in that particular row to be displayed.
How about if you select that cell, then
format|cells|alignment tab|check wrap text
And with that row selected
> As I type text in some cells, it does not always dispaly if it exceeds the
> cell length. I wish to keep the cell lenghts for the entire document, but do
> wish for teh text in that particular row to be displayed.
Da...date function #3
This is a multi-part message in MIME format.
I have a cell A1 with date 5/2/07. If in cell A2 I do month(A1), I get =
5. Is there a way to return May instead? either through a command or =
formatting? I can reference cell A2 with the 5 with a if(cell =3D 5, =
"May", ) in cell A3, but the date in cell A1 varies from Jan to Dec and =
the 12 embedded if's in cell A3 are too long (that is the error I get =
when trying to do so), plus i...how do I change date format in the header in Excel XP ?
I need to chage my date format, in the header to Day; Month DD, YYYY
ie. Saturday; May 23, 2005.
Woudl you please help me out ?
Check this out.
but change the format to "dddd, MMMM dd, yyyy"
"Hesam" <Hesam@discussions.microsoft.com> wrote in message
> I need to chage my date format, in the header to Day; Month DD, YYYY
> ie. Saturday; May 23, 2005.
> Woudl you please help me out ?
> Thank you.
&g...Excel List Sorting Problem (Descending)
I'm having trouble sorting my list--my column contains *only* 4-digit
numbers but when I click on "descending order", only about the first half of
the rows are arranged this way, before it begins again to arrange the rest in
Has this problem happened for anybody else? I'd appreciate any help you can
Part of your list is text, although it looks like numbers.
Format an empty cell as number. Enter the number 1. Copy. Select your
"numbers". Edit>Paste Special, check Mul...I really need help with a formview problem
I have a formview that I place a toolbar onto. In my OnInitialUpdate(),
after I create the toolbar, I say
The formview is still not sized properly. It looks like the problem is the
toolbar on the top of the formview. It is not being taken into account in
sizing the formview. The difference at the bottom of the form that is not
displayed is the size of the toolbar. Any suggestions?
Should work if your toolbar was created (and docked) back in your CMainFrame::OnCreate() method.
----- William Gower ...Printing problem in booklet format
When I try to print my booklet document, on the screen it looks perfect, but
when i go into print preview it only has half of each page on the paper.
When i print, it comes out exactly like that. I have Publisher 2003 and run
it on XP home. My printer is an Epson stylus Photo RX650. I contacted Epson
and they say its a Publisher problem. Any suggestions.
Are you selecting booklet in page setup? Do you ...Option trades with past expiry dates not showing up in Portfolio M
Money 2006 Portfolio Manager does not show closed option trades that have
expiry dates in the past, even when the "show closed positions" is checked.
The transactions are still there in the investment accounts, just not visible
in portfolio manager. I just called microsoft support and have notified them
of the issue and hope that this issue is fixed as an update. If not, it
pretty much makes the portfolio manager (and Microsoft Money 2006) useless
for option trading investors.
"MumbaiBabu" <MumbaiBabu@discussions.microsoft.com> wrote in message
news:1...Money deluxe 2007 password problem
When I update my bank account transactions I get a message saying that my
account was not updated because my password is incorrect. I then go into
account info and have to update my password. I save the update, but then it
happens again sporadically when I open Money at later times. Is there a way
to fix this glitch?
...problem opening up program/file
I am having some trouble opening up Word. It was working okay until I
loaded some fonts to FontBook. Okay, now I removed all my fonts but I
still get this error message about corrupt fonts I have on my computer.
When I open Word, I see the blue starting-up window: Word:Mac 2004.
Right underneath the product ID #, I see that it is initiating... when
it gets to the point "Optimizing font menu performance" I start getting
this error windows popping up one after another. (E.g. The font M
TimesSmallText is corrupt and should be removed.) I keep on clicking
okay for a whole lot...How do you sort a date range by month?
We are trying to find out how many birthdays fall with in a given month using
You could use a helper column, with something like = A2. Format this
(Format - Cells - Number - Custom: mmm. Now you can use Data - Subtotals,
"At each change in: Month" and "Use function: Count."
"Brewisc13" <Brewisc13@discussions.microsoft.com> wrote in message
> We are trying to find out how many birthdays fall with in...vb date and ssn textbox formats
Ok, so maybe I am crazy...but I have checked "Visual Basic 6 how t
program", and "Visual basic 5 teach yourself in 24 hrs" for and exampl
or how to format a text box on a user form to accept and display date
and Social Security Numbers in the specified format.
Message posted from http://www.ExcelForum.com
TextBox1.Text = Format(Date,"dd mmm yyyy")
TextBox1.Text = Format(mySSN, "000-00-0000")
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mai...Two calendar dates in one cell..??
I have a Microsoft Publisher calendar document that was created in 2005 that
shows the dates Monday - Sunday. When I print it, it will not print out any
that fall after the fifth week (eg January 2006 it prints up to January 29th
but not the 30th or 31st). These are in an "overflow" area. But when I open
the calendar part in Word to edit the calendar, it appears normally and that
sixth week shows up just fine. I need that sixth week to print OR I need to
do the split date feature (I would prefer the split date).
How can I set up the numbers in one of those cells so i...concatenate and then take off last #
What can I add to the following formula so that it will take off the last
digit? Because it will always have that zero on the end that I don't want.
> What can I add to the following formula so that it will take off the last
> digit? Because it will always have that zero on the end that I don't want.
> As in:
> A6: 020605006AA20