You could try the 'Switch' function. You can read about it in the help system - if you have questions then let me know....

Thanks-- I will investigate. Google and help was getting me nowhere without the right search terms.

As long as the location data is in a table, the function you want is DLookup.

I wouldn't use DLookup in a query except in very special circumstances, as there can be major performance penalties. If the location data is in a table you could just add the table to the query, join it to the main table and get it that way.

OTOH, if the mailing list is small, performance shouldn't matter much.

What happens when you shoot an LCD monitor with a high-powered BB gun: [link]

Cool. Liquid crystal displays really do have liquid in them....

Sean, I think you guys should keep this in mind the next time you have a frag party: [link]

"Why Use Gmail" as told by Gmail Engineers in theater format.

My sister has a dead Dell Inspiron 1000 that she needs to get the hard drive out of to transfer the data to a new computer. Since I've turned internal hard drives into external ones before (on desktops), I offered to do the surgery for her. (She's going to buy a cheap 2.5" USB enclosure.)

Is there anything specific I should know about laptops in general, or Dell laptops in particular? I'm pretty confident I can extract it and put it into a new case once I crack the machine open, but I've only done this on desktops before, and I don't want to frell it up.

I've taken apart more Dell laptops that I can count, and all I can say (this is true for all laptop dismantling) is that you need to keep careful track of all the screws by the order which they were taken out, and their size, otherwise you're going to likely be left with some leftover, which is not a good thing.

For hard drives--I don't know about the inspiron 1000 in particular, as we usually had latitiudes, which were lighter and more economical with space--but in Dells, there is usually a slot-out hard drive. You just need to find where it is, and it's usually one screw that allows the drive to just slide out. Disengaging the drive from that slot is pretty straightforward too.

Good luck.

I've taken apart more Dell laptops that I can count, and all I can say (this is true for all laptop dismantling) is that you need to keep careful track of all the screws by the order which they were taken out, and their size, otherwise you're going to likely be left with some leftover, which is not a good thing.

Fortunately, we won't need to put it back together after I take the drive out, so this part, at least, I'm not worried about.

there is usually a slot-out hard drive. You just need to find where it is, and it's usually one screw that allows the drive to just slide out.

Oh, good to know.

I'd grab the documentation online, Jessica (PDF). Removal of hard drives is a fairly standard procedure, and may be possible without tools at all.

And, really, if you do need tools, at least you don't have to worry about counting screws, since it's not going back together.