Reply:

Comment print format
Hello, 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? Thanks, Bob Hi Bob have a look at this thread http://tinyurl.com/3xq6h Frank GT40 wrote: > Hello, > 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? > Thanks, > Bob Frank OP wants the printed comments to not show the Cell:A1 Comment:whatever 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 formulas. 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
Hi This =IF(H2,MIN(10,H2),0) returns the numbers from column H with a maximum of 10. 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 Dave On Mon, 14 Nov 2005 16:43:49 -0000, "Dave 2005" <dave@zillion.karoo.co.uk> wrote: >Hi > >This =IF(H2,MIN(10,H2),0) returns the numbers from column H with a maximum >of 10. > >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
Hi 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 the order. 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> wrote: >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. Kind Regards, Muhammad Hasnain Raja You can't use If and Else in Access SQL. However, the IIf function is the equivalent. IIf(expr, truepart, falsepart) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) <mhraja@gmail.com> wrote in message news:1185887004.782732.108410@k79g2000hse.googlegroups.com... >I am trying to run some SQL script in MS ...

publisher 2003 can't upload site Please Help
Greetings, 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. Error signature: szAppName: MSPUB.EXE szAppVer:...

file association using MFC
Hi there: 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 Biju Here is the code void CChildView::OnFileOpen() { static char BASED_CODE szFilter[] = "Image Files (*.jpeg, *.jpg, *....

Linked Excel table
Hi, 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, Philomen -- Message posted f...

MFG Outsourcing Label
Hi, 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. -- Jim Lines 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? Thanks -- -The Novice Learn Today, Teach Tomorrow Great Success is ones ability to ask for Help. ...

Need help please
Hey all, 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 be appreciated. Have tried removing the PST file, and starting Outlook so it created a new one, but the Personal Folder duplicate is still there. Tx2 <tx2newscollection@hotmail.com> wrote: > Seem to have, by default, 2 lots of "personal folders" which mirror > each ...

accessing outlook data using excel macro
Hey all, 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 "Outlook.Namespace" Any help would be greatly appreciated. Thanks. ...

*HELP* Winmail.dat Attachments Wont Go Away
Hello-- 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 only--nothing works. Please let us know if you have a solution to this issue. Many thanks, Stephen 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
Hi, 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 & mplsgal@mn.rr.com Thanks! 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. Please Help! 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 enviorment. 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 uncancel feature. ---------------- 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 columns wide. rrdiorio, >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 ...