Search:

There is an element of truth to that, but it's also utter nonsense. There are people out there saying the opposite. There are HORDES of people with a strong interest in finding and publicizing...

Unlikely. I fully believe you are some Cajun and that you are from Louisiana.....oh wait, maybe that wasn't the part you thought you were unique about!

Ah, that makes sense. It is validating against the existing table. Had I dropped the table, it would have been unable to perform the validation, so it would just run the SQL without the validation.
...

I'm going to go wander around for a week and think about it. That often works.

Yeah, you'd have to write it differently for any variation on TryParse. Those functions return True or False. The converted date, if the conversion works, is returned in the second argument to the...

Gads, you don't really want THAT do you? I'm only working with the darn table because I couldn't think of any other way. The view that I was turning into a table had an insane number of columns....

I can't even SAY it, let alone build it, Glock or no.

Careful with that. I think you are of a similar age to me, though I'm not sure. Sometime after I got out of school, a person tried to study the genetic linneage of dogs and found that they were all...

I quoted that because some typos need to be preserved. It it wasn't a typo, it was one of the better puns on this forum, so perhaps it wasn't a typo. There is nothing quite like Global Warming to be...

I don't think the politicians have much to do with this, other than passing or rejecting whatever law ends up being brought up. For an issue like this, they aren't sitting around in some kind of...

Ok, that sound reasonable. I haven't done anything with temporary tables before and didn't realize that a table that was temporary to me was not a temporary table.

Regardless of that, the...

Yeah, polling is pretty bad.

The event I was forgetting about is VisibleChanged. This one seems to be less sensitive than Activated, but more sensitive that Shown (which happens only once). If the...

Ok, I have now looked at what JA wrote, and there is much that I like about that. However, I also realized a rather critical point that EG made: The threshold isn't the color, it is between the...

I don't like the Activate event, though. It gets fired at weird times. On the other hand, the OP didn't explain anything about what the timer is all about, and without knowing that....anything might...

I'm not sure what Niya is on about, as the timer is not the one dealing with focus as far as I can see.

However, that's a method, so it would have to be called from somewhere, which kind of...

Also like religion: Everybody pretty much believes that we'll eventually find out the truth, though the ones that don't believe feel that they will not really 'find out' anything.

I tend to...

No, not at all, really. When coming up with a novel solution to a problem what we do is anything but logical. It's not some plodding rational process. One moment you don't 'get it', and the next...

Yeah. I just noticed that after I posted the screenshot. I looked at that form dozens of times, but never noticed that one little point before.

By the way, this is a super easy thing to test, since it doesn't harm any existing database. I just ran this query on a totally different DB:

IF OBJECT_ID('TestTable', 'U') IS NOT NULL
DROP...

No transactions in the mix anywhere, but more interesting data:

To track down the problem I was having with the final table, which I mentioned in the original post, I moved a portion of the...

Since I had been working on this when I posted the question, I thought I might as well show what I had working:

100223

You can drag from the repository on the left to the area on the right, or...

Who wouldn't?

There is no stress in programming? I had some a few months ago when I thought I had a logical puzzle that had no solution. I was suffering some severe stress symptoms, which is totally bizarre, as I...

In what country?? We can speak hick pretty fluently out here, but we don't pronounce it that way.




Isn't that the point? If you make an expensive club there'll be lots of people wanting to...

There is no standard for data being passed across serial ports. It is just a series of bytes that can mean pretty nearly anything. If you read those bytes from the serial port, will you know what...

I recently started another thread that got resolved, but this question is closely related:

I have a stored procedure that performs these steps:

1) Create a temporary table.
2) Copy everything...

That's what makes this particular project so interesting. I'm not trying to solve a problem that I fully understand, but trying to provide tools that could be used to solve a more general problem the...

I like .Paul.s answer better than mine. Concatenating in a variable directly is not a good idea, though what I said for Replace would still be kind of ok (though the parameters would still be better).

In VB, one can assume that you will not be typing in a string as in the example, but will be using a variable, right?

If so, you might look at the String.Contains method if you want to determine...

He's got rant control where he lives.

Word!

Normally, you would do something like this in the SELECT statement, as you can provide an alias there. Is that not an option in this case?

Since this is fairly generic, the answer to that final question is: Both!

That's a point I've been contemplating, and the goal is that the form (which will be a tool accessible through a class...

Quite likely, you are communicating via some type of serial device, which may be bluetooth or just a serial cable. For either of those, you would be using the SerialPort object to perform the...

That's a good question. You didn't show a class, though, you showed a sub. If that sub was part of a class, that would likely be the reason, but if you actually meant sub or method rather than class,...

First off, let me just say: Thanks for those ideas, they are all really good.

The goal is a tool that can be used by a few different modules, so I was already intending that there would be a...

Let me be the first to congratulate you. However, considering the state you are in....will you also be an uncle, grandfather, or other relative with this new arrival?

It would take a fair number. Right now, the only 'pile' associated with some of the computers is the pile of stuff on them....actually, now that I think about it, there is nothing on any of them....

Hmm, maybe you ARE me...except for the great idea part, cause I don't have that.

I haven't used Paint in awhile (Paint.Net is free and pretty cool), but I seem to remember that the two colors were the two mousebuttons, with Color1 being the left button and Color2 being the right...