Well, I'm looking at a dvd - not planning on getting a new player.
We can come by between classes. Usually I use that time to copy over my class notes with a system of different colored pens. But it's been pointed out to me that that's, you know...insane.
Willow ,'Showtime'
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!
sumi - May 07, 2008 9:41:57 am PDT #6097 of 25501
Art Crawl!!!
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.
Jon B. - May 07, 2008 9:43:56 am PDT #6099 of 25501
A turkey in every toilet -- only in America!
Well, I'm looking at a dvd - not planning on getting a new player.
I must be missing something. You're looking for a DVD *disk* that's multiregion? I don't get it.
t edit and amych's answer still leaves me confused.
amych - May 07, 2008 9:45:04 am PDT #6100 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Not for one, at one -- the South American import version of Alatriste is coded for both regions 1 and 4: [link]
Jon B. - May 07, 2008 9:48:23 am PDT #6101 of 25501
A turkey in every toilet -- only in America!
Ahh! i get it. Thanks. Well, if it says it's coded for Region 1, it had better play on Region 1 players. I mean, isn't that the point?
sumi - May 07, 2008 9:49:26 am PDT #6102 of 25501
Art Crawl!!!
So, it's a standard thing then?
amych - May 07, 2008 9:50:05 am PDT #6103 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
if it says it's coded for Region 1, it had better play on Region 1 players. I mean, isn't that the point?
I'd hope so! I just can't verify for sure, since I haven't used a region-locked player in yonks.
So, it's a standard thing then?
It's not terribly common in the US from what I've seen, but it's always been possible to have any number of different encodings on one disk (or, of course, none).
tommyrot - May 07, 2008 11:49:05 am PDT #6104 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.
ita, did you get the spreadsheet import working?
My boss tried this VB code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "test", "C:PayrollRegister_PE4-4-2008.xls", , "AN3!A1:I100"
...where "AN3" is the sheet name. As long as the Range argument is the same size or bigger than the the data in the sheet, it works OK.
Also, do you know how to call the Windows Common Dialog control (i.e. the thing that lets you browse for the file) from Access?
§ ita § - May 07, 2008 12:03:40 pm PDT #6105 of 25501
Well not canonically, no, but this is transformative fiction.
I basically put those into the actions in the macro, and it worked fine.
Can you force a Windows Common Dialog control in a macro?
No, wait...the worksheet names change every week too--it's a datestamp. It's weird. I'm so far away from VB these days. It's a simple thing--a form with an input field of a datestamp, and a big old button, that when pressed constructs a filename and two worksheet names and goes and imports the data.
I just gotta dip my toe back into the water.
Still, even with the macro needing editing by hand every time it's faster than doing it manually every week. So I may not need to broach my VB fear.
tommyrot - May 07, 2008 12:09:12 pm PDT #6106 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.
Can you force a Windows Common Dialog control in a macro?
Nope. Well, there is an OCX control that might work with a macro, but it sucks. We use VB to do a Windows API call. Sounds messy, but ya' just need to copy a couple lines of code....