This doesn't sound very user friendly:

The iPhone's battery is apparently soldered on inside the device and cannot be swapped out by the owner like most other cell phones.

Users would have to submit their iPhone to Apple for battery service. The service will cost users $79, plus $6.95 for shipping, and will take three business days.

[link]

It seems like Apple was awfully quiet about this while folks were standing on line.

It seems like Apple was awfully quiet about this while folks were standing on line.

No shit. I'm surprised as hell by it, because it's a pretty obvious ground for backlash.

Where does one start if one wants to dynamically look up (i.e. based on the value in another cell) data in an Access database from an Excel spreadsheet.

::rereads sentence::

I mean, I want to use a value in Excel to look up a corresponding value in an Access table.

ita, I'm assuming you don't want to write VBA code in Excel to do this?

Um, I'm almost positive you can do it. Maybe you'd want to embed the Access table into Excel, and then filter by the Excel field? Or embed a query that takes the Excel field as a parameter?

Hmmm... maybe I'll fire up Excel and see if anything jumps out at me....

Well, if there's a way to not use VBA, I'd rather. But I'll do it if it's the only way, or easier.

Bah. I thought there was a simple, obvious way, but I can't get it to work.

How big is the table (after you filter it, if possible, but before you apply the criteria from Excel)? Because you can imbed an access table or query (maybe on a separate sheet) and then I think Excel has a lookup function you could use against it.

What I tried: I embedded a table, but the "query parameter" option is greyed out. So I created a parameter query in Access, but Excel doesn't like it.

I'll go with the embedding thing on Monday, then.

Thanks for giving it a shot!

"If I purchase TV show episodes from iTunes, do I have the ability to transfer them to my TiVo and watch them on my TV? My TiVo is networked."

This is tricky, Cindy. Tricky for a few reasons:

1) you can theoretically transfer video from the computer to Tivo, but

2) the video has to be in a specific format, with specific naming conventions in order for Tivo to recognize it.

3) problem is: itunes video is proprietary and I don't think you can play it on any other device besides itunes on a computer or ipod.

Can anyone recommend one o' them AC converters that'll let me use my laptop and electric toothbrush charger while I'm in the UK?

You don't really need an AC adapter for your laptops. Both of mine worked fine just using a basic converter: [link] (and hey, you can't beat the price) plugged directly into the wall. The AC adapter you have will handle the extra voltage without a problem--in most cases, it's designed to anyway, and the companies that make conversion kits often will just have you pay for the bit that goes from the adapter to the wall rather than the adapter itself.

Your electric toothbrush, however, will definitely require some kind of power modulator. (Says she who has burned out a battery charger, two phone chargers, and assorted other goodies that needed to be replaced abroad.) I've seen some folks use this one from Sharper Image: [link] and have had nothing but good to say about it, though it's a little pricey. however, I have bought the cheaper off-name ones, and resulted in the above minor explosions, so it might be worth it to you to buy something that has a guarentee behind it. However, I'd almost say don't take the electric toothbrush. It's a fairly delicate piece of equipment when compared to your laptop charger, and less likely to handle the double voltage.

If I purchase TV show episodes from iTunes, do I have the ability to transfer them to my TiVo and watch them on my TV? My TiVo is networked.

To expand on LeN's, iTunes videos generally comes in .mp4, .mov, and sometimes .m4a file formats. While these are not proprietary formats, there is a limitation on where and how the video can be played. I think in your case, it would have to be played back either on a video ipod or on the iTunes of the computer it was purchased on. There is possibly a somewhat lengthy and somewhat advanced method for de-DRMing these formats, but even after you did, you would need to convert them, as LeN says, into a file format that Tivo accepts and will play. Not to mention the transfer time from computer to Tivo.

So while I would say yes, you could transfer them from iTunes and watch them in Tivo, you probably would find it far too much effort for too little payoff.

Thanks for the expansion, SA.

The AC adapter you have will handle the extra voltage without a problem--in most cases, it's designed to anyway

But just in case, make sure it says something similar to "INPUT: AC 100V- 240V~ 1.0A 50 / 60 Hz" on the box (indicating that it can handle varying voltages). When I was last in Europe, all I needed was the plug adapter -- all of my devices were dual-voltage. (In my Treo's case, it even came with interchangeable plugs for continental Europe, the UK, US, and Australia!)