Posts by Reverend Jim

Rest assured. It would not be possible to confuse me further. Thanks again for the explanation. I really think I got it this time.

Not true at all. There have been lots of presidents from both parties who have won two back-to-back election.

I was being sarcastic. Karl Rove wouldn't believe the numbers presented by his own dearly beloved Fox News. Republican pundits repeatedly stated that polls showing an Obama win were obviously skewed while their own polls showing a Romney landslide were accurate. My point was that Republicans will claim a system is broken only when it no longer favours them.

I looked at the just one link...

Once again, there are bold headlines and live-at-6 broadcasts about scores of bogus registrations, secret grand jury investigations and accusations of blatant race-based disenfranchisement.

Race based disenfranchisement usually means suppression of the black (ie Democrat) vote.

They said that election officials had permitted polling places to become chaotically crowded, possibly in a deliberate effort to depress the city's heavy black vote.

and

There also is plenty of talk -- unsubstantiated -- that Republican election officials are intent on making it difficult for blacks to vote, while Democratic election officials are intent on making it too easy for blacks to vote.

So there is talk that Republicans are trying to suppress the black vote while Democrats are trying to make it easier for them to vote. How is it a bad thing to make it easy for someone to vote?

And please note the use of phrases such as "unsubstantiated". You can't claim that the referenced article is proof of Democrat fraud. It seems to lean heavily in the other direction. In any case, allegations are not proof. We'll have to see what they uncover.

Change the word "can't" for "won't" and you would be more correct. Why fix something that isn't broken?

That was sort of my point. As long as you elect Republican presidents then the system isn't "broken". But Obama winning back-to-back victories, and with majorities? That's obvious "proof" the the system has broken down. Thus the "Republican Plan".

What ever gave you that impression? Democrats (most minorities are democrats) are often known for duplicate voting, and voting for dead people.

First of all, voting for dead people is highly innefective because dead people can't be sworn in. I'll assume you meant voting by dead people. I'd love to see any actual proof of that. How about the legislation that the Florida governor tried to ram through that even members of his own party couldn't stomach. They were found to be unconstitutional but he tried to push them through anyway. Rick Scott claimed there were more than 180,000 non-citizens on the voter rolls. Even his own election chief had to admit that the number was actually fewer than 200 (out of 11 million voters). And I mean 200, not 200,000.

Nathan Sproul was hired by several state Republican Parties to register voters. He was fired after it was discovered that his workers had a nasty habit of throwing out forms from Democrats.

Both Florida and Ohio tried to limit weekend voting in the last weeks before the election. They continued these efforts in spite of federally issued court orders to stop.

Fliers were distributed in many poorer, coloured neighbourhoods (where most of the votes go to Democrats) giving incorrect locations and dates for voting. Fliers sent to areas deemed Republican were given correct information.

Ohio and Florida specifically banned voting on the Sunday before the election – a day when black churches historically mobilize their constituents.

The …

It will be interesting to watch what happens in the US over the next four years. The Republicans have managed to keep their majority in Congress through Gerrymandering. They tried to steal the 2012 election through suppression of minority votes. They've pretty much taken both tactics as far as they can so that leaves but one.

The current system mandates that for each state, the candidate who gets the majority of the votes in that state gets all of the electoral college votes. What I expect to see happen is for the states with Republican governments to change the system for those states so that the electoral college votes are allocated by district. That would give enough electoral college votes to the Republican candidate to guarantee a victory.

They will, of course, cloak it in the usual rhetoric of "it's a more democratic way of electing the president". What it really means is "the old system just isn't working for us anymore". They will also abandon their usual rant of "we can't change a system that's worked for over 200 years".

OK. I thought I had this figured out. Based on the name (One-Dot Rule) don't both of the following violate that rule?

DeclaredRef.Comobject.PropertOrMethod           2 dots
DeclaredRef.ComObject.ComObject.Property        3 dots

or

exWB.Sheets(1).Range("a1").Value = "TEST"       3 dots
sheet1.Range("a1").Value = "TEST"               2 dots

or am I totally misinterpreting the "one dot" portion of the rule name? Or is it just a very bad choice for a rule name? Perhaps "one-dot rule" is zero-relative ;-P

Are you running the Ghostery plugin? If so then add Daniweb to the whitelist. That's what was causing that problem in my case.

The problem with security is that if you take all possible precuations then the app becomes

• too time consuming to write and test
• too expensive to develop/debug
• too difficult to maintain

In our corporate environment I could reasonably assume that nobody was packet sniffing to ferret out credentials.

Look at airport security. If we took all possible precautions then every single item going on board would have to be examined by eye and by sniffer dogs and everyone would have to be strip searched and x-rayed. For that matter, no luggage would be allowed and people would have to surrender their clothing when boarding and be issued disposable clothing for the trip. Full body cavity searches would be mandatory to prevent against ingested or inserted explosives/weapons.

Of course, such measures would never be tolerated (then again, who could have forseen the current TSA measures). We always try to compromise between reasonable security and reasonable measures (again, TSA grope search?).

Not if the font is proportional. Look at the attached image. Both lines contain 25 characters.

Did Karloff sire Clooney?

Put two days of beard on that picture of Karloff and he'd look a lot like Hugh Laurie as Dr. House.

It's easy enough to calculate how many lines of text will fit on a page but when using a proportional font, there is no way of determining how many characters will fit on a line because the number will vary depending on the actual characters. But I will still play with the code you posted. Thanks.

I find a convenient way to handle complex logic is to use this form of the Select

Select Case True
    Case <conditional>
        code
    Case <conditional>
        code
    Case <conditional>
        code
    Case Else
        code
End Select

Normally in a Select you would put the conditional in the Select clause. With Select Case True you can put any conditional in the Case clauses. They don't have to be related. Just put them in the order you would code them with Else If statements. Also, if you want to remove parentheses in compound conditionals then

Not (a Or B)

is equivalent to

Not a And Not B

or to use the above example

not(EVENT_NUMBER.Text ="" Or person.Text ="") And Event_ASSOC2.Text <> "Stolen"

is equivalent to

EVENT_NUMBER.Text <> "" And person.Text <> "" And Event_ASSOC2.Text <> "Stolen"

You can create a second listview, lvwResults, that is identical in format to Bookmarks.ListView1 and display the matches as follows

lvwResults.Items.Clear()

For Each item As ListViewItem In Bookmarks.ListView1.Items
    If item.SubItems(0).Text = txtName.Text Then
        lvwResults.Items.Add(item.Clone)
    End If
Next

My Dad had a cousin with acromegaly. The onset was as an adult a few years after he got married. It wasn't pretty. I think the cause was an inoperable tumor on his pituitary gland.

Trend Micro has this to say about the link in your signature

Trend Micro has confirmed that this website can transmit malicious software or has been involved in online scams or fraud.

It smells like something and it's not teen spirit.

Rondo Hatton (1894–1946). He usually played brutish but dumb characters because of his acromegaly (a pituitary defect that causes uncontrolled bone growth). He was the inspiration for a similar character in The Rocketeer.

A couple states threaten to withdraw from the union

I got the impression that it wasn't the actual states threatening to secede, just a few thousand very vocal nutjobs.

I don't think that religion in and of itself is evil, however, it is used by evil people to commit evil deeds.

"With or without religion, good people can behave well and bad people can do evil; but for good people to do evil—that takes religion." - Nobel Physicist Steven Weinberg

Without a context that line could be almost anything. ADO works just fine in newer versions of VB. Tell me what you are trying to do and I'll try topo give you some sample code. For example, the following code uses ADO to retrieve a recordset and populate a listview.

Imports ADODB

Public Class Form1

    Private Sub btnADO_Click(sender As System.Object, e As System.EventArgs) Handles btnADO.Click

        'ADO is the underlying layer for both SqlClient and OLEDB

        ListView1.Items.Clear()

        Dim con As New ADODB.Connection
        Dim rec As New ADODB.Recordset

        con.Open("Driver={SQL Server};Server=.\SQLEXPRESS;Database=PUBS;Trusted_Connection=yes;")
        rec.Open("SELECT au_lname,au_fname,zip FROM authors WHERE au_lname like 'S%'", con, CursorTypeEnum.adOpenStatic)

        Do Until rec.EOF
            ListView1.Items.Add(New ListViewItem({rec("au_lname").Value, rec("au_fname").Value, rec("zip").Value}))
            rec.MoveNext()
        Loop

        rec.Close()
        con.Close()

    End Sub

Here in Canada we've heard the rhetoric on both sides of the Quebec/Canada should they stay - should they go issue. Unfortunately for my side (Anglo) we don't get to hear serious discussion about the actualities should separation occur. So far what I've heard is that Quebec basically wants to be friends with benefits. They want to retain the right to use the Canadian dollar and they want to leave without paying their fair share of the national debt.

Now, Mike, before you come out with guns blazing, I am not in any sense suggesting that what I have been told reflects reality, only the reality that the media has decided to create. I would very much like to hear the terms under which Quebec would leave Canada and what relations (economic and polital) would be like between an independent Quebec and the remaining provinces. But I suppose that this particular thread is not the place for that discussion and such a discussion would probably be of little interest to most DaniWeb members. My personal opinion is that Canada would be a poorer place should Quebec decide to separate.

Is it being run under the same account on the file server as it is on the desktop? Is it using a domain account or a local (machine) account? Perhaps it is just an access rights issue. I'm assuming that you are using an hta staher than a vbs script because you need the GUI provided by hta so that would also mean that the program is not being run unattended.

I'll bet your programs did not do it siently without user knowledge.

Actually, it did. And that was at the users' request. They didn't care about updates or being informed about what version they were using. All they cared about was that the software worked. When you are an operator controlling many billions of dollars of equipment and ensuring that power gets delivered reliably to a million local customers and to neighbouring provinces and states you have better things to do than acknowledge message boxes that do nothing more than tell you that everything is working. It's when things aren't working that you need the alerts.

When we get the dumping it's usually because of a Colorado Low. I know. Blame the Yanks for that too ;-P Unlike the schnooks (ok, chinooks) in Alberta.

That is such an open ended question that a short answer is impossible. Please provide more details. What are the tables you want to link and how are they related?

I used to do this all the time for corporate apps. It was critical that the users ran the current version of the software so the apps had a front end that would compare the date/time stamps of all installed modules to those on the server. Any new modules were copied to the user's PC before the app was actually loaded. I used a common launcher.exe that took three parameters

1. local app folder
2. server app folder
3. local executable to run after updating

Funny. Down there you seem to get more major snowfalls than we do here. We very seldom get the "shut down the city" snowstorms that we see hammering other regions. The last really bad one was in November '86. I was on standby that week and got called into work before the city got shut down. I was stuck there for three days. Of course I got a snot-load of money in compensation. My wife, however, wasn't pleased. She was stuck at home with a two kids (one almost three years old and the other about two months) and a dog.

You'll have to be more specific.

• What does the listview look like?
• Can you get more than one match?
• What exactly do you want to display?
• How do you want to display it?

Wow.. your university days must have been really painful..

We certainly got exposed to a lot of languages. That was way back in the 70s. My younger son graduated from Computer Science in 2008 and the curriculum was vastly different. My courses were much more math oriented (five full courses of numerical analysis) and we had nothing on micro code. And back then there was no Java. The numerical analysys was heavily programming oriented. Fortunately, APL was one of my earlier languages. It was the perfect thing for the number gumby stuff.

Like what Reverend said Man on Fire was good too

That's pretty much the exact opposite of what I said.

You want a UNION rather than a JOIN. Example:

SELECT * FROM Males   WHERE Mark > 50
 UNION
SELECT * FROM Females WHERE Mark > 50

will return one recordset

Denzel Washington hasn't been picking winners lately. I saw Man on Fire a while back. What a waste of money. Filming the entire movie with a hand-held camera may be artistic, but the decision to hire a cameraman prone to frequent seizures is not. That's how the photography seemd to me anyway. My advice - if you plan to watch that movie, take some anti-nausea meds first. You will get seasick watching it.

From my University days, FORTRAN, APL, PL/1, ALGOL, ALGOL 68C, SNOBOL, COBOL, Lisp, 360 Assembler. Since then, C, C++, VB, DEC Assembler, Data General Assembler, 8080 Assembler, Prodac P250 Assembler, vbScript, SQL and a smattering of Python (which I never really got into). It's amazing how quickly you lose proficiency in a language once you stop using it regularly.

People in the United States experience higher rates of disease and injury and die earlier than people in other high-income countries.

Quoted from the January 2013 issue of the Journal of the American Medical Association

Columbus discovered America, the Spanish discovered Mexico and the French discovered Canada.

I'm going to nitpick here. Those people discovered nothing. Every place they "discovered" already had people living there. Saying Columbus discovered America is like saying Isaac Newton discovered gravity.

It's probably easier to use an application setting instead of the registry. If you are using VB 2010, go to Project -> Properties, then go to the Settings page. You'll have to pick an appropriate variable type. You can access it by

My.Settings.varname

You can keep track of elapsed time by using a TimeSpan or unsigned int.

Do you have the same mosquito problem in the summer that we do here in in Winnipeg?

Canida and Mexico are also part of America.

Sorry, no. As I said, technically you may be correct, but in practical use, American means "U.S.A.". And it was your doing.

As American as apple pie.

America (Paul Simon)

We've all come to look for America

American Pie (Don McLean)

So bye, bye Miss American Pie"

America the Beautiful(Katharine Lee Bates)

America! America!
God shed his grace on thee

I won't bother to do an exhaustive search, but how many songs about your country refer to it as "The United States of America"? Check the presidential speeches over the last few decades. How many refer to "America" and "Americans"?

Kennedy's moom-mission speech to congress

Now it is time to take longer strides--time for a great new American enterprise--time for this nation to take a clearly leading role in space achievement, which in many ways may hold the key to our future on earth.

So somewhere along the line someone co-opted "America" to specifically mean "United States of America". It suspect it wasn't Canadians or Mexicans or anyone alse.

If you are not using a data connection (?) then why are you using a connection string and why does it specify SQLEXPRESS? How can it possibly work on your computer? Can you be more specific than

I CONNECT TO EXCEL THROUGH CODE.

And can you please not post in CAPS? Also, for future reference, please do not hijack a thread. Your question belongs in a new thread.

The first term is of type String, the second is not. You have to select a specific item and subitem in the collection. You probably want to search like this.

Dim found As Boolean = False

For Each item As ListViewItem In Bookmarks.ListView1.Items
    If item.SubItems(0).Text = txtName.Text Then
        found = True
        item.Selected = True
        Exit For
    End If    
Next

If found Then
    'do something with selected item
Else
    NoResultsFound.Show()
End If

And you should check that you have Vista/Windows 7 drivers for any hardware. I have a USB TV tuner and a Lexmark printer, for example, that I cannot use under anything newer than XP.

I wonder how does it feel to have winter and snow..never feel it before..

The last few days would probably be as much a shock to your system as Arizona in August was to mine (like getting hit in the face with a brick every time I stepped outside). We hit -45C (with the windchill) here a few days ago and I still preferred that to +47C in Arizona.

I don't think I ever live in Canada

You'd be surprised. It's not that cold here all winter long. We used to get a cold snap in December and January but for years now it's really been just January. And even when it gets really cold it's not for long. On the really cold days it is quite sunny and usually not windy so outdoors is still an option as long as you dress for it. That's one thing about the cold - you can always throw on another sweater. Can't do much on the hot days except sweat.

For all practical purposes, "I am American" means I am a US citizen. I can't imagine anyone (American or not) taking it to mean otherwise.

I tried it before I posted it and it was working then. It's not elegant but it does work and if anyone has improvements/suggestions I'd love to hear them. I just noticed one improvement - reset the values of the static variables after the last page is printed so that the next print starts properly.

Technically, because it is made from rice, it's rice beer rather than rice wine.

Yankee - noun - sort of like a quickie except you do it yourself.

I couldn't hold back any longer.

During her three year term at Fox News, Sarah Palin was paid $15.85 per word.

You can either set the ListView MultiSelect property to False, or you can change the code to

ListView_LOP.SelectedIndices.Clear()
ListView_LOB.Focus()

For i = 0 To ListView_LOB.Items.Count - 1
    If ListView_LOB.Items(i).SubItems(1).Text = TextBox1.Text Then
        ListView_LOB.Items(i).Selected = True
    End If
Next

Software keeps getting bigger because once the market has been saturated with version x of an application, the only way for the company/person who produced that software to get more money is either to release a new application or release a newer version of the same application. If it already has the features that you want and need then they have to create an artificial demand for the new version. There are various ways to do this including

1. adding features that you don't need but are touted as the "new wave"
2. deprecating software tech in the current version
3. hipster advertising (you don't want to be a loser who has yesterday's software, do you?)
4. compatibility

Before I retired, we were forced to upgrade all of our copies of Microsoft Office because those control centres who had already upgraded started sending their documents in a format that our version could no longer read.

So the features keep on piling up and the software keeps getting more bloated.

Surely if Windows can turn on/off the power to various devices such as monitor, hard drive, etc based on user settings then there must be some way for an application to do the same with the proper API call.