Reverend Jim

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 …

In order to relate two tables they have to have a common column. You'll have to include the EmployerID as a column in the Employee table. You described the tables as follows: Employer Table: I have two field EmployerID (pk Key assigned to it) Employee Table: EmployerID(pk Key assigned to …

You can also download (free) the SQL Management Studio which greatly simplifies the creation and management of databases. However, installing it is tricky unless you [follow the step by step instructions](http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx)

It's broken again. I've completely cleared the cache and still there are no text entry/browse buttons.

Rake some leaves, shovel some snow, wash somebody's car or walk their dog. You can make 9$ doing just about any trivial chore. It doesn't take a lot of imagination.

This error can happen when you have a parameter in your connection string that is not valid for the given provider. Try changing Persist Security Infor=False to Persist Security Info=False and see what happens. What type of database are you trying to open?

A minor suggestion. Assuming you are using radio buttons then you can simplify your code because if (for example) the male button is not selected then the famale buttom **must** be selected. So instead of If (maleRbtn.Checked = True) Then gender = 0 ElseIf (femaleRbtn.Checked = True) Then gender = …

I think you can clear out saved text by clicking the dropdown box and moving the cursor over an option. When it is highlighted, press the DELETE key.

Show us what you have so far. If you don't have anything then it's time to do some research. Use google to find some tutorials (there are several good ones) or get a book.

This thread was marked as solved five years ago.

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.