Editing Footnotes
How can I change how the footnotes appear at the bottom of the page in a document that already exists with footnotes in it? Issues are: (1) Sometimes there is one space, (2) sometimes there is a tab before the footnote text -- both of which I think I've handled in the code below, and (3) in rare occassions, there is no space before the footnote text -- and I have no idea what to do in that case! I want to programatically edit all footnotes to appear with two spaces before the footnote text. Can someone please take a look and advise me (1) have I dealt with the first ...
Adding extra line message in Void Receipt ?
Hi,I 'm trying to add lines to a 'VOID' or 'REFUND' transaction receipts...Customer Name:______________________________Phone No. # __________________________________Signature _____________________________________This addtional line should only be printed if the transaction is VOIDED or REFUNDED. Is there anyone here have made this modification ? I am unable to trap where the VOID header is being called to print so that in the way only I will add this lines.thanks Try making your condition Transaction.Total and/or Transaction.TotalDue. For example...
Cluster Stack Column Line Chart in Windows vs Mac
I created a cluster-stacked column line chart on a Windows machine (Excel 2003) and sent the file to a user on a Macintosh. When the file was opened on the Macintosh, the chart becomes distorted (i.e. axis labels are incorrect, data in columns are missing). Any suggestions for how to fix this? Thanks. ...
Outlook 2003
Somehow I deleted the 'subject' line in my Outlook 2003 mail. I have to change each one individually and enter the 'subject' one by one.Is there any way to do this in one action as I have many many mailboxes and this is going to be a project.Any help would be appreciated.Thank you. You can start Outlook with the /cleanviews command line switch. This will delete all custom views and reset the built-in ones back to their defaults.How to:Start > Run > outlook.exe /cleanviews > OK button'Terri' <terri@mylanusa.com> wrote in message news...
Two lines with a different x-series (please help)
I would greatly appriciate any help I could get on thisI am trying two plot two different lines on the same chartline 1 Line 2X axis Y axis X axis Y axi0 1.32 0 1.38.83 21.22 12.5 23.5I have no problem with the chart accepting the new Y values (as a different series) but as you probably know you can only have 1 catagory x label so my chart does not show the second line extending out to 12.5 it only extends to 8.83 on a different slope and stops. How do I get it to accept the addittional x value and still have to seperate lines? Thank yo Select the data for the second lineChoo...
How do I convert a line chart to a vertical line chart in Excel
data: yr_2007 yr_2008 yr_2009spring 20 75 35summer 60 25 80fall 55 40 100x : year y: value of count want convet to:x: value of county: year x If I understand you correctly, a XY Scatter chart would be the moreappropriate chart. Even though it and the Line chart look similar,the former offers a numeric x axis.On Wed, 19 Aug 2009 20:09:01 -0700, Gerty<Gerty@discussions.microsoft.com> wrote:> data:> yr_2007 yr_2008 yr_2009>spring 20 75 35>summer 60 25 80>fall 55 40 100>>x : year ...
how do i get my workbooks in separate windows?
i need to open my excel application in two seperate windows as they both keep appearing in one window. the tools, options, view, window taskbar thing did not work so i would like to know if anyone has any other ideas.thank you charlene charleneWhat is 'did not work'?If using Excel 2000 there was a bug with the Windows in Taskbar option notsticking when the workbook(s) were shared.Never fixed until Excel 2002 came out.OR do you want to see two actual workbooks side by side in the window?This could be achieved by Window>New Window and Window>Arrange>Vertical....
hovering cursor over footnote number in text
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I used to be able to hover the cursor over a foot/end note number in the document, and a mini window would show me the note text. All of a sudden, my cursor no longer works this way. I don't think I changed any settings, but can anyone tell me how I might fix this? <br><br>Thanks! Check another document: is that the same? You may have converted that footnote to hard text at some point, in which case there is no note text to show. Sorry: I can't think of anything else... On 11/03/10 5:32 AM, in article...
Report toolbar icon has disappeared
I just recently moved our MSCRM and SSRS Database from a SQL 2000 boxto a SQL 2005 box. Somewhere in the process the tiny report icon onthe toolbar for the account and other entities has disappeared.Wondering if this has happened to anyone or if anyone knows how to getthat icon/functionality back. Can you access the reports from workplace->reports?If you cannot see any reports in the reporting grid, the report icon on entities will be gone as well.If that is the case, that probably means upgrading of the report server was not working properly.Min Fan-- This posting is pro...
separate Undo for each individual sheet in a workbook?
Many times I find myself wanting to Undo commands done within a certain worksheet, without undoing other commands that might have been performed in other sheets in the meantime. However, if I have a couple of commands done in one sheet, then some other commands in another sheet, the Undo command will undo them all as if they were in the same list, without keeping track of the sheet where those commands were performed.Does anyone know a way to have separate Undo lists - one for each sheet of a workbook? Thanks!...
How to get the lines in an Excell document to print?
In an Excel document only the text in and above the columns prints. I want both the vertical and horizontal lines to also print. 'Robert-Harry' <Robert-Harry@discussions.microsoft.com> wrote in message news:5117CCEE-AD3B-4B5C-BAE9-D3BB4F49DEE8@microsoft.com...> In an Excel document only the text in and above the columns prints. I > want> both the vertical and horizontal lines to also print.Page Setup-Sheet-Print gridlines..... 'Robert-Harry' wrote:> In an Excel document only the text in and above the columns prints. I want > both th...
Footnotes
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you restart footnotes with Number 1 in each chapter of a document? I also can't remember how to do it, but I would do it by first looking in Word's Help. You can search for 'footnotes' and you'll should easily find the article 'Restart footnote or endnote numbers'. --rms www.rmschneider.com On 12/05/10 13:40, kodnik@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you > restart footnotes with Number 1 in each chapter of a docu...
How can I copy a chart
when I try to copy my chart into a PPT slide, I get a circle with a line in it - and I can't copy. It's like I have read only access but I don't remember doing anything funky...help??!! From XL: Select your chart (make sure its the chart, not a series/legend or plot area) Copy. In PowerPoint: Go to Edit - Paste Special. Select a picture format (probably PNG format, or metafile). -- Best Regards, Luke M *Remember to click 'yes' if this post helped you!* 'Pasqua' wrote: > when I try to copy my chart into a PPT slide, I get a circle ...
How do I add footnotes in Publisher? #2
How do I add footnotes or endnotes to a passage in Publisher? Is it possible? I know in Word you go to Insert->Reference->Footnote, but there isn't a 'reference' tab in Publisher. Hi kgoff (kgoff@discussions.microsoft.com),in the newsgroupsyou posted:|| How do I add footnotes or endnotes to a passage in Publisher? Is it|| possible? I know in Word you go to Insert->Reference->Footnote, but|| there isn't a 'reference' tab in Publisher.Publisher doesn't have this feature. You have to create them manually...usually using superscript etc....
Does MS CRM have to be on separate server?
I have read that in cases where the server machine is running MS Small Business Server, MS CRM cannot co-exist with MS SQL Server or MS Exchange Server.Does anyone know why this is the case or if it can be overcome using vmware or something similar? Hi,it is actually the opposite, the only single box supported configurationwith CRM is with Small Business Server.-- Olivier SchmittMicrosoft Business Solutions SupportCe message est fourni en l'�tat, sans garantie d'aucune sorte, et ne vousconf�re aucun droit. Vous assumez tous les risques li�s � son utilisation.'Stu&...
Changing footnotes to endnotes
How do I change footnotes to endnotes in Word 97? -- Steve Hayes from Tshwane, South Africa Web: http://hayesfam.bravehost.com/stevesig.htm Blog: http://methodius.blogspot.com E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk Not sure about Word 97, but in 2000 and 2003 go to the Footnote reference create dialog, in 2003 this is under Insert, Reference, Footnote, on this dialog there is a Convert button, clcik this and you have choice of Converting All Footnotes to Endnotes, Converting All Endnotes to Footnotes, and Swap Footnotes and Endnote...
Combine varied data from separate workbooks into one chart
I want to combine varied data from separate workbooks into one chart.Data is collected at varied date intervals and level ranges (11/03-2/07) & (0-100). Data begins with 24k rows and is filtered to 1K. Individual charts display daily data labeled as varied mm/dd/yy on the ‘Category Axis’ and 0-40, 0-60 & 0-100 on the ‘Value Axis’. Adding additional ‘Series’ just gives one horizontal line.TIA Here are some guidelines: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html- Jon-------Jon Peltier, Microsoft Excel MVPTutorials and Custom Solutionshttp://Pel...
CCRM Client will not go back on line
When trying to go back online one of our CRM clients tries to snychronize about 100 contactcs and fails with the following message: 'Failed move data for entity 'Contacts' during action salnsert. count Rows=100'When we re-tried we found that the number of Contacts to snych had dropped in half with a corresponding change in the error message 'countRows=50'. The count dropped in half each time we tried to go back online until it reached 5 (with the corresponding error message: 'Failed move data for entity 'Contacts' during action salnsert. count ...
line chart expansion
I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem.Any ideas on how I can fix this? The series that don't expand, is their data in a different workbook? Is the different workbook open or closed? I...
To Do List disappeared
Running OL 07 which is current. Recently, the ToDo list that displays in the To Do Bar has been replaced with the message: 'The operation failed. An object could not be found' What do I need to do to fix this? -- 'Pyramid 36' Ken Restart outlook using the /resettodobar switch. See http://www.slipstick.com/problems/todo_bar_error.asp -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outloo...
In Publisher 2003, convert endnotes to footnotes
How do you convert endnotes to footnoests in Publisher 2003How do you automatically place footnoes in Publishr 2003 In WORD its easy, but can't determine how to do it in publisher.If impossible in Publisher 2003 Is there a Utility that accomplishes this?? jerome <jerome@discussions.microsoft.com> was very recently heard toutter:> How do you convert endnotes to footnoests in Publisher 2003Footnotes and endnotes are both things which don't exist as separate functions in Publisher.> How do you automatically place footnoes in Publishr 2003You cannot.> If imp...
Un-numbered horizontal lines
Thank you for this service, it sure is a big help!!I copied some code that was on this site for horizontal lines in a report. The code works great except the lines are number 1-30. I need the horizontal lines but without the numbers. I tried changing some of the code but I don't understand enough to take the part out that numbers the lines. Below is the code, would someone please help me understand what to take out to change the code to make un-numbered lines? THANK YOU TONS!!!!!Private Sub Report_Page() Dim intNumLines As Integer Dim intLineNumb As Integer Dim i...
separate columns
Hi,I am having a little problem and I was wondering if any of you coulhelp me with it. I have two columns, A (Definitions) and B is empty.Column A has several words in a single cell, I was wondering if theris a way to put only the first word from cell A1, for example, in celB1. Thanks.Regards,Marco--Message posted from http://www.ExcelForum.com Hi Marcos!Try:=LEFT(A1,FIND(' ',A1)-1)-- RegardsNorman Harker MVP (Excel)Sydney, Australianjharker@optusnet.com.au'marksuza >' <<marksuza.16lqli@excelforum-nospam.com> wrote in message news:ma...
Win2K3 NTbackup Creating Separate Files
Hi, I was wondering but how can you create a backup job using NTbackup so that instead of appending backups to a existing file it creates new files everytime it is run? My back up device is a 1.5 Tb hard drive. I want the backup job to create a new .bkf file everytime the job is run and to name it backup122409, backup122509, and so forth. The number would indicate the date that the job is run. I want to do it this way because it's easier to manage mutiple files rather than one gigantic file. -- Thank you for your help! JYC This article should sort it. How to u...
Footnotes
I have a title page for a document with footnotes for each author (4 of them) to indicate their affiliation. I want the footnotes for the text to begin with 1 and then continue all the way through the document (80 pages). However, I have several landscape pages in the document so have had to create several section breaks (thus the restart each section isn't what I want). Is there a way to do this? I don't want to restart each section; I just want the cover page to have separate footnote numbering. I know I can do it by hand, but was hoping there might be a way to do ...