Apple extended warranty - good idea or not? (A friend is buying a Mac right now.)
Extended Apple Care? Definitely a good idea.
Mercy is the mark of a great man. Guess I'm just a good man. Well, I'm all right.
Mal ,'Shindig'
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!
Sean K - May 07, 2008 7:48:31 am PDT #6089 of 25501
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
tommyrot - May 07, 2008 7:49:54 am PDT #6090 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
OK, she's going with the Apple extended warranty thingie....
Thanks.
§ ita § - May 07, 2008 8:58:38 am PDT #6091 of 25501
Well not canonically, no, but this is transformative fiction.
I'm trying to automate importing a spreadsheet into an Access database, into a table that already exists.
My first angle of attack is creating a macro, using the TransferSpreadsheet action. Problems here are a couple:
- the filename changes weekly, but I guess I can edit the macro every week
- I need information from two worksheets in the spreadsheet, but I can't see how to get anything other than the first one--the help files says it can be done with the Range argument, but doesn't talk about format.
I guess the other option is to do it in Visual Basic and use the DoCmd object, but it's been years since I've been in VB and it skeers me.
Ideas?
tommyrot - May 07, 2008 9:15:03 am PDT #6092 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
I asked one of my bosses - he uses the docmd.transferspreadsheet command, but he doesn't know how to specify multiple worksheets either. My other boss might know - I'll ask him when he gets in.
I happen to have Access 97 open - the help says this about the Range argument for TransferSpreadsheet Action (i.e. a macro):
The range of cells to import or link. Leave this argument blank to import or link the entire spreadsheet. You can type the name of a range in the spreadsheet or specify the range of cells to import or link, such as A1:E25 (note that the A1..E25 syntax no longer works in Microsoft Access 97). If you are importing from or linking to a Microsoft Excel version 5.0, 7.0, or Excel 97 worksheet, you can prefix the range with the name of the worksheet and an exclamation point; for example, Budget!A1:C7.
Does that help? (I'm guessing the same applies for using VB.)
§ ita § - May 07, 2008 9:19:23 am PDT #6093 of 25501
Well not canonically, no, but this is transformative fiction.
Does that help?
That only gets me the first worksheet, unfortunately. I tried putting the worksheet name in, but maybe I need Budget!A1:ZZ99999 or something.
sumi - May 07, 2008 9:31:14 am PDT #6094 of 25501
Art Crawl!!!
Has anyone bought a dvd that plays region 1 and region 4?
(I'm looking at import dvds of Alatriste because I suspect it will never be released here.)
Jon B. - May 07, 2008 9:37:32 am PDT #6095 of 25501
A turkey in every toilet -- only in America!
Has anyone bought a dvd that plays region 1 and region 4?
The Philips 642 player can be easily hacked via a remote code to be region free. It costs around $60. For some reason Amazon is charging $189(!!!), but google Philips 642 DVD and you'll find a lot of reputable dealers selling it for $60ish.
It's a good player too. I've had it for years and it's reliably played anything I've thrown at it.
Jessica - May 07, 2008 9:41:49 am PDT #6096 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
For some reason Amazon is charging $189(!!!)
That's nuts!
I think I bought mine at Target for $64.
sumi - May 07, 2008 9:41:57 am PDT #6097 of 25501
Art Crawl!!!
Well, I'm looking at a dvd - not planning on getting a new player.
amych - May 07, 2008 9:43:22 am PDT #6098 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Sumi, I don't have any dual-coded dvd's, but I've run across a few here at work -- it's a sensible solution for the Latin American market, so I'm surprised that they didn't turn up a long time ago. Of course, all our players are region-free, so I have no idea how they play if you have a region 1 player, except that theoretically they should.