Reverend Jim

Here's an oldie but a goodie. Back in the days when hard drives were small (20 meg was about the standard), a third party app called DoubleSpace was sold to do on-the-fly compression/decompression. It also managed space with much less waste than FAT. Typically, if you had a 20 meg …

If you are familiar with VB then you could develop a console app or a vbScript app. The former requires you to download and install VB. The latter can be developed with just notepad. You can run a vbs (vbScript) file just like any other executable. There are objects you …

You couldn't even be bothered to make a decent title. I would have deleted this post if others hadn't already replied. I'll just let it stand as a good example of a bad example.

For numeric input I suggest you use a NumericUpDown control. It will accept only numbers and you can set maximum and minimum values for the control (and alter them at runtime). You set the messagebox style to Critical or YesNoCancel but only ever check for Yes, No or Cancel. Try …

Please display the value of sqlupdate (Debug.WriteLine would be good) and post the results here. And before someone else says it, you should be using parameterized values instead of just concatenating to create your query.

Don't expect anyone here to write this for you. We offer help and advice.

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 …

I don't see a lot of "common" courtesy these days. Even in the great white north where we Canadians are supposed to have a reputation for being polite, manners seem to be disappearing. Noy in my family though, I'm happy to say. I think part of the reason that people …

It is a fact of life that at some point, something critical will fail. I keep my OS on my C partition and my data (except for transient) on other partitions/drives. I do a clean install on C, set up my core apps and apply all updates. Then I take …

You can form the insert query by query = "insert into TABLENAME _ (CustomerID,Title,FirstName,LastName,DOB,Address,Town,Postcode,County,TelNumber) _ values('" & txtCustomerID.Text & "','" _ & txtTitle.Text & "','" _ & txtFirstName.Text & "','" _ & txtLastName.Text & "','" _ & txtDOB.Text & "','" _ & txtAddress.Text & "','" _ & txtTown.Text & "','" …

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 …

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 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 …

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.

One of the things I have been steadfastly avoiding is writing code to print stuff. Most of what I want to print is from withing apps like Outlook or Word that already provide that functionality. But I finally ended up having to bite the bullet. What I ended up with …

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 = …

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 …

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. …

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

Try this dbCon = New MySqlConnection("SERVER=localhost;DATABASE=test;") Dim ds As New DataSet Dim da As New SqlDataAdapter da.SelectCommand = New SqlCommand("SELECT Name FROM students", dbCon) dbCon.Open() da.Fill(ds) dbCon.Close() cmbname.DataSource = ds.Tables(0) cmbname.DisplayMember = "Name" or more concisely Dim ds As New DataSet Dim da As New SqlDataAdapter("SELECT Name FROM students","SERVER=localhost;DATABASE=test;") da.Fill(ds) …

Can you be more specific as to what kind of trouble you are having? If it is a connection problem related to security you may have to set up a database account with a userid and password and change your connection string to use those.

I only heard about it after the fact (I only watched the last minute and a half of the game) and saw it online, but there was a Volkswagom commercial where a guy from Minnesota talks in Jamaican patois. Here's yet another example of people who have nothing better to …

>So by my perspective, the birds will die in space due to lack of oxygen. I'm assuming he meant like in the space station or in the vomit comet.

[This](http://www.google.ca/url?sa=t&rct=j&q=step-by-step%3A%20installing%20sql%20server%20management%20studio%202008%20express%20after%20visual%20studio%202010&source=web&cd=1&cad=rja&ved=0CC4QFjAA&url=http%3A%2F%2Fblogs.msdn.com%2Fb%2Fbethmassi%2Farchive%2F2011%2F02%2F18%2Fstep-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx&ei=0N0QUY-8LIPi2QXxp4G4DA&usg=AFQjCNHj0mTQ2NGVpNVtI7r4jGNlJ2ISuQ&bvm=bv.41867550,d.b2I) will help when installing the SQL Management Studio. The procedure is not obvious.

When you write code to use the Excel application object it is not unusual to end up with multiple Excel.exe instances running. You should check with Task Manager for this.

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

I'm an old timer as well with grandparents from Holland. Welcome aboard.

I think **use the rest** should be **use the reset**

I don't know if this will help but if you open Firefox with "about:blank" as the target you might be able to go to Tools -> Options. Then select the Applications tab. If you can figure out which item is causing the problem you can use the **Action** drop down …

Glad to hear you are back on your feet again.

Looks like it provides a little more functionality than doing a search with DIR. One thing that always pissed me off about DIR is that wildcard searches also match of the hidden 8.3 file name which tends to generate head-scratching results when you are looking for files. Unfortunately, the same …

@deciptikon - quick follow-up question from a dinosaur. What is the difference between CDbl() and Convert.ToDouble(). Is the former being deprecated? Is there a reason why I should prefer one over the other?

In fact, the upper bound of the Gen.Next will never appear as one of the random numbers so if you want a number from 1 to 100 you must give 101 as the upper bound. As far as I am concerned it is brain dead but there you have it.

Well, you can always use kick-a$$ and hope you don't get dinged for deliberate evasion of the filter.

I thought multi-column comboboxes were not supported natively in vb.net without subclassing and custom code.

Currently a Dell inspiron 1720. The next one (in September) likely an ASUS N76VZ.

>It never occurred to him that his programming courses were trying teach him to be able to write the actual code himself He probably heard the pie-in-the-sky promises of OOP about code reusability and took it to the extreme. Like the guy who wanted to close the patent office decades …

He got banned a while back for too many infractions but I see that the infractions have expired. I guess he didn't care to return.

Read [Avoiding SQL Injection Attacks](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks). It explains what parameterized queries are and how to use them.

The StopWatch object does not have a name property. Please do not post duplicate threads.

If you have a block of code that is stuck in a very long loop that you want to exit prematurely then you'll need two things. 1. a global condition that you can test to do an `Exit` 1. a call to `My.Application.DoEvents` inside that loop For example Public Class …

As a newbie, the first thing you should learn is how to use SEARCH. As Philippe pointed out, your question has been asked and answered several times. You would have found this out had you put in even a minimal effort to look instead of just asking someone else to …

We are amused.

First you add a FileSaveDialog object to your form by dragging and dropping from the toolbox. After you have done that, select the control and browse the properties. Each property has a description that explains what it is for. To prompt the user for a filename you do If SaveFileDialog1.ShowDialog() …

You can use regular expressions to step through every word. If you define a word as any string of one or more - lower case letter - upper case letter or - single quote then to read a file and list all the words you can do Dim text As …

Dim num1 As Integer Dim num2 As Integer If IsNumeric(txtNum1.Text) Then num1 = CInt(txtNum1.Text) Else num1 = 0 End If If IsNumeric(txtNum2.Text) Then num2 = CInt(txtNum2.Text) Else num2 = 0 End If Or more concisely Dim num1 As Integer = 0 If IsNumeric(txtNum1.Text) Then num1 = CInt(txtNum1.Text) Dim num2 As …

Do you mean pronouns or do you mean proper nouns. In one case you want words like I, me, he, they, etc. This can be done by using a regular expression to identify the enumerated strings bounded by non-letters. However, if you mean proper nouns then I can't see how …

I know this has been asked before (at least twice by me) but I don't recall that I ever got an answer. I have been told that the DaniWeb search is google based. If that is so, why do I get different results when I search from within DaniWeb, and …

You can also add an entire row to a listview (in details view) in one step by ListView1.Items.Add(New ListViewItem({"col1data","col2data","col3data"})) In your case the parameter(s) would be {reader.GetString(0),reader.GetString(1),reader.GetString(2)}

The name is **NextPanelStopwatch**. To start it you do NextPanelStopwatch.Start Just make sure you declare it where it won't go out of scope.