Comment print format
I am trying to change the text that says Cell: Comment:
when I print my Comments at the end of my form. Is this
text embedded by Microsoft?
have a look at this thread
> I am trying to change the text that says Cell: Comment:
> when I print my Comments at the end of my form. Is this
> text embedded by Microsoft?
OP wants the printed comments to not show the
The codes at your URL just change the on-sheet comment format, but the printed
...Margin is out of page when open using Excel 2003
All my excel file which saved on Excel XP are out of order when open using
Excel 2003. Please advise!
...Orphaned Links -- HELP!
Mac PowerBook G4, 2 GB RAM running Excel 2004
I copied a range of cells into a a new worksheet in a workbook. Now I've got
a mysterious link I don't want somewhere on the copied range. I cannot find
any external links in the copied cells -- they are all numbers and text, no
I've tried Edit|Links|Break Link but it doesn't work.
I tried moving the new worksheet out of the old workbook. When I try to save
the old workbook without the new worksheet, Excel asks me if I want to save
the link to the new unnamed worksheet. I have the options of OK and Cancel.
I hit Cancel,...Need Help #9
This =IF(H2,MIN(10,H2),0) returns the numbers from column H with a maximum
The formula is returning 10 if the cell is 10 or over, is something wrong.
Question: I need it to return 0 if 10 or over.
Microsoft Excel 2002
Thanks in advance
On Mon, 14 Nov 2005 16:43:49 -0000, "Dave 2005" <email@example.com>
>This =IF(H2,MIN(10,H2),0) returns the numbers from column H with a maximum
>The formula is returning 10 if the cell is 10 or over, is something wrong.
>Question: I need it to return 0 if 10 or ...urgent , display to print
on a landscape print i would like to print text example "excel statistics" on
left but vertical. when i print i would like it running from the top to
bottom on the left, instead of starting where the data in the sheet starts. I
mean when i print this way it leaves a gap at the top and bottom but i would
like it without the gap covering like a heading on the left side of paper.
Do i need to use something like a clip art or anything else to achieve this
? Any help will be great. thanks
I think I'd use another application (MSWord) and print that separately. Then
send the ...badly need some help on CRM customization
badly need some help on CRM customization. I need to add an additional
account lookup field to the sold product. We sell software and we need
to track end users (40% of buyers aren't the end users), so i want to
be able to set an end user (to attach an account) to each product in
Yes I know that 1.2 doesn't support custom lookup fields but i need to
transfer all of the data from our current customer database and i want
it to be accessible from one interface.
I wonder if i can create a field in the SalesOrderDetail table to store
accountid (uniqueidentifier type), map i...Need help writing an update query
I'm not good at this so I need some help. Here's what I want to do. I have
two tables with fields that need linked to add an update. To show what I
want to do I have put the table and fields in brackets. Thanks. Here it is:
If [Status Table:Status=Sold or No Bid] and [Status Table:Date=1/11/2008]
then in [List Table:Publication Fee] enter [$30.00]
On Tue, 22 Jan 2008 17:23:17 -0800, Rick <Rick@discussions.microsoft.com>
>I'm not good at this so I need some help. Here's what I want to do. I have
>two tables with fields that need linked to add a...How to print information on the front and back of 1 page
...Using SQL in MS Access 2000
I am trying to run some SQL script in MS Access 2000 for creating
query. But its not take 'IF' and 'ELSE' command. Can someone guide me
that how can I use IF and Else in MS Access 2000.
Muhammad Hasnain Raja
You can't use If and Else in Access SQL. However, the IIf function is the
IIf(expr, truepart, falsepart)
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
<firstname.lastname@example.org> wrote in message
>I am trying to run some SQL script in MS ...publisher 2003 can't upload site Please Help
I have tried to upload my 2003 publisher website for 4 hours. I know how to
use ftp, I know how to use http due to the wonderful directions I found
through this website. When I use FTP I get 'Publisher could not save the
fiel to the Web. Check your URL or network connection'. I check them and
they are fine. When I use HTTP the programs stops responding, the page goes
white and this can be verified by ctrl alt delete and you can clearly see the
writing not responding. After I get it shut down I get a error report.
szAppVer:...file association using MFC
I am in the process of leaning VC++ MFC. I have written a
program wthat will display the complete path for the
selected file name from open dialog box. Now I would like
to associate my program to a file type.. lets say .jpeg
files. When I double click on any .jpeg files I would like
to have may program open and display the complete path.
I know it has to do something with DDE. Can somebody point
me to the right direction.
Thanks for your help
Here is the code
static char BASED_CODE szFilter =
"Image Files (*.jpeg, *.jpg, *....Linked Excel table
Hope someone can help me. I have weird printing problem that I can'
seem to fix! Here's the story ... I am using Windows XP and Offic
2003. I link excel tables into a word document (paste special/as link)
There is color font in the excel table. The color always appears on th
screen, but disappears when I print it to pdf or printer, *but onl
from certain PC's* Hence, the problem! I've compared the settings o
Word and Excel between the PC that can print the colored text and th
ones that cannot. To no avail. Any help would be appreciated. Thanks,
Message posted f...MFG Outsourcing Label
I am using the Machine Fixed Overhead as my Outsourcing bucket and have
check the box in WIP Preferences to "Rename Selected Cost Bucket as
'Outsourcing'". However, all of my labels still refer to Variable Overhead
and not Outsourcing.
I've switched it on and off with no success.
Thanks in advance.
Sr. Microsoft Dynamics GP Applications Consultant
Certified Microsoft Dynamics GP Specialist
The option does not always work as described. It does use the selected field
for Outsourced costs, it just does not change the label.
Richard L. Whaley
...Adding Multiple Reports using SendObject
I need to send Multiple reports in a *.SNP Format. Can anyone guide me as to
how this can be done?
Learn Today, Teach Tomorrow
Great Success is ones ability to ask for Help.
...Need help please
I am running Outlook that came with Office XP - 2002 I believe?
Anyway, yesterday, I installed a new motherboard, and ended up having to
reformat and install XP Pro SP2 clean.
Thought I would get away with just a repair install of XP, as this has
worked for me in the past, did not this time, so stupidly I was not as
prepared as I would have liked to been.
I have a backup, image that is, saved on an external usb drive with Drive
Image 7. It is my hope, to be able to get to my Outlook folder, using Image
Explorer built into Drive Image.
I have reinstalled Outlook from Office XP...2 Personal folders, using Contact Manager
Installation is Outlook 2003, installed from the Small Business Edition
of Office 2003, also having Contact Manager installed.
Seem to have, by default, 2 lots of "personal folders" which mirror each
other in every way.
A clue as to why, and what to do to remove the superfluous folder would
Have tried removing the PST file, and starting Outlook so it created a
new one, but the Personal Folder duplicate is still there.
Tx2 <email@example.com> wrote:
> Seem to have, by default, 2 lots of "personal folders" which mirror
> each ...accessing outlook data using excel macro
I'm very new with all of this, however, my problem is this:
I have a bunch of data in excel which I then want to compare to certain
"task" fields in outlook (ie. the "Due Date" column in Tasks for example),
then update those outlook fields with new data. I was able to do it in an
Outlook macro, but not in the Excel macro. I get a "User defined type not
defined" error when trying to define a namespace variable as
Any help would be greatly appreciated. Thanks.
...*HELP* Winmail.dat Attachments Wont Go Away
Our EVP is trying to email to our legal council and a couple of our BODs
(all of which have AOL as their ISPs) and her Word docs and Adobe PDF
attachments are being received as winmail.dat files.
We are using Exchange Server 2003 Standard and Outlook 2003. We have read MS
articles and Symantec articles and have changed her to plain text
Please let us know if you have a solution to this issue.
Where did you change it to plaintext only? Go into outlook and do it there,
where you can do no bold underlining NOTHING, if you do it from the...Printing a cash-flow schedule
I was wondering if it is possible to print, from Cash Flow view, a list of
upcoming transactions? I've tried the Account Transactions report (setting
the time frame to the next 30 days) but it doesn't include scheduled items.
Even if I could resize the chart so I could view more upcoming transactions
and do a 'Print Screen' that would be ok.
...Can't print bank account number on checks
I'm using Money 2005 and I can't get any of my
information to print on my checks (my bank name, address,
checking account number, etc), but I can get all of the
payee information to print...Can anyone help me?
Email responses here & firstname.lastname@example.org
In microsoft.public.money, Lee wrote:
>I'm using Money 2005 and I can't get any of my
>information to print on my checks (my bank name, address,
>checking account number, etc), but I can get all of the
>payee information to print...Can anyone help me?
See FAQ available at http://umpmfaq.info/faq.h...Using an IF statement, based on 2 COUNTIF results (I think)
I'm using Excel 2003 so I hope I'm not limited here.
We are performing a space usage survey and I need to compile the data
results. Each location has 70 entries over the course of 10 days. I have a
column for "group work" where the value is either 1 or 0. I have another
column for # of people observed in a particular office. What I'm trying to do
is the following:
Get a count of instances where "# of people" = 1 and "group work" = 0
I'm doing a lot of countif statements, but I don't see how to do a countif
with an and operato...line-column charts
I charted 5 lines of data (8 data points in each line) in
a combination chart (line-column) with one axis. It
defaulted to 3 lines of data displayed as columns and 2 as
lines. Is there a way to easily identify which data
sources I want in column format and which appear as
lines? I tried to select one of the lines and change the
chart type to "column", but the column displayed on top of
the other three. I was able to use this same approach to
solve my problem by creating a column chart and change the
one data set to a line chart, but I was hoping for a way
to format data...HELP!!! Migrating to Exchange 2000 Exchange2k Setup always Fails! (REVISED)
I posted this before but here is a clearer explanation of what's going on.
I have gone throught the procedure below 5 times now this is not a fluke.
I thought this would make things easier.
This my test lab setup procedure from scratch.
WHAT AM I DOING WRONG?!
1) Clean install NT4 PDC SP6a (with underscore in
domain name to simulate production enviorment)
2) Clean install of NT4 as Member Server SP6a
3) Clean install of Exchange 5.5 and SP4 using domains
built in admin account to simulate production
4) Build a few mailboxes and user accounts, I don...A way to Uncancel a contract line
There needs to be an "Undo" feature when cancelling a contract line - or an
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=5fd28234-3c50-49c8-b...How to print multiple worksheets in one workbook on the same page.
I want to create a worksheet that have a different number of columns in
different sections. If I create a new worksheet for each section, can I
print multiple worksheets on the same page within the same workbook?
Can I use different column formats within the same worksheet? For example
the top part of my form is only 4 columns the sections to follow are 5 to 7
>I want to create a worksheet that have a different number of columns in
> different sections.
Not if they're above/below one another.
> If I create a new worksheet for each section, can I