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!

Register Log in
  • Congratulations derfloh 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. pbrodsky

    Comparing Data in Pivot Tables

    It sounds as though you want something like: =IF(AND(total1=total2,total1=total3),"true","false") where total1, total2 and total3 are the totals for a particular person from each pivot table. You could get those totals using a "GETPIVOTDATA" function (look at the help files).
  2. pbrodsky

    server inventory in Excel

    Pivot table then, with a translation table and an extra column with a VLOOKUP added to the data each time the .csv is imported. It's more awkward than using Access but will do the job.
  3. pbrodsky

    HOW TO NAME A FORMULA ON EXCEL

    From the Microsoft help file: Create a name to represent a formula or a constant Show All Hide All On the Insert menu, point to Name, and then click Define. In the Names in workbook box, enter the name for the formula. In the Refers to box, type = (equal sign), followed by the formula or...
  4. pbrodsky

    Can it be done using VBA in Excel?

    What does the link itself (the URL) look like? Does the URL change, and if it changes, are do the changes follow a pattern? Does the service require a login/password?
  5. pbrodsky

    need help-excel 2003 hyperlink in pivot

    I really don't think there is any such built-in feature, and from your description it is not clear how a pivot table fits in. If you describe what you are trying to do, there is probably some way to program it.
  6. pbrodsky

    How to set something in Pixels if have chosen inches for layout?

    A size in pixels only has meaning for bitmapped images, which an InDesign document is not. Presumably if you know the resolution that is going to be used to display the document (not usually something you have control over), you could calculate a conversion.
  7. pbrodsky

    Select All Macro

    Actually, even just cells.select
  8. pbrodsky

    Select All Macro

    activesheet.cells.select
  9. pbrodsky

    Date field changed

    What about a 'createdate' field? From the Word help: Field codes: CreateDate field Show All Hide All { CREATEDATE [ \@ "Date-Time Picture"] [Switches]} Inserts the date and time that a document was first saved with its current name, as recorded on the Statistics tab in the Properties dialog...
  10. pbrodsky

    Removing Update Message from DoCmd.RunSQL

    docmd.setwarnings
  11. pbrodsky

    WORD TOC : Yes / No answer please

    Nwver mind - I forgot that you said TOC.
  12. pbrodsky

    WORD TOC : Yes / No answer please

    Table "Heading Rows" is different from a Heading style. Which are you trying to achieve. If it is setting Heading Rows, I believe it needs to be the entire row.
  13. pbrodsky

    Update Links

    That symptom indicates that files you linked to were either open when you created the links and then saved to different directories, or were originally in the same directory as the linked file and then moved to different directories, or you changed the directory of the linked file. Excel tries...
  14. pbrodsky

    How to change a name in Word

    Look at the help for the "ref field". That might do what you want.
  15. pbrodsky

    Excel 2007 - Page Layout tab - Themes

    Are you working with a .xls file in "compatibiity mode"?
  16. pbrodsky

    long date in shortdate type field mystery

    Is there a way to force access to keep short date in this field?" is not a meaningful question - there is only one kind of date in a date/time field. If you are seeing it displayed differently than you want, you should explain where and how you are seeing it displayed and maybe someone can help.
  17. pbrodsky

    VBA repository or DLL?

    Excel?
  18. pbrodsky

    long date in shortdate type field mystery

    Long date and short date are not field types! Datetime is the ONLY type of date field. Long date and short date are display formats and have nothing to do with what is in the field. Also, it is probably not a good idea to use Date as a field name - that is a word which has meaning in Access
  19. pbrodsky

    Excel: adding / subtracting times, and "negative time"

    input the time as 4 digits - no delimiter. Then you can use a formula such as "=TIMEVALUE(LEFT(TEXT(B7,"0000"),2) & ":" & RIGHT(TEXT(B7,"0000"),2))" to convert it into an actual time value.
  20. pbrodsky

    Excel 2007 Bug reported and verified

    I ran across a discussion of a bug in Excel 2007 the other day on the Woody's Lounge website. The following is Microsoft's posted response to the bug report: ----------------------------- Calculation Issue Update Yesterday we were alerted to an issue in Excel 2007 (and Excel Services 2007)...

Part and Inventory Search

Back
Top