My work's illegal, but at least it's honest.

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!


Sophia Brooks - Feb 02, 2009 1:08:15 pm PST #9038 of 25501
Cats to become a rabbit should gather immediately now here

I am not sure if the camera is on but I think it is. It is set to auto and there is a blinking green light. There are a million other settings-- a book with a heart on it, SCN, a person swimming, hills, a flower,,,so I don't know if there is a special setting for transferring

I have restarted-- is there some sort of order I am supposed to do things in-- like turn the camera on and then plug in-- or plug in then turn the camera on?


tommyrot - Feb 02, 2009 1:17:36 pm PST #9039 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.

Many (most?) cameras have an option to either appear as a simple external drive (what you want) or... something else, that results in the computer loading special photo synchronizing software. Possibly this setting got changed. Can you go through the camera's settings and find this option? (Dunno what it would be called.)

"Auto" I think refers to the camera taking pictures in Automatic mode.

I have restarted-- is there some sort of order I am supposed to do things in-- like turn the camera on and then plug in-- or plug in then turn the camera on?

No, if it's USB it shouldn't matter.

Here's some info: [link]

Ah, this is the problem: [link]

4. Turn on the camera.

Kodak EasyShare software opens on your computer. The software prompts you through the transfer process.

So (the way the camera is set at the moment) you need the EasyShare software already installed. This "feature" needs to be turned off, so the camera appears as a simple USB drive. Hopefully it has that option, but so far I don't see it. If that's not an option, you'll have to pull the memory card and stick it into a card reader that's connected to your computer.


tommyrot - Feb 02, 2009 1:27:02 pm PST #9040 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.

MM, your problem would be ideally suited to do with database software, such as Microsoft Access. Otherwise, you'd need VBA (Visual Basic for Applications) code to do it in Excel. I wrote some code (to brush up on my VBA for Excel skills) - the problem is there's a million ways to do it, and I'm not at all sure my solution is the simplest and/or best suited for what you're doing. (Actually, it's a bit overly complex at the moment.) But it works.

I'm posting it here for you to play with, but I can make adjustments for you tomorrow (and explain how to use it if need be):

Sub findfill() Dim mySheet As Worksheet Dim r As Range Dim rKey As Range Dim i As Integer Dim rLkup As Range Dim rDest As Variant Set mySheet = Worksheets("Sheet1") 'manually set the range to run this program against: Set r = mySheet.Range("a2", "a14") For i = 1 To r.Cells.Count If r(i) = "" Then Set rKey = Cells(r(i).Row, r(i).Column + 1) r(i).Value = rKey Set rLkup = LookupKey(rKey.Value) If rLkup Is Nothing Then 'do nothing - no match found Else Set rDest = Range(Cells(r(i).Row, r(i).Column + 2), Cells(r(i).Row, r(i).Column + 4)) rLkup.Copy (rDest) End If End If Next i End Sub

Private Function LookupKey(vIn As Variant) As Range Dim r2 As Range Dim rRet As Range Dim i As Integer Dim lkupsht As Worksheet Set lkupsht = Worksheets("Sheet2") 'manually set the range for the lookup data to be used: Set r2 = lkupsht.Range("a1", "a10") For i = 1 To r2.Cells.Count If r2(i) = vIn Then Set rRet = Worksheets("Sheet2").Range(lkupsht.Cells(r2(i).Row, r2(i).Column), lkupsht.Cells(r2(i).Row, r2(i).Column + 2)) Set LookupKey = rRet Exit For End If Next i End Function

You'd have to customize it for the range you're running this against and the range of the data on sheet 2 you're looking up. I put comments (i.e. the lines preceded by a ') before the lines you'd need to adjust. Also not that it expects the two sheets to be called "Sheet1" and "Sheet2".

'findfill()' is the subroutine that you'd actually run.


Polter-Cow - Feb 02, 2009 3:48:09 pm PST #9041 of 25501
What else besides ramen can you scoop? YOU CAN SCOOP THIS WORLD FROM DARKNESS!

Surprise, surprise. The culprit in my Internet fiasco was, in fact, motherfucking Norton. I don't know why it suddenly started doing it now, but it has apparently decided it really does not play well with AVG or something. After I disabled it and let the AVG update finish downloading, things worked again. After I enabled it again, the problem came back. So I finally went in and told it to shut up and never come back on again unless I say so. I think the only additional benefit Norton provided me was a Firewall, and Windows XP comes with a firewall. Should I enable it? I don't think AVG Free 8.0 has a Firewall, just a "Resident Shield," which doesn't seem to be the same thing.


sarameg - Feb 02, 2009 4:01:58 pm PST #9042 of 25501

I can't find the url for estimating signal strength/directionality for dtv. It showed by address estimated strengths and whatnot per channel.


le nubian - Feb 02, 2009 4:04:22 pm PST #9043 of 25501
"And to be clear, I am the hell. And the high water."

yes, put on Windows XP firewall.

yeah, I'm not surprised it is Norton.


0 - Feb 02, 2009 4:06:58 pm PST #9044 of 25501

I can't find the url for estimating signal strength/directionality for dtv. It showed by address estimated strengths and whatnot per channel.

omnis_audis talked about it back in April 6, 2008 omnis_audis "Buffistechnology 3: "Press Some Buttons, See What Happens."" Apr 6, 2008 1:15:36 pm PDT

Signal strength website is here.


sarameg - Feb 02, 2009 4:08:40 pm PST #9045 of 25501

Thank you!


omnis_audis - Feb 02, 2009 4:32:50 pm PST #9046 of 25501
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

who is that masked stranger quoting me so well?

Back to the phone thing. Laga, my MagicGate arrived today. You want me to call you on it?


Laga - Feb 02, 2009 4:36:40 pm PST #9047 of 25501
You should know I'm a big deal in the Resistance.

The voip? Sure, call me tomorrow though- I'm at work 'till almost 11. Do you have my home number?