intriguing. thanks for the link!
Bye, now. Have good sex.
Kaylee ,'Jaynestown'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
le nubian - Jul 06, 2007 4:18:33 am PDT #2099 of 25496
"And to be clear, I am the hell. And the high water."
DXMachina - Jul 06, 2007 5:13:09 am PDT #2100 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
I'm sure there are at work hundreds of happy hackers out there looking to unlock the locks, too.
Yup. [link]
Topic!Cindy - Jul 06, 2007 6:17:08 am PDT #2101 of 25496
What is even happening?
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.
Jon B. - Jul 06, 2007 8:10:05 am PDT #2102 of 25496
A turkey in every toilet -- only in America!
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?
Dana - Jul 06, 2007 8:31:36 am PDT #2103 of 25496
I'm terrifically busy with my ennui.
Your laptop charger may well be able to handle dual voltage. I don't know about the toothbrush, but check them, since it's probably cheaper to buy a plug adapter than a converter you don't need.
DXMachina - Jul 06, 2007 11:57:53 am PDT #2104 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
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.
It seems like Apple was awfully quiet about this while folks were standing on line.
§ ita § - Jul 06, 2007 2:28:35 pm PDT #2105 of 25496
Well not canonically, no, but this is transformative fiction.
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.
tommyrot - Jul 06, 2007 2:37:25 pm PDT #2106 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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....
§ ita § - Jul 06, 2007 2:41:04 pm PDT #2107 of 25496
Well not canonically, no, but this is transformative fiction.
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.
tommyrot - Jul 06, 2007 3:06:11 pm PDT #2108 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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.