Romany777

I have two instances that I would like to send to an error handler: 1. Select Query returns an empty dynaset - what object/property should I be checking and what should I be checking for? 2. I'm inserting images into a form - using OnError if the image file doesn't exist, I can pull in a generic image without any problem - HOWEVER - I would like the module to look in two (or more) places before calling in the generic image. I set OnError to goto a routine that looks for an image in the other place. The first statement in this routine is another OnError to goto the routine to pick up the generic image. If I remember correctly, it hangs in the second routine. What am I doing wrong? Thanks!

I can think of a few ways to do this and none of them involves any macros. The simplest involves creating a column for numbering the records. This will only work if all records have the same number of data field rows. Set a "1" for every field in the first record, and then "A1 + 1" for the first field of the second record and copy to the bottom. Copy the entire column and Paste Values. Then sort by the second column (your original column A) and do wholesale deletions of the unwanted fields - then resort by Record Number and Field. The next simplest involves using text to column (with a ":" delimiter) to separate the Field Names from the Field Data. Set up a short table in another sheet that will contain the field names that you want to keep. Back on the data sheet - use a vlookup (set for exact, not range lookup) to compare the Field Name on the data sheet to the table. If it's not found it will show as N/A. Create column headings for "LOOKUP", "FIELD NAME" and "DATA". Set a data filter on the data sheet and filter to show all instances of N/A in the LOOKUP column. *****SAVE THE FILE****** Highlight the first row (the one with the column headings) and FORMAT ROW HIDE. Highlight the ENTIRE SHEET (only the rows with N/A will be showing) Then set for VISIBLE CELLS ONLY (Edit, goto, special, visible cells only) - then cross you fingers and EDIT DELETE. This will delete all the rows you want. Then highlight the entire sheet and FORMAT ROW UNHIDE. You can certainly practice on a subset of your data to make sure it works. Good luck!

I have an ISDN Modem (Eicon Diva T/A) and a wireless network (DLink). Running XP. When I bought the DLink hardware they specifically told me that I needed a broadband connection in order to share my internet connection. Of course, I've been trying to prove them wrong ever since. I have tried setting up through the various wizards and although I've mastered the wireless network - I still can't get to the internet connection from any of the other computers on the network. Am I beating my head against the wall for nothing? Or is there some way to make this work? I'm not against buying a different modem (this one connects to the PC through a serial port but there's a LAN version that uses Ethernet). As an alternative - if we install a wireless internet connection through our cell phone company - is that going to interfere with the wireless network? Thanks!