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 IamaSherpa 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. Icarus050

    Passing data from Sub to Main report

    Ahha... so this is the bit where you explain how a subreport can share information with another subreport without shared variables and arrays.. Or.. explain your answer better...
  2. Icarus050

    Passing data from Sub to Main report

    ...ok ...you lost me.. What would the 4th subreport consist of? How would having it be different to passing the variables to the main report?
  3. Icarus050

    Passing data from Sub to Main report

    Hi all, I've got a report with 3 subreports, each subreport has ~12 rows and 5 columns: CSQ Name ASA AHT Offered Handled CS 12 456 5848 5754 BS 8 1420 6422 6400 etc.. Basically, I need all of that data in my main report...
  4. Icarus050

    Loop Stored Procedure?

    Hey all. Not idea if what I need it possible.. but here goes. There is a stored procedure which does exactly what I need, but the results it produces are not separated by month (so if I ask for 3 months of data, it gives an over all result, not one split into months). Is there a way I can...
  5. Icarus050

    Search & Display multiple results (Excel)

    Never mind.. I discovered the wonders of Pivot Tables..
  6. Icarus050

    Search & Display multiple results (Excel)

    Ok, here's an example Persons Name | Reviewer Name | Due Date John Smith | TIM | 1-10 | JAMES | 11-20 | AMY | 21-end Joe Bloggs | TIM | 11-20 | JAMES | 1-10 | AMY | 21-end Alan...
  7. Icarus050

    Search & Display multiple results (Excel)

    Hey all, I need to setup a search and results display for a spreadsheet. It looks like so: Persons Name | Reviewer Name | Due Date Names are obviously plain text, and the due date is either 1-10, 11-20 or 21-end. I need to be able to search for all the records with the reviewers name and a...
  8. Icarus050

    Selecting and manipulating a range of text using a macro

    Ahh, you guys rock! MakeItSo, thanks so much for your help.. fumei that worked first time, you have no idea how much time that is going to save me. Cheers. Ic.
  9. Icarus050

    Selecting and manipulating a range of text using a macro

    Ohhh so close.. That puts a border around just the line starting with the #, which, looking at the end result isn't bad at all, but if you've got a lightning fast fix for that too, I'm all ears :)
  10. Icarus050

    Selecting and manipulating a range of text using a macro

    Alright, closer to the right result, option a) skips the first group of text, but then puts one border around all the rest of the groups. Option b) gives me a runtime error of '4120' Bad Perameter on 'Selection.moveleft unit:=wdparagraph, extend:=wdextend'
  11. Icarus050

    Selecting and manipulating a range of text using a macro

    Thanks for the quick response.. Hmm, it found one group of text (the last in the document if that helps with troubleshooting) but then it went into a loop till it used up all 2gb of my RAM.. which is impressive, but not exactly what I was after :) Any ideas?
  12. Icarus050

    Selecting and manipulating a range of text using a macro

    I have a document with sections defined by a line of text with a # at the start. So: # Fri 11 May Subject: Formatting Test This is a test of automatically formatting the extracted text and more testing.. # Sat 12 May Subject: Still formatting text This is the second section. Still the second...

Part and Inventory Search

Back
Top