I cannot see pictures already inserted in documents.
In Publisher and Word, graphics already inserted into documents are not
visible. In Publisher's Graphics Manager they are shown in thumbnail view
but not on the actual document.
Everything prints accurately but as I only view the handles of the photos, I
cannot edit anything.
View, pictures, detailed display.
If this is not the solution, slide the acceleration down on your video adapter,
control panel, display folder, settings tab, advanced button, troubleshoot tab.
If this works, go to the manufacturer's web site of your adapter and look around for
an updated driver.
M...value from 2 field joined in one field...( help designing form)
Hi again All,
This time I come with a question that maybe sounds strange.
I have 3 textboxes on form F1,let say TBL and TBH their data
type are numeric and also TBN with text data.Sample record.
TBL TBH TBN
0 3 H
1 9 R
2 0 L:
Now I want to return both of TBL and TBH values to textbox
TBS on form F2 and TBN value to TBK ,with condition
If TBK value Then TBS value :
specially for recor...Excel VBA #2
This is a multi-part message in MIME format.
Je croyais que chaque fois que l'on lan=E7ait une proc du type Private =
toutes les variables =E9taient remises a z=E9ro.
apparemment il n'en n'est rien=20
Quelqu'un peut-il me dire comment remettre =E0 z=E9ro toutes les =
variables avec une instruction ou quelques lignes de code ?
charset="iso-...how can i combine 2 columns in excel into 1 without losing data?
Assuming columns A and B
In C1 enter =A1 & B1
Double-click on the fill handle(black lump at bottom right corner)of C1 to
increment the formula down the column as far as you have data in column B.
If you would like a space between the data........
=A1 & " " & B1
Gord Dibben Excel MVP
On Mon, 9 May 2005 16:26:03 -0700, sturville
Not much to go on here regarding cell contents and formatting, but I'm
assuming that you have text in the cells and you just want to make on long
text string. (If it was numerical...excel programming #2
I would like to know how to automate the following two processes with excel:
1. I would like to take data that is obtained from sql server 2000 queries
results and load the detail data onto excel spreadsheets.
2. I would also like to take data that is obtained from sql server 2000
query results and load the data in pivot tables in excel spreadheet 2003.
On Sun, 17 Jun 2007, in microsoft.public.excel.charting,
Wendy Elizabeth <WendyElizabeth@discussions.microsoft.com> said:
>I would like to know how to automate the following two processes with excel:
Have you tried the...Excel 2007: Cannot open documents by double-clicking
Suddenly I'm getting the following error when I try to double-click on an
Excel spreadsheet to open it:
Windows cannot find 'xxxx'. Make sure you typed the name correctly, and
then try again.
"xxxx" is the full path and filename of the document I'm trying to open.
Additionally, it seems that double-clicking a spreadsheet opens a second
instance of Excel instead of using the currently open instance. I have no
problem dragging a spreadsheet into Excel or opening a sheet from within
Any help would be appreciated.
If the same a...LINKING CELLS #2
WAS WONDERING IF ANYONE COULD HELP WITH THIS
MY PROBLEM IS I HAVE A DROP DOWN LIST WITH ALL DIFFERENT COUNTRIES IN I
WHAT I AM TRYING TO DO IS WHEN I SELECT GERMANY THAT CELL A1 WOULD READ BERLIN AND WHEN I WOULD SELECT FRANCE THAT CELL A1 WOULD THEN READ PARIS AND SO ON, COULD ANYONE TELL ME IS THIS POSSIBLE
Please switch off your CAPS! It is considered bad etiquette.
You could set up a table with one column containing countries and one
containing their capitals. You can then use a simple VLOOKUP() function to
return the relevant capital:
France Paris...Autocomplete issue #2
Thanks for the reply. I feared as much!
The only 2 ways I can think around this is to either :
1. Have an "empty" symbol in every cell (such as a simple "."), so tha
the column is not broken all the way down.
2. Write a list of every possible variable and then *hide* the rows
Then leave a space for a "true" data-entry cell. Then re-paste the lis
and hide those cells again. And repeat.... Of course this would lead t
massive spreadsheet (albeit hidden) and make exporting data prett
So I think I'm stuck with leaving a recognised empty symbol in...Business Portal 2.5, Project Time, Timeout
My users are entering time in their timesheets and the form times out after
about 20 minutes. Where is a setting to extend this value?
Your session has expired.
Warning: Page has Expired
The page you requested was created using information you submitted in a
form. This page is no longer available. As a security precaution, Internet
Explorer does not automatically resubmit your information for you.
To resubmit your information and view this Web page,...2 cycle logarithmic charts
I'm trying to get a 2 cycle log chat. i know that you can
create the 1 cycle log chart in the user charts area.
Could someone point me in the direction of somewhere or
tell me how to get a 2 cycle chart
You get a two-cycle (or whatever number cycle) log scale by double
clicking on the axis and choosing appropriate min and max values on the
Scale tab. Or do you mean a double log (or log-log) plot? You have to
start with an XY Scatter chart, not a Line chart, then change each axis
to a log scale. Double click the axis, click on the Scale tab, and check...Customisation CRM 1.2
We have CRM system installed, fully operational and
working. I created and configure a queue user for
receiving support e-mails. But is it any possibility to
setup some kind of auto-responder, so it will send back
response back to customer with unique number. I know that
I can assign the number by modifying web-server script,
but may be there is some other way to do it?
I guess, CRM post-callouts is the one of the supported options to achieve
what you need.
> We have CRM system installed, fully operational and
> workin...911: v3.0 and v1.2 appointments
currently we are having problems when synchronzing appointments belonging to
our previous v1.2 environment being upgraded to v3.0. newly created
appointments, done in v3.0, do not face a problem.
how can we identify these old 1.2 appointments (sql script, etc.)?
thanks in advance, fritz
The v1.2 Outlook appointments/contacts/tasks should upgraded over properly
via the v3.0 Outlook Client setup. Did it just affacted the appointments?
Here is a way to list out the v1.2 appointments:
Outlook Calender>>view appointment list (similar to contact list), add
co...Email display name when printing #2
I have one user who all of a sudden has the following print at the top
of emails instead of his name:
/o=xchg/ou=first administrative group/cn=recipients/cn=userid (where
userid is his)
It's a 2003 Exchange server (not SB) and Outlook 2003. He was printing
fine until about two days ago. I've made no changes to the Exchange
server, or to his account whatsoever. The server has been running
flawlessly for over a year, and his account has been on it for that
time. He is running on a laptop in cached mode, but that has also been
the case for over a year. His credentials show up corre...running total of the difference of 2 columns?
need help agai
i want column C to be a running total of (columnA-columnB
a1 =2 b1=-3.5 then C1 should be -1.
a2=4 b2=0 then C2 should be 2.
a3=1 b3=-2 then C3 should be 1.
Anyway i can get column c to do this
Thanks in advance GAME
copy down as far as desired.
In article <35DD505F-1763-4400-B0B9-5EBCDBCFCE07@microsoft.com>,
"Game" <email@example.com> wrote:
> need help again
> i want column C to be a ...undeliverable email #2
I recently started using Outlook 2002 to send email. I've had no proble
till yesterday when my emails were returned undeliverable. The messag
is as follows: "553 Sorry, that domain isn't in my list of allowe
This is the message I get to all emails I now send.
I would appreciate some comments. Thank you.
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...sorting problem #2
I have problems generating a rutine that will automatically sort my
The sheet is in this format (always 2 columns only the rows may vary)
I want it to look like this:
a b c d e
1 2 7 1 7
2 1 3
Anyone know what vba code to use to get this done?
this is not a sorting problem. it's a transposing problem.
I pasted your two columns in a blank workbook and wrote
this macro. the result was what you want it to look like.
in my set up, the two columns of data were in columns a
and b starting at a1 wi...5.6.1 Body type not supported by Remote Host #2
I have a Exchange 5.5 SP4, and I can't receive a messagem
from a certain domain .
In the senders mailbox apears this message:
Final-Recipient: rfc822; firstname.lastname@example.org (this is my email)
Diagnostic-Code: smtp;554 5.6.1 Body type not supported
by Remote Host
I'm not sure if there is something i have to do in my
exchange for accept that kind of message, or if it's a
configuration in the sender's mail server that's needed
i'll appreciate your help
"Felix" <email@example.com> wrote:
...SUM 2 fields and show the result in another
I need sum 2 field values(textboxes) and show the resul in another field.
I´m programming this, but not work..
var value1 = crmForm.all.estimatedvalue.DataValue;
var value2 = crmForm.all.CFCMonto_de_Venta_Servicio.DataValue;
var result = value1 + value2;
What is wrong?, How is?
Have you forgotten to use the complete custom field schema names including
should actually be
crmForm.all.new_actualvalue.Datavalue (if new_ is your custom attribute
"...Is Money technical support superior to Quicken technical support?
I have used Quicken for many years, but I am increasingly
peeved at Intuit for its terrible (and expenseive)
customer support. I'm talking about support when technical
glitches arise in the software. I am seriously considering
switching to Money. But, before I do, I need to know that
Microsoft will provide more effective and less costly
support to Money. I'd like to hear about user's
...Sync 2 public folders on the same Exchange box
Hi Exchange guru's
Is it possible (maybe with a 3rd party tool) to sync public folders on the
same Exchange 2k3 box?
I have a customer runnig a CRM application on a public folder that requires
that a couple of sub folders are copied/sync'ed to the folder of another
public folder on the same Exchange box.
Unfortunately, the InterOrg repl tool doenst support making a double
connection to the same Exchange box
Appreciate your help
UTICA Managed Solutions
On Wed, 18 May 2005 17:34:15 +0200, "Haroun Debbabi"
<haroun_at_debbabi.nl> wrot...xls file #2
I wanted to open a compressed zip file which is an Excel spreadsheet, but
windows could not open it. Apparently I need do download some software to be
able to view this type of xls file. Could anybody help.
You can use WinZip or PKZip to unzip the compressed file. Search
Google for free versions of these programs.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Vee Crossley" <VeeCrossley@discussions.microsoft.com> wrote in
&...Historical Aged Trial Balance #2
The following message comes up on a station ONLY when
trying to print the AP Historical Aged Trial Balance.
Everything else works fine including all reports. The
report prints fine on another machine. Very Strange??
Microsoft ODBC SQL Server Driver [named pipes]
General network error. check your network documentation.
The stored procedure pmHistoricaAgedTrialBalance returned
the following results: DBMS:11, Great Plains 0
The machine is an XP Prof. workstation and doesn't have
any problems in any other application.
...if then formulas #2
I want to set up an If Then formula where:
IF A1= a set of numbers to bet entered by the user, then D2= C2-1
I am new to working with excel and hope this is enough info to answer the
Not quite sure what you want. You refer to "a set of numbers". From that I
deduce that it could be any one of several numbers? If so, then your formula
can read =IF(OR(A1=123,A1=231),C2-1,""). If it should fall within a
specified range of numbers, maybe something like
=IF(AND(A1>=100,A1<=150),C2-1,""). I used the "" as you do not say w...Can not customize outlook today #2
When I click on the Customize outlook today button
nothing happens and I'm unable to select one of the other
I'm using Outlook 2000 and Windows XP Home
Does anyone have a fix to correct this issue?
OL2000: You Cannot Customize Outlook Today After You Install Critical Update
813489 for Internet Explorer:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
Af...Viewing Excel spreadsheets #2
I have created an staffing list with organisation charts in Excel, it runs
to about 40 pages. I need to do a presentation of this info.
Doing the presentation in Excel looks a bit unprofessional, too many
toolbars, space wastage, grid lines etc.
Is there any package (apart from Adobe Acrobat too expensive) or way, that I
can display the spreadsheet in more of a booklet presentation. With a table
of contents, index, better page numbering than Excel, jump to page number,
looks clearer etc. With the possibility of a real-time link between the
spreadsheet and the output source.