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 Chriss Miller 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: JohnOB
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. 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
  10. JohnOB

    Cell validation only if particular cell not blank

    have a spreadsheet I am using as a form, with validation to allow in cell drop downs. We would like the form to be setup in a way that the users could not fill it out in case the previous section had been completed. Is it possible that the cell could be blank, or locked, until a particular...
  11. JohnOB

    Cell Validation only if previous cell not blank

    I have a spreadsheet I am using as a form, with validation to allow in cell drop downs. We would like the form to be setup in a way that the users could not fill it out in case the previous section had been completed. Is it possible that the cell could be blank, or locked, until a particular...
  12. JohnOB

    Excel Email Macro Trimming Address

    Hi, I am using the below email macro in Excel assigned to a form button, so the user hits the button and the spreadsheet is attached to an email with a specific address in the to field. The macro I am using is (i got it from http://www.rondebruin.nl/sendmail.htm) Sub Mail_workbook_1()...
  13. JohnOB

    Free web hosting that allows Img link

    I was wondering if anyone knew of any free web site hosting services (like Tripod etc) but which let you include an image hosted on their site in your own html, on another site. I want to do this for ebay auctions, using html and having embedded pictures, which need to be hosted somewhere. I...
  14. JohnOB

    Changing Boolean to "Yes" or "No"

    I am trying to recreate a report I have in CR 10 in Reporting Services, I am in BIDS trying to work out how I can have a boolean field which holds 1 or 0 to show as Yes or No, on Crystal reports I could jsut right click the field and choose this option, but I can't find a similar thing in...
  15. JohnOB

    Date format in Report Design

    I am new to SQL report writing services, and am designing a report using the Microsoft Visual Studio add-in that comes with it. I have pulled in the date, using the function =DateString however it is displaying in the format MM/DD/YYYY but I would like it to display DD/MM/YYYY but I cannot...
  16. JohnOB

    Email Size Field Shows Bytes

    We are using Notes 6.5 and in a users inbox the Size of each email is shown in bytes, which is confusing when guaging file sizes. Is there a way of having this size display in a more reasonable frmat, like Megabytes? Thanks "Stupid isn't not knowing the answer, it's not asking the question
  17. JohnOB

    Inserting SQL Query into parts of Report

    I am just starting out using SQL Server Report Services 2005, using the Development Studio to design reports. I am comfortable with Crystal reports, so struggling a bit to get to grips with report services. I would like to be able to have several fields on the report, each containing the...
  18. JohnOB

    Not working since SQL 2005 upgrade

    Our IT just upgraded our server from SQL Server 2000 to 2005, and now my reports (using CR10) are not working, all the fields are coming in as blank. I tried to change the data source but the database names have not changes so there was nothing to change it to. New reports I create work fine...
  19. JohnOB

    SQl Report Writing Books etc?

    We will soon be upgrading our SQL server to SQL Server 2005, and I will be installing this on my machine with usiness Intelligence Development Studio and using this to write reports. I have never used this before and was looking for some books on this, and couldn't see any. I am not sure if I...
  20. JohnOB

    Select Expert NULL date

    I have a date field and I want to use Select Expert to pull in records where the date field is NULL, however when I use select expert I seem only able to enter ranges in dates or higher or lower or equal to a certain date, however I wish to select where the field is NULL, I assume I could do...

Part and Inventory Search

Back
Top