I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.
Thanks in adavance.
The comment usually appears to the right of the cell, and should still
allow you to see t...Printing problem from Excel 2007
I am having an issue with printing from Excel 2007. Many users when
printing from Excel with get several pages of non-sensical "junk"
printed out on the pages. If it actually prints what is on the page,
none of the items are in the cells, but look like they are just
randomly thrown about the page. I have found that this most often is
related to the Calibri font somehow, because I instruct them to change
the font to Arial and all prints fine. That being said, if the user
converts the Excel sheet into a PDF and print, it prints perfect. This
is a great workaround, but kind ...Problems printing in Publisher 2003 with HP PSC 2410 #2
I am new to publisher 2003 and am having great difficulties printing anything
properly using an HP PSC 2410 all in one. As an example when trying to print
a half page side folded pre-designed greetings card all that prints is page 1
and part of page 4, minus any text. Pages 2 and 3 are missing altogether.
The print preview however displays everything correctly. I have reinstalled
Office 2003 and updated the printer drivers to the latest versions but the
problem remains. Any help is much appreciated.
...synchronising problem with Sony NWZ-S545
Up until recently i could sync tracks/albums etc to my sony S545 MP3. now
when i try and drag tracks to the sync folder then click start sync the mp3
player just freezes, WMP states "processing" but nothing happens.
Have searched the web for a solution but nothing. done sysem restore etc
etc. I guess it must be a recent update but what one?
Its a pain in the backside and hope someone can help
> Up until recently i could sync tracks/albums etc to my sony S545 MP3. now
> when i try and drag tracks to the sync folder then click s...Excel Mail Merger Problem
When merging excel with word for..my currrency field is
dropping off zeros to the right of decimal point..if
field has $ 56.03, it imports correctly, but if it is
$56.00, it comes in as $56, if it is $56.30, it comes in
as $56.3...this process is for invoices..any advice (I've
Debra Dalgleish has given the following reply in newsgroups
and has also identified the following MS KB articles in
such as : http://google.com/groups?threadm=3DFA8DA8.6000209%40contextures.com
304387 - WD: Date, Phone N...Exchange 2003 SP1 Install Error
When I try to install E2003 SP1 I get the error:
EventType exchangesetuperror, P1 6_5_7226_0, P2 update, P3 microsoft
exchange messaging and collaboration services, P4 install, P5 e0070101, P6
_null_, P7 1, P8 NIL, P9 NIL, P10 NI
The log says it cannot find a file but I can't tell which file it's looking
Any ideas how to fix this?
this is a follow on to a previous thread (Copy Macro)
We are now successfully creating a new Workbook using the code below.
FName = .Path & "\code.txt"
ActiveWorkbook.SaveAs Filename:="c:\Week\testing" & strFileName &
Problem is when we open the new Workbook and run the macro the code defaults
ba...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Installation of KB970430 Failed, Error 800B0100
Tried to install KB970430 automatically and manually and failed. Received
error 800B0100 which took me to System Update Readiness Tool and in to an
apparent circle. Using Windows Vista.
> Tried to install KB970430 automatically and manually and failed. Received
> error 800B0100 which took me to System Update Readiness Tool and in to an
> apparent circle. Using Windows Vista.
Suggest you clean boot Vista and then try to run the System Update
Readiness Tool (CheckSUR) again:
How to troubleshoot a problem by performing a clean boot in Windows
Vista or in...Service Pack Installation Issues with GP 9.00.0247.0 on Windows Vi
Greetings, I have installed Great Plains v9.00.0114.0 on Windows Vista. I
ran the installation package MicrosoftDynamicsGP-KB923671-v9-ENU, but receive
the following messages with result of a failed installation of the Service
Log Name: Application
Date: 10/8/2007 11:50:13 AM
Event ID: 11729
Task Category: None
Product: Microsoft Dynamics GP 9.0 -- Configuration failed.
<Event xmlns="http://schemas...save as problem
I cant save my excel file
The "save as" option is not eviable. Whats happening?
"From a prior post by Ron DeBruin,
You can reset your menubar to default.
Right click menubar. Customize > Toolbars Tab. Select worksheet
menubar. Click Reset button.
Using VBA Application :
CommandBars(""Worksheet menu bar"").Controls(""File"").Reset
Or the whole menubar
You lost the things you add to the menubar!!"
And one link that offers some sugges...help with installation isue
Hope this is correct NG
When I try to run `Karens replicator` (for external backup) My PC
automatically runs an installation for publisher 2003 and then gives error
require file SKU019.CAB
then asks for original CD to be inserted.
Publisher still works ok
I can`t see what the relationship between the 2 are, how do I stop this
trying to install?
Rent a villa in Turkey
I would suggest aksing the folks over at karenware.com.
http://www.karenware.com/powertools/troubl...Can't Install IBF for CRM on CRM Server
first i'm install IBF On my CRM v1.2 (it's name testcrm)
after that i'm try to install IBF for CRM on my CRM Server
but in Step "Publish Metadata" i'm type "http://testcrm:8082" and click
but it's show message box "The Information Bridge metadata service
location is not avaliable" and can't install it.
-_-' . but i can access "http://testcrm:8082/IBFWriteService.asmx" and
"http://testcrm:8081/IBFReadService.asmx". so how can i install it ?
I had the same problem - try using http://localhost:8082 for...Problem OL 2002 Email
I am having a problem with OL 2002 email settings. I
have two computers which I am setting up. One computer
works perfectly. The second computer I have configured
exactly the same...incoming/outgoing servers and ports,
etc... are all setup the same. On the second computer
when I press test email settings, everything tests fine.
But when I try to do a Send/Receive, I run into problems.
First, the POP3 tries to connect to the POP3 server twice
at the same time. (I am able to see this on my POP3
server console.) Second, the SMTP sending mail never
connects to my SMTP server. (Ag...2007 B2 MSOO has encountered a problem
More often then not when I click to open an email in my inbox I get this MSOO
pop-up with a checkbox, checked telling me MSOO has encountered a problem and
needs to close. Has this been an issue for others and is there a fix.
If you have Adobe Acrobat Pro 6/7 (not the reader), go into Control
Panel, Add/Remove Programs, click change for Adobe Acrobat Pro and
remove the Office & Outlook plugins.
"Jax" <Jax@discussions.microsoft.com> wrote in message
> More of...Sumproduct Problem (AB)
Hi everyone, can you please sort out this problem for me?
SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1)*('Client Opening
Stock'!C2:AH138=A7),'Client Opening Stock'!C2:X138)
'Client Opening Stock'!B2:B138 is the Client Name
Client Opening Stock'!C2:AH138 is the Product
'Client Opening Stock'!C2:X138 is the Amount
I belive the formula is not the proper formula, but this is the result I need.
Thank you for your kind help
You need to tell us what the problem is, and what solution you want. Why is
it "not the proper formula...Query Problem in Test.
I keep getting errors on the WHERE part of my query. I'm sure it's something
I don't know if you will need the whole code to see what the problem is. It
is lengthy, so I will start with just where the problem is.
Set rs = DBEngine(0)(0).OpenRecordset("SELECT T2.Distance, T1.* FROM
(Church AS T1 INNER JOIN qryChurchZip1 ON T1.ChurchID =
qryChurchZip1.ChurchID) INNER JOIN DistanceQuery AS T2 ON qryChurchZip1.Zip5
= T2.ZIPCode WHERE " & strWhere)
' See if found none
If rs.RecordCount = 0 Then
MsgBox "No Churches meet your crite...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any...HTA problem with IE8
We discovered an issue with some inbedded VBScript code inside an HTA written by a developer that is no longer with us. The code work in IE6 but error out on the set objMsgArea statement indicating that the object requires 'objMenuFrame' which should have been set in the previous line of code. If I put in an 'On Error Resume Next" statement in that sub the HTA appears to work correctly however I don't like putting a band-aid on something like this. Does anyone have any solution for this? Here's the code:
sub AppStatusDisplay(strMsgIn, bolAddToStatusLogIn)
s...Sending email in CRM web app problem
I found this problem very annoying.
Our CRM's SMTP service is hosted in YahooMail. The SMTP address is
mail.bizmail.yahoo.com and this is a "locked down" server, which means
required authentication by username and password.
I configured the CRM server's registry by settings the SMTPServerUrl and
other stuff, such as Username and password entries.
Now, when we send emails from CRM web app, it works... BUT... when we send
email using a template which has embedded images, it cannot send the email
and reports an error: "Not valid association" something...
A...Problem with 07 Office Pdf/Xps Add-in
Despite having installed the 2007 Office SaveAs Pdf/Xps add-in, I have seen
Mary Sauer's posting on this somewhere asking if it in the Add-in of the
Office programmes. I do not see it any of the programmes even though I have
reinstalled twice with genuine validation. Anything else I can do? Thks.
It's like a printer...you print to it.
Microsoft MVP Expression
"Menikos" <firstname.lastname@example.org> wrote in message
> Despite having installed the 200...CRM 4.0 CTP 3 Workflow problems
I'm trying to create a workflow that triggers on Status Change to the Quote
Entity, which will create a new task.
When I publish the workflow, and then try to do anything with a quote, I
receive an error:
You cannot switch the execution context's caller if the context is
impersonating the system user.
Has anyone else seen this in 4.0, and does anyone know what can be done to
Whats the role of the user that has published the workflow?
Whats the role of the user that is trying to perform action on the quote?
If you unpublish the workflow, does the action ...Unable to deliver the message due to a recipient problem #3
Hi can anybody help.
I check with varies newsgroup but to no scucess. like for example below
When you send mail to an X.400 personal address book (PAB) entry or one-off
address, you may receive the following non-delivery report (NDR):...
However, this one-off entryis not active in our server.
...Scanning Problem no one seems to be able to fix
I have been having this problem trying to scan and acquire these files i
i get all the way to the public box where the documents are, but at the
end of an acquire it says "Error in retrieving thumbnail BMP. internal
error occurred. connection lost. please refresh." I've had a couple IT
guys in here messing with it and still nothing seems to work. I'm just
not sure where to look or begin. any help or ideas would be appreciated