Posts by Reverend Jim

In the form load event handler just add the code to put the label in the proper container. You can set the transparent property there at run time or in the designer.

It works for me. What version of vb are you using (I am on vb 2010)? If you added the code after double clicking the picturebox then the code won't execute until you click in the picturebox at run time. Try putting it in the form load handler.

The hyoid bone is the only bone in the human body that is not connected to any other bone.

If you keep your database in RAM then you could set it up for replication to a database on disk so that you would have a permanent version in case of failure. As an alternative to configuring the DBMS to use RAM, you can also create a RAMDISK, then create that particular database on the RAMDISK. One option is a free program from SoftPerfect which is available here. One of the options with this program is to make the disk permanent. With the permanent option, when you unmount the disk, the contents are saved to an image file which is reloaded when you remount the RAMDISK. This would be appropriate if your application is not required 24x7.

Tic Tacs are labeled as sugar free even though they are mostly sugar because a single serving (one Tic Tac) contains less than 0.5 grams of sugar.

The same logic allows Pam (basically aerosolized fat) to be marketed as fat free.

Of course we are. We've put in the time and we've earned the right.

I've done the same. For the shows that are the worst offenders I just record and zip through the breaks. I don't understand the logic. For the dramas, they take the time to create a reality in which we get sucked into the lives of the characters, then they constantly remind us that it's all pretend by flashing popup ads and taking us to commercials every 5 minutes. And for some other shows, they take 30 seconds before the break to tell us what's coming up after the break, then after the break they either replay what was shown before the break or give us a recap. They can't possibly believe that the audience has the retention of a goldfish so the remaining possibility is that the creators of the show are so lacking in creativity that they have to pad 20 actual minutes of content out to 42 minutes of air time. I suppose if people are willing to watch then who can really blame them. If I could get paid twice as much for doing half the work I wouldn't be complaining.

Yes. It works.

The 40-43 minutes is what is left after you take out the commercial breaks. You subtracted them twice to get your figure of 25 minutes. Of course, during the actual show they continuously pop up promos and other ads on the bottom of the screen.

If you have two arrays

Dim array1(5) As Integer
Dim array2(10) As Integer

then after the loop executes they will have the values

array1 = {1, 2, 3, 4, 5}
array2 = {1, 2, 3, 4, 5, 1, 2, 3, 4, 5}

which is what you said you wanted.

Please start a new thread for this question.

By the way, a simpler Sub for displaying the control hierarchy is

Private Sub printControls(ByVal ctrl As Control, indent As Integer)

    Debug.WriteLine(Space(indent) & ctrl.Name)

    For Each child As Control In ctrl.Controls
        printControls(child, indent + 2)
    Next

End Sub

and you call it with

printControls(Me, 0)

Your problem is that txtA1 (and the other textboxes) are not contained in Me.Controls. Each textbox is in a panel and the panels are in Me.Controls. Why not eliminate the panels and just put the textboxes directly into Me.Controls?

Could you possibly change the chat notification to something a little more eye-catching? I've been on daniweb several times today and never noticed that someone had posted a message the evening before. Changing the text color from white to dull orange just isn't doing it. How about changing the background color for Chat from purple to red?

Or

For i = 0 to 4
    array1(i) = i + 1
    array2(i) = i + 1
    array2(i+5) = i + 1
Next

24x7 means 24 hours a day and 7 days a week. Our network was used by the people running the provincial electrical grid. Outages were not an option.

You have to see the Grand Canyon, and if you get the chance, hike around a bit outside Sedona. My brother has been to the Painted Desert and says it is spectacular.

I hear they just bought out Oculus Rift for $2 billion ($400 million cash plus Facebook stock).

Instead of doing

rst.AddNew()

use an insert query which looks like

INSERT INTO tablename (fldname1, fldname2, ...)
VALUES (value1, value2, ...)

Then you do the insert by

cnn.Execute(qry)

Keep in mind that for non-numeric fields you have to put single quotes around the values. To retrieve and display data in a listview you can do

rst.Open("select * from Customer", cnn, 1, 3)
ListView1.Items.Clear

While Not rst.EOF
    ListView1.Items.Add(New ListViewItem({rst("CustomerID").Value,
        rst("FirstName").Value,rst("LastName").Value,rst("Address").Value,
        rst("ContactNo").Value,rst("Email").Value,rst("Status").Value})
    rst.MoveNext
End While

For the first question, the format of the query should be

SELECT * FROM Register
 WHERE Username = 'somevalue'
   AND Password = 'somevalue'

and because in some databases, password is a reserved word, you may have to code it as

SELECT * FROM Register
 WHERE Username = 'somevalue'
   AND [Password] = 'somevalue'

CF-18 for sure.

Can you zip the project and post it here?

Even though I helped manage a network of a couple of dozen servers, I am not a network person. I would have no idea as to the proper way of setting up such a network. Having said that, I will add that there is no way to determine if your network is "correct" because configuring a network requires knowledge of its potential use. Among other things, you would need to specify

1. the number of users
2. the type of use (load, data requirements, etc)
3. nature of the network

By "nature" I mean, is the network required to be available 24x7? Is the data critical? How long is it acceptable for the network to be unavailable. Such things determine replication requirements, communication requirements, etc. Our system required separate network paths for user use, replication, heartbeat, etc.

They are like whiny babies

I've learned from discussions with Mike that they are not, in fact, whiny babies. Don't confuse what the English media allows you to see, with reality. History is written by the side that wins. What you and I were taught about Quebec is most definitely slanted. Compare what most Americans (and Canadians, for that matter) were taught about North American history with Howard Zinn's A People's History of the United States.

Here in Manitoba we have had grievances such as when contracts were awarded to Quebec companies when Manitoba companies had a lower bid and were equally qualified. I don't fault Quebec for that. I blame Mulroney who awarded the contract for political reasons. He was buying support.

I suggest you run the program in the debugger and when it breaks on the error, add Me.Controls("txtA1") to the watch list and verify that it exists at that point. If it does, then add Me.Controls(name) to the watchlist as well.

It makes a nice companion site for 99 bottles of beer on the wall

My e-reader (on the laptop) allows me to add "sticky" notes. Having my computer reference books in eform allows me to use Search to find things more easily. Also, if I have to help a friend I can just load up my reference books on a USB stick and tote it along, or even take along the laptop.

The above code is incorrect. If you use

If number1 > number2 Then
    FindLargestNumber = number1
ElseIf number2 > number1 Then
    FindLargestNumber = number2
End If

and you call it with

FindLargestNumber(12,12)

it will not return a value. Use

If number1 > number2 Then
    FindLargestNumber = number1
Else
    FindLargestNumber = number2
End If

A string of the form "MM/yyyy" is not a valid date. A valid date has day, month and year parts.

You should set

sngTotal = 0

just prior to

For intCounter = 0 To 2 

And you should probably change the loop to

For intCounter = 1 to 3

You should also validate the entered grade to ensure that it is a number and falls in the range 0-100. You can omit the test

If intNumScores > 0 Then 

Because you are doing

Do Until intCount > intNumScores

and because intCount starts at 1, you are guaranteed that intNumScores will never be zero.

Just because you do

Dim txt As TextBox = Me.Controls(name)

doesn't mean that txt is set to an existing object. If name doesn't exist then txt will be set to nothing and you will get the error. I suspect you are not creating the control name properly. Print out the control name using Debug.WriteLine before you try to retrieve it and that will tell you the name of the (non-existing) control that is causing the error.

I tested the query on a sample database and it worked just the way you want.

What are we supposed to comment on? You didn't offer any explanation.

 CURTIME([fsp])

As of MySQL 5.6.4, if the fsp argument is given to specify a fractional seconds precision from 0 to 6, the return value includes a fractional seconds part of that many digits. Before 5.6.4, any argument is ignored.

In MS SQL you can do

SELECT TOP 5 * FROM myTable ORDER BY NEWID()

I believe MySQL has this feature as well. NEWID() generates a globally unique identifier (GUID) in memory for each row. By definition, the GUID is unique and fairly random.

Try

SELECT * FROM Table
 WHERE DateDeleted < '2014-02-12'
    OR DateDeleted IS NULL

"World peace, like community peace, does not require that each man love his neighbor. It requires only that they live together in mutual tolerance, submitting their disputes to a just and peaceful settlement."

John F. Kennedy

They just don't have a viable alternative. To get a tad off topic, here in Manitoba we have the PCs, and the last time they were in power they sold off a crown corporation (after promising during the election that they wouldn't) and the NDP (currently in power) who go from one fiasco (illegally raising the PST) to another (illegally awarding a helicopter medivac contract). A medivac in BC or Alberta costs approximately $8000. Thanks to the new contract, here in Manitoba the cost is $49000.

I am concerned about Peladeau in Quebec running for election. Way too much influence and exposure.

we'll still be friends ;)

I'd expect nothing less ;-) The reason I started the thread was to get some insight about the situation that wasn't being filtered through the media. You never disappoint.

Big hair and bell-bottoms. Yecch!

This is likely to be of interest to only the Canadian members of DW, but I would like to hear anyone's thoughts about the upcoming Quebec election and the possibility of another referendum, especially in light of recent setbacks in Scotland's move toward indepenedence.

A little more information please.

If you click the "?" in the edit bar or go here you'll see how to quote and use the other markdown featured.

Just have a look at the output from Sysinternals' Filemon to see what it is possible to detect.

A travelling salesman drives into a farmer's yard. As he gets out of the car, he notices a three-legged pig walking through the lawn. When the farmer comes out to greet him, the salesman says "I wanted to show you our latest catalog, but I couldn't help noticing you have a three-legged pig."

The farmer replies, "let me tell you about that pig. Last fall I was ploughing the north forty when the back wheels got stuck in the mud. The tractor flipped and pinned me underneath. I woulda died for sure but that pig saw what happened, ran back to the house and squealed until my wife came outside. She came and found me under the tractor and called for help. That pig saved my life."

The salesman says, "great story, but why does he only have three legs?"

"Let me tell you about that great pig", the farmer says again. "Just this spring we all went to bed early. My wife forgot to turn off the stove and when a breeze blew the curtains over the stove they caught fire. That pig smelled the smoke and squealed until we all woke up. We put out the fire and saved the house. That pig saved all our lives."

One more time the salesman says "yeah, but why does he have three legs?"

The farmer replies, "hey, a great pig like that you don't want to eat all at once."

I'll address the first problem - you have to provide more information. I do not know what PCA/SVD is. Please provide a sample of the data and an explanation of what you are trying to do. "Data mining" is far too broad a term to be of use.

uh, I see precious few girls interested in GI Joe play sets...

That's the point I was making. If they had tried to sell them as G.I. Joe "dolls" they probably wouldn't have done as well. By rebranding them as "action figures" they make them appear more manly then if they had called them dolls.

As a side note relating to gender differences, newborns, once they start to respond to visual stimuli, show gender specific traits. Boys, generally, are more attentive and responsive to mobiles while girls are more responsive and attentive to faces.

"Action figure" is only a marketing term used to sell dolls to boys.

I hope not for the same reason.