Search results for query: *

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.

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

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.

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

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

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