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
timeo...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...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...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...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,
...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...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
...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
news:DA9FFF99-FC28-...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...Question for Bob Phillips re Splitting Names from Cells
You gave the answers below for splitting names from cells:
Using these formulas on this example John A Doe results in John A an
Doe, is it possible to split it to show John / A / Doe in 3 separat
cells, I know I could use the formulas again on the John A result t
split them but I'd like to do it in 1 go
If possible could...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
=SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...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 ...Change Domain Name on outgoing Emails
Our company just purchased another company with their own Exchange Server and
AD infrastrure. We want all users in this new facility to have Email
addresses with our Domain such as email@example.com instead of their current
Domain firstname.lastname@example.org. Until I migrate resources from their Forest into
our Forest I have created contacts to forward all Emails from the abc Domain
to the 123 Domain. When users reply or send Emails from the 123 Domain it
still has their email@example.com Email address which will cause confusion
with our customers and suppliers. How do I force their Emails to us..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...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 ...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...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?
...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...How do I assign a name to a PDF report via VBA
Thanks to the internet site:
I have the following subprocedure:
Private Sub Print_to_PDF_Click()
On Error Resume Next
Dim reportName As String
reportName = "HCBS CMgr Smmry Report"
DoCmd.OpenReport reportName, _
Set Reports(reportName).Printer = _
DoCmd.OpenReport reportName, _
This appears to be a good start; however, it stops and
waits for me to enter the n...vba vs VB dotnet
I have a new project to use MS access as backend.
I would like to know what adre the difference betwwen VBA and VB dotnet as
what is the best choise and what I need considre to use front end bwteen 2
Your information is great appreciated,
> I have a new project to use MS access as backend.
> I would like to know what adre the difference betwwen VBA and VB
> dotnet as front end?
> what is the best choise and what I need considre to use front end
> bwteen 2 choices?
Well a big difference is that you can actually create a fr...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...