Recent content by johnnygeo

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

great, thanks!

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

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

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

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

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

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

Using Office 2000. Oh well. Thanks

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

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

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

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

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

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