Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ben1637
  • Content: Threads
  • Order by date
  1. Ben1637

    Splitting an Excel column into 2 columns

    Hi Everybody, I use Microsoft Excel 2000 and I'm pretty sure what I'm trying to do is possible, but I can't seem to figure out how to do it. I received a bunch of data from a survey that had some open ended questions in a text file. I used Excel to open it and was able to put most of the data...
  2. Ben1637

    Validation List in Excel 2000

    Hi Everybody, I created a combo box in Excel by using the Validation function (Data --> Validation --> List). It's a simple drop-down menu with 'Yes' and 'No' as the two choices. However, I would like to include a blank option so if a person accidently chooses Yes, they could change their...
  3. Ben1637

    Sporadic Printing Problems

    Hi Everybody, I use Acrobat 6 Professional. I am having some very strange, sporadic printing problems that are driving me nuts. Any help and/or suggestions you may have would be greatly appreciated. The PDF was originally converted from Word. It's ultimately several documents pieced...
  4. Ben1637

    CLEAN Function in Excel 2000

    Hi Everybody: I have a spreadsheet in Excel 2000 that has data imported from another system (maybe Oracle?) and I am trying to sort one of the columns. Although the data looks fine at quick glance, when I click on the individual cells, I can see up in the formula bar that many of the cells...
  5. Ben1637

    Variation of BackUp Macro Question in Word 2000

    Hi Everybody: With your help, I was able to modify my macro so it: 1.) saves the file I'm working on to the A:\ drive (i.e. creates a backup of the file) 2.) Returns to the file where I was working on it (i.e. File --> Save As again and switches back to the file on, say, the H:\ drive) I was...
  6. Ben1637

    Macro to BackUp File in Word 2000

    Hi Everybody: I am trying - and failing - to create a macro that will: 1.) save the file I'm working on to the A:\ drive (i.e. create a backup of the file) 2.) Return to the file where I was working on it (i.e. File --> Save As again and switch back to the file on, say, the G:\ drive) This is...
  7. Ben1637

    PowerPoint 2000 Action Settings Colors

    Hi Everybody: When using Action Settings in PowerPoint 2000, how can I customize the color of the "Highlight Click" and "Highlight When Mouse Over" options? The highlight color seems to change when I make the original object a different color, but I don't see how to choose my own highlight...
  8. Ben1637

    Link to Middle of Page in Acrobat 6.0

    Hi Everybody: I am trying to insert a link, bookmark, destination (not sure what) to my PDF so it jumps down to the middle of a subsequent page, but I can't figure out how to do this. What am I missing? In Acrobat 5, it was very straightforward to insert a link that jumped down to another...
  9. Ben1637

    Close Find and Replace Dialog box

    Hello Everybody! I have created a Command Button on a form to Find a Record (using the wizard, Category = Record Navigation and Action = Find Record). It works perfectly in the sense that when I click the button, it opens the Find and Replace dialog box and I can then type in my search...
  10. Ben1637

    Undo track changes in Word 2000

    Hi Everybody! The tracked changes on a very detailed document were accidentally accepted (by clicking Accept All) before the tracked document was saved. Unfortunately, I need to send the tracked version to a client. Is there any way to recapture the tracked changes in the document? I...
  11. Ben1637

    Delete Archive

    Hi Everybody: My company uses Lotus Notes 5. I am trying to reimage the computers used in our training room. Each computer has it's own training id file (.nsf). Since Archiving has been taught in the past, the archive bookmark, settings, etc. have already been established. How can I get rid...
  12. Ben1637

    PDF not displaying properly in Reader

    Hi Everybody: I converted a Word document to PDF using Acrobat 5. Once it was in PDF format, I added links (using the chain button on the toolbar) adding some interactivity to the document. What's strange, however, is that when I associated a link to a picture (to jump to a diff view), it...
  13. Ben1637

    The Form Name is mispelled...Error message

    Hi Everybody: When I launch my Access database, I am immediately prompted with the following error: The Form Name "Form Name" is misspelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's...
  14. Ben1637

    Table of Contents in Word

    Hi Everybody: I am trying to use a concordance file to generate a table of contents in Word. Unfortunately, I haven't done this process before. So far I have managed to successfully create the concordance file and Insert it (Insert --> Index and Tables --> Automark button). However, when I...
  15. Ben1637

    Excel VLOOKUP Problem

    Hi Everybody: How do I change this formula so if an #n/a is returned in one of the lookups, it will still sum the other lookup piece? =SUM(VLOOKUP($J6,$A$5:$G$16,2,FALSE),VLOOKUP($J6,$A$24:$I$37,2,FALSE)) Any help you can provide would be greatly appreciated! Thank you, in advance....
  16. Ben1637

    Adding Hotspots and roll-over effect to large graphic

    Hi everybody: I have a large graphic. I would like to add hotspots to the graphic so various portions of the graphic can act as links/buttons. I would also like to add a rollover effect to the hotspots. Is this possible? In other words, just a portion (the hotspot) of the graphic would...
  17. Ben1637

    Adding hotspots and roll-over to large graphic

    Hi everybody: I have a large graphic. I would like to add hotspots to the graphic so various portions of the graphic can act as links/buttons. I would also like to add a rollover effect to the hotspots. Is this possible in Fireworks (obviously the destination of the hotspot would be set in...
  18. Ben1637

    Adding rollover effects to hotspots

    Hi everybody: I have a large graphic. I would like to add hotspots to the graphic so various portions of the graphic can act as links/buttons. I would also like to add a rollover effect to the hotspots. Is this possible? In other words, just a portion (the hotspot) of the graphic would...
  19. Ben1637

    Multiple IF functions in Excel

    Hi Everybody: I am trying to do a frequency distribution using the [IF , THEN] function. Maybe an example will help - I have a spreadsheet in Excel with health plans in the US and one of the columns has all the states that the health plans have it's services in. We need to put these states...
  20. Ben1637

    Frame: changing link color for active page

    hi all... I have a webpage that uses frames (I know, not neccesarily ideal), but I was hoping you might be able to provide some guidance. The frame is on the left side of the page and is used solely for navigation. When the links are clicked, the content appears on the right side of the page...

Part and Inventory Search

Back
Top