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 Mike Lewis 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: *

  1. JohnOB

    Words Split Between Lines - CS4

    Spamjim that's great thanks for your help will make sure to avoid doing it manually from now on. Thanks again. "Stupid isn't not knowing the answer, it's not asking the question
  2. JohnOB

    Words Split Between Lines - CS4

    Hi All Not sure what it is called when a word is split between two lines, so you have some of the word at the end of one line and the rest of the word at the start of the next, but does anyone know if there is a way of stopping this happening in text frames in Indesign CS4? So that it makes...
  3. JohnOB

    Excel Email macro

    Hi All Hope someone can help me with the below I have been looking for examples of code to try and help but with no luck. I want to have a button in a spreadsheet which when clicked will open a new email. I do not want the file attached to the email, however I would like the contents of some...
  4. JohnOB

    Including Database Fields in URL

    I am trying to setup a link to a web based mapping system from an SQL Reporting Services Report. I right-click the field and choose Properties, then click the Navigation tab, I click the option "Jump to URL" and am trying all permutation of possibilities for having the URL along with the...
  5. JohnOB

    Parameter Problem

    Think I worked this out in the SQL code I entered "WHERE "Proeprty.PropertyID" = @ParameterName Thanks "Stupid isn't not knowing the answer, it's not asking the question
  6. JohnOB

    Parameter Problem

    I am quite new to reporting services having used CR in the past, and have almost completed my first report. My problem is selecting my parameters. I want the user to enter our unique PropertyID in the parameter field, and for the report to show only the values for that Property. I can get the...
  7. JohnOB

    Excel - Conditional Format Cell based on previous cell

    Thanks Loomah, the first formula seems to work perfectly this was not a function that I had heard of before. I control the contents of the other cell with data validation so I know the same case will always be used Thanks again Regards, John "Stupid isn't not knowing the answer, it's not...
  8. JohnOB

    Excel - Conditional Format Cell based on previous cell

    I am trying to work out how to use conditional formatting to shade a cell if the cell to the left of it contains the word "full". It will contain other text so for example may say "annual leave full day" or "full day training course" etc. I have tried various combinations but no luck so far...
  9. JohnOB

    Excel - Email File Path

    Hi I have been struggling trying to figure out how to do this and wonder if someone could help. I would like to have a button in an excel spreadsheet that when pressed would launch a new email, that had a subject and the body of the email contained the file path of the spreadsheet, and it was...
  10. JohnOB

    Resize Image

    Or what I do is create a new document with a canvas size the size you want your final image to be (185x71) and then import your original onto the canvas, and resize it till you can see enough of the content in your new canvas, this way you are maintaining the scale of the original so not losing...
  11. JohnOB

    Retaining Contents Links From Word

    It doesn't, not for me anyway, which makes me think this is perhaps due to my version of office (2000) as I have saw this menu on other PCs running higher Office versions. "Stupid isn't not knowing the answer, it's not asking the question
  12. JohnOB

    Retaining Contents Links From Word

    I am using Adobe Acrobat 9 Pro, and MS Word 2000. I have a word document that has a table of contents, but when I convert it into a PDF I lose the links from the able of contents, so the users cannot click on the Contents heading to jump to the relevant page. I was on a course recently and...
  13. JohnOB

    computer screen jumping up and down-Total Novice

    I mean lift the mouse of the desk. "Stupid isn't not knowing the answer, it's not asking the question
  14. JohnOB

    computer screen jumping up and down-Total Novice

    If you have an opticl mouse, it could be this, next time try lifting it off the desk to see i it stops. "Stupid isn't not knowing the answer, it's not asking the question
  15. JohnOB

    Mouse cursor jumping over text

    Are you using a wireless mouse? "Stupid isn't not knowing the answer, it's not asking the question
  16. JohnOB

    List all empty folders in a directory

    Smah, that worked like a charm my thanks to you!!! Regards, John "Stupid isn't not knowing the answer, it's not asking the question
  17. JohnOB

    List all empty folders in a directory

    Thanks snah the xcopy /t switch sounds like the ideal solution. The directory is 14/8GB with 2,583 folders, though this would be a one off thing. My plan was to do as you suggest, then dir the list of folders from both directories into a spreadsheet, then use access to compare them. However...
  18. JohnOB

    List all empty folders in a directory

    Does anyone know how to list all empty folders in a directory (or see them ordered by size, so I could easily spot the empty ones)? Tried all kinds of searches, and dos things but can't think of anything else. Thanks John "Stupid isn't not knowing the answer, it's not asking the question
  19. JohnOB

    List empty folders

    Think this may be a DOS issue though not sure, does anyone know how to list the folders within a specific directory that are empty? Using Xp Thanks "Stupid isn't not knowing the answer, it's not asking the question
  20. JohnOB

    Cell validation only if particular cell not blank

    Thanks Skip This sounds a little beyond me so what I decided to do instead was use conditional formatting to set the text colour to white, if the previous cell was blank. So allthough the user could see the drop down, then the made a selection it did not appear, and was not visible on print...

Part and Inventory Search

Back
Top