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

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

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

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

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

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

I am using VB to read in the contents of an Outlook mail folder which is stored in a separate .pst file. I am able to read emails in from my inbox and from subfolders of my inbox, but I can't see how to get to a folder in a different folder set. The folder name is "SurveysUnprocessed" and the...

Is there a way to print a Visio (2000) file such that each printed sheet contains 2 (or 4 or 6) pages from the file? Hitherto I have been copying my Visio pages to Powerpoint and using PP's "print handouts" to do this. But I would much rather do it straight from Visio if possible. Thanks...

I am trying to automate some mapping functions in MapPoint using VBA. I have a function that sends an address to MapPoint and uses the FindResults method to return a map location. What I would like to do is have the function return the Lat/Long coordinates of the location. Anyone know how...

I have a protected spreadsheet (Excel version 2000) with a form button. The user reported that his button had disappeared. I opened the file, and sure enough, no button. I unprotected the sheet, and tried to add a new button using the forms toolbar. The whole toolbar is grayed out. Other...

I have an Excel file that I need to save copies of into several hundred folders within a tree structure. The master Excel file is at the top of the tree, and each copy has to be saved 5 folders down. Rather than explicitly state the folder names, I had hoped to use the VBA Dir statement to...

I have a custom worksheet function which will perform a vlookup from an external Excel file. The specific external file will depend on the parameters passed to the function. The simplified code below works great as long as the external file is open. It does not work if the external file is...

I have an Access DB which sends a survey out to users as an HTML POST form embedded in an Outlook email. When the user submits the form, it sends a reply email with the form data in an attached file POSTDATA.ATT. This file is a very simple text file which I was hoping I could read into the...

I am using Access to create and send an Outlook mail item. I have a table containing email addresses to use for the recipients (in user@domain.com format). I need to make sure before I send the email that the addresses have been matched to the Exchange address list. In other words, if I were...

I have an Access 2000 db which generates an html output file. Rather than store my images as OLE objects, I am storing the path to the image files as text. I have a form for maintaining the data, and I would like to display the images on the form. How do I get from a filename as text to an...