Reverend Jim

In rare cases (even with Microsoft apps), clicking OK may not APPLY your changes. To be safe I usually click APPLY then OK.

@Irahmiki - Please read the [rules](https://www.daniweb.com/community/rules), one of which states **Do provide evidence of having done some work yourself if posting questions from school or work assignments**

Try cmd.CommandText = "UPDATE PDC_CHQ_IN_HAND SET PDF = NULL " & " WHERE RefNo = '" & TxtRefNo.Text & "'" but if RefNo is defined as a numeric you should use cmd.CommandText = "UPDATE PDC_CHQ_IN_HAND SET PDF = NULL " & " WHERE RefNo = " & TxtRefNo.Text

You can use an event handler for multiple controls of the same type. The easiest way is at runtime by AddHandler CONTROL.EVENT, AddressOf yourhandlerSub Or if you want to do it at design time just add ,Handles CONTROL.EVENT to the end of the handler declaration.

You may want to consider (on app startup) doing a test to see if the file can be accessed, and popping up a folder or file dialog to allow the user to specify the file location if it cannot be accessed. This new location could be saved in the app …

What database are you using?

We don't have those in Canada. FYI we also don't have GREs.

There is a manual method for creating a shortcut that will run with Admin access (bypassing the UAC prompt) [here](http://www.thewindowsclub.com/create-elevated-shortcut-run-programs-bypass-uac).

Have you tried [Perry's ID3 Tag Library](http://glassocean.net/perrys-id3-tag-library/). I used this quite a while back with no problems. It's open source and he also provides an ID3 viewer using the library.

Generically it would be If SOME CONDITION Then txtShift.Text = "DAY" Else txtShift.Text = "NIGHT" End If I can't be more specific than that because I don't know what range of values defines DAY or NIGHT. If there are a restricted set of possible values then you would be better …

In my experience when you do an upgrade install you end up with pieces of both systems scattered about higgledy-piggledy. You'll effectively get a mish mash of both with a lot of wasted disk space. My advice is to take a disk image of your current system then wipe it …

Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Dim mainMenu As New MenuStrip Dim fileMenu As New ToolStripMenuItem("File") Dim fileQuit As New ToolStripMenuItem("Quit") fileQuit.ShowShortcutKeys = True fileQuit.ShortcutKeys = Shortcut.CtrlQ fileMenu.DropDownItems.Add(fileQuit) mainMenu.Items.Add(fileMenu) AddHandler fileQuit.Click, AddressOf QuitToolStripMenuItem_Click Me.Controls.Add(mainMenu) End Sub Private Sub QuitToolStripMenuItem_Click(sender As System.Object, e As …

I'm not clear on what you are asking. Could you possibly post an example with sample data? Please post, as well, any code you've tried so far.

I wrote a code snippet quite a while back that [displays thumbnails](https://www.daniweb.com/software-development/vbnet/code/470880/how-to-generate-thumbnails-which-preserve-the-aspect-ratio) in a ListView while preserving the aspect ratio of the original pictures. Just change the values of `THUMBW` and `THUMBH` to the desired size. To avoid impacting program response the thumbnails are generated in a background thread. If …

It's possible that the only problem is that your profile has been trashed. One suggestion is to create another user (an administrator). You can run the user manager by running `lusrmgr.msc`. Then log on to that user. Locate the folder containing your profile. I don't recall where XP keeps them. …

1. Put the numbers into an array 1. Sort the array in ascending order 1. Take the "top" 3 Your definition of "top 3" seems to be "the first 3". My definition of "top 3" would be the three largest. If this is a homework assignment I suggest you get …

* Nicely organized * Well laid out * Lots of comments * Good use of white space * Step-by-step explanation Two thumbs up.

First check that `names.txt` contains what you think it does (it would help to post the file here). I suggest you step through the code in the debugger and see if 1. "names" is actually getting the data 1. Array.Reverse(names) is doing what you want Note that `Array.Reverse` does not …

1. Create a sample file. 1. Double click on the file 1. Select "Select a program from a list of installed programs" 1. When the "Open with" dialog comes up, select "Always use..." then click "Browse" 1. Browse to your exe and select it

I've always loved the character, Reverend Jim, from the old TV series, Taxi. His actual name was Jim Ignatowski (he changed it from his real last name because he thought Ignatowski was "Star Child" backwards). He was originally brought in as a one-time guest start to perform Latka's wedding but …

Mark Russinovich (Sysinternals) has an excellent (and free) utility called [autoruns](https://technet.microsoft.com/en-ca/sysinternals/bb963902.aspx) that is part of the (also free) [Sysinternals suite](https://technet.microsoft.com/en-us/sysinternals/bb842062.aspx). It will tell you everything that starts automatically and allows you to disable selectively.

What line generates the error?

I'm still having a problem when typing text in the edit box. When I get to the bottom of the edit box the text does not scroll to keep the cursor in view. The box expands to 20 lines and then the scroll bar appears, however, the scroll bar does …

I prefer to avoid using StreamReader unless the input file is exceedingly large. You are scanning for a series of keywords so I suggest you loop through the keywords rather than looping through the lines of text. You could do something like Dim lines() As String = System.IO.File.ReadAllLines("D:\temp\test.txt") Dim keywords() …

As long as you still have the mdf file you can copy it to where sql keeps the other database files. I keep mine in D:\SQL\DATA. Then do (using your actual path) EXEC sp_attach_single_file_db @dbname='yourDb', @physname=N'D:\SQL\DATA\yourDb.mdf'

According to the IP addresses, Woj was posting from [Poland](https://db-ip.com/46.171.26.3) and K.Chris is posting from [Mexico](https://db-ip.com/189.166.50.8).

That's how autocomplete works. It matches from the beginning. If you want to match on any string you can roll you own (after a fashion). Create a new form with a text box and a list box. Add the following code Public Class Form1 Private Movies() As String Private Sub …

If you want the language that packs the most punch for the least code I would have to go with APL. Imagine implementing Conway's game of life in one line of code of fewer than 80 characters. Note - you said **powerful**, not **readable**. 

The syntax for `INSERT` is INSERT INTO tablename (fld1, fld2, ...) VALUES(val1, val2, ...) where you specify the field names by fld1, fld2, etc. and the values by val1, val2, etc. For a complete example of how to use parameterized queries please see [Code Snippets](https://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks).

I think that any questions like that about XP at this point should be answered with E. Who cares?

You may also want to look into `AddHandler` which allows you to add the same handler to multiple controls.

Dim newline() As String = sr.ReadLine.Replace("""","").Split(",")

I have two impacted wisdom teeth that haven't budged in 30 years. The dentist figured that if they didn't bother me then we should leave them alone. The chances of colateral damage increase with age. One possible complication is loss of taste because of nerve damage.

I run with Aero disabled. When I press alt-tab I get a horizontal list of icons for the active apps. You can click directly on the one you want if you don't want to alt-tab through the list.

Any line/paragraph that starts with a ">" is a quote. As you will see if you follow the link from cereal, DaniWeb uses Markdown formatting. There is an excellent Markdown editor, [Markdown Pad](http://markdownpad.com/) that comes in a free edition. I generally use it to create longer posts, then cut and …

I find that for this type of problem, a `Select` clause is clearer Select Case NumGrade Case 0 - 69 Label3.Text = "F" Case 70 - 79 Label3.Text = "C" Case 80 - 89 Label3.Text = "B" Case 90 - 100 Label3.Text = "A" End Select

You are going to have a problem with If cmbProcess.SelectedIndex = "0" Then because `cmbProcess.SelectedIndex` is numeric and you are comparing it to a string. Try If cmbProcess.SelectedIndex = 0 Then

Mostly reading and music.

Assuming that proQuantity is numeric, try cmdUpdate.CommandText = "UPDATE tblProducts SET proQuantity=" & txtTotalqty.Text & " WHERE pID =" & cmbID.Text & ";"

You start by creating a form with some controls. When you get to the part where you have to add code for the calculations just put in things like 'calculate batting averages When you get to that point you can ask again. We are not going to create this for …

You can't concatenate an array. To see how to insert binary data you can look at [this code snippet](https://www.daniweb.com/software-development/vbnet/code/461171/insert-a-file-as-binary-data-into-a-database). The example uses a PDF.

You can't use LIKE on numeric values. You can use DATEPART to extract the year portion. Your query string should be qry = "SELECT * FROM test_table" & " WHERE DATEPART(YY,myColumn) = " & myDate

I thought I'd install the newest Visual Studio (2013) but all that happens is this (see below). I have all available updates installed plus the latest C++ runtimes. Does anyone have any suggestions? Attempts to get the referenced update result in downloading Visual Studio 2013 Update 3 and when I …

Try adding ";Connection Timeout=60" to the end of your connection string.

And?

A quick check in vb.net and vbScript (sorry, do not have vb6 installed) gives the following results Math.Round(1.5) is 2.0 Math.Round(2.5) is 2.0 Math.Round(3.5) is 4.0 <edit> corrected from 3.0 </edit> Math.Round(4.5) is 4.0 <edit> corrected from 3.0 </edit> If the integer portion is odd then it rounds up. If …

You start by putting in some effort on your own. [Google](http://goo.gl/XHAvvN) it.

Mine is under my avatar. Noli mentula, which (not literally) translated into English is "don't be a dick".

For what it's worth, GOTOs are evil. Before the advent of structured programming constructs like IF-THEN-ELSE, GOTOs were a necessary evil, but used properly they could be tolerated. I, myself, have (on rare occasions) used GOTOs to escape from nested constructs, but I have never had to resort to that …