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 strongm 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. bobomutt

    Sum a field across multiple related records

    Both of those were great. I did a check, and in both cases, it only summed up one of the child records (child WO's) so that the total hours for record 12346208 showed as 7 instead of 9. How I corrected this: I added "ID" within the Union selects. Why I did this (no clue if this is correct...
  2. bobomutt

    Sum a field across multiple related records

    Greetings - trying to modify an access table/create a query to compare multiple records against a parent, and sum the values of a field and list only one record - the parent record. The parent record, when one exists for a WO#, is listed in the "Parent" column, and the actual parent record can...
  3. bobomutt

    Powerpoint - multiple sessions - how can I open multiple sessions?

    Hi Jon, That's the ticket! Sneaky way to get around it - I never would have thought of it. Much appreciated, take the rest of the day off. Best regards, Doug
  4. bobomutt

    Powerpoint - multiple sessions - how can I open multiple sessions?

    Hi John - Thanks for the response - no, that isn't what I am looking for, unfortunately. That's what I meant by stretching the application screen out and showing multiple windows - the "arrange all" feature. I want to be able to have two separate instances of PPT open, side by side, similar to...
  5. bobomutt

    Powerpoint - multiple sessions - how can I open multiple sessions?

    I would like to open 2 separate powerpoint presentations side by side, in their own separate application instances. I don't want to have to stretch the application frame out wide and have two separate windows open within the same application instance. You can do this with MSWord & MSExcel, but...
  6. bobomutt

    Excel: Find specific text within a string in a Cell

    Right... it may be surprising to you, but I already searched excel's help before posting. And as far as what I want to retrieve - everytime "J6R" appears within a string in a cell, I want to return "J6R" in another cell. So the first cell that I am searching may have "asdfalsdf J6R...
  7. bobomutt

    Excel: Find specific text within a string in a Cell

    I need to write an equation that I can use to search a cell for a string of text, and if it finds it, return it. Example: If cell A1 contains the text string "J6R Dllser" I want the value "J6R" to be displayed in cell B1. Thanks!
  8. bobomutt

    Displaying Excel Cell values in Text Boxes

    Right, but adding a scroll bar to the chart to modify that value displayed in the text box (referring to a cell in a spreadsheet within the same workbook)is very easy. Which, by the way, fully meets the question I posted. Thanks again for the help. My question has been answered, you both...
  9. bobomutt

    Displaying Excel Cell values in Text Boxes

    Andy - excellent tip, thanks. Exactly what I was trying to do. Best, Doug
  10. bobomutt

    Displaying Excel Cell values in Text Boxes

    Hi Skip, Let me make it a one part question - I want to be able to display a CELL VALUE on a chart. I want a direct link to that cell, displayed not as part of the chart, but like a text box, pasted on top of the chart. Any way to do that? I don't think your explanation does that, although I...
  11. bobomutt

    Displaying Excel Cell values in Text Boxes

    Hi Skip, Pretty nifty methodology. However, I am still interested in displaying a cell value on the chart. For instance, I have a calculated value that I want to display along with a few series on a chart. Best, Doug
  12. bobomutt

    Displaying Excel Cell values in Text Boxes

    How can you automatically display a cell value in a text box? I want to have a scroll bar on a chart that modifies a cell value displayed somehow on the chart (text box is my un-educated best guess...). I want the chart to be its own individual worksheet, and I want to allow users to scroll the...

Part and Inventory Search

Back
Top