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 Rhinorhino 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. johnnygeo

    I want to use Access ODBC to link t

    I want to use Access ODBC to link to a table on an AS400 database. I can use Client Access ODBC to query these tables, but I want to link to them. I think the trouble is that the table name format is too complex for the link table dialog to handle. For example: the table I want to link to is...
  2. johnnygeo

    Sort/Filter Pivot by Value Column

    great, thanks!
  3. johnnygeo

    Sort/Filter Pivot by Value Column

    Hi, I have a pivot table with 2 row labels (region and category) and a single sum value (cost) column. I would like to show only the rows with the highest total costs. If I try using the "top 10" feature, I find that I can display all categories for the regions with the highest cost, or the...
  4. johnnygeo

    Wipe out all Excel print setup data?

    I have a procedure which toggles a bunch of columns/rows between hidden and unhidden to make a "printable" extract. It runs fine. The problem is that once I try to edit the print setup, such as by defining the print range or using print preview mode, the procedure runs extremely slowly. I...
  5. johnnygeo

    Pointing to .bqy file using ODBC

    Hi, I frequently create Excel spreadsheets that use MS Query to retrieve data from Access .mdb files using an ODBC connection. Is it possible to do the same thing pointing to a .bqy file? I have already processed the queries in the .bqy, so it contains the data I need, this should just be a...
  6. johnnygeo

    "Safe" division function help

    Perhaps I wasn't clear enough. Using my code above, all cases work OK, i.e. without errors, but the successful divisions come out as text. So I actually get: safeDiv(10,5) = "2" safeDiv(10,0) = Null safeDiv(10,0,0) = "0" If, as misterstick suggests, I define the function like Function...
  7. johnnygeo

    "Safe" division function help

    I frequently need to run queries in Access dividing one column by another and I get sick of always having to put the division inside an iif() statement to try and trap out zero values to avoid division by zero errors. So I wrote the following function: Function safeDiv(numerator As Variant...
  8. johnnygeo

    Paste Special in Powerpoint VBA?

    Wow, that is ugly. But it will still probably save me a bunch of time. Thanks!
  9. johnnygeo

    Paste Special in Powerpoint VBA?

    Using Office 2000. Oh well. Thanks
  10. johnnygeo

    Paste Special in Powerpoint VBA?

    I'm trying to write a macro in PowerPoint to perform a Paste Special ... Paste as Picture action. In Excel it works using ActiveSheet.PasteSpecial. But the VB library for Powerpoint doesn't seem to have this method at all. Is there a workaround? Thanks, Johnny Geo
  11. johnnygeo

    find non-#N/A cell in list

    yogia, Thanks, it works fine. For posterity purposes, I changed the type formula to be: =LOOKUP(7,B2:G2,$B$1:$G$1) where B2:G2 are the values for the current row, and $B$1:$G$1 are the type column headers. but what is the significance of using 7 as the lookup value? Is it any numeric...
  12. johnnygeo

    find non-#N/A cell in list

    I have a table like this: Row Y1 Y2 ... Y6 Type 1 N/A N/A 1 6 2 N/A 1 N/A 2 3 5 N/A N/A 1 each of the Y1...Y6 columns contains either an N/A or a numeric value. Only one column will contain a number for each row - the others will...
  13. johnnygeo

    gluing text boxes to connector stencils?

    I'd settle for a mathematical expression to use in the shapesheet to position a connection point exactly on the curve.
  14. johnnygeo

    gluing text boxes to connector stencils?

    I am making a flow diagram that needs to show volumes moving into and out of a series of nodes. I would like to connect the node shapes to each other using line-curve connectors. Each connector should have a text box near each end. I tried editing the line-curve connector master but I can't...
  15. johnnygeo

    How to extend boot drive in Win XP?

    Thanks, guys, but at this point I think I am going to suck it up and go through the Sony recovery process.
  16. johnnygeo

    How to extend boot drive in Win XP?

    Ranish Partition Manager is on the "ultimate boot CD", but it doesn't seem to work with NTFS.
  17. johnnygeo

    How to extend boot drive in Win XP?

    I should also mention that I don't have Win XP installation CDs, just the Sony recovery CDs. I would greatly prefer not having to go through the whole recovery process, though.
  18. johnnygeo

    How to extend boot drive in Win XP?

    I have a Sony laptop with a 40GB hard drive. The drive was partitioned by Sony into a C: (15 GB) and a D: (25 GB), and the C: was rapidly running out of space. I used XP's Disk Management tool to remove the partition, not realizing that it wouldn't automatically extend the C: drive to include...
  19. johnnygeo

    Code to sort Outlook Taskpad

    I am looking for code to perform a custom sort on the Outlook (2000) Taskpad view, the one that is in the lower right of the Calendar window. Every time I accidentally click on one of the column headers, I have to go into customize current view and redo the sort setup - very annoying. Here are...
  20. johnnygeo

    Blackberry Send or Save Page

    Is there any way to save or send a webpage from the Blackberry web browser? For example, if I am reading an article, I would like to save it as a message to read later, when I might not have wireless access. The only options I can see are to send the page address, or save a URL in my messages...

Part and Inventory Search

Back
Top