Reverend Jim

What happens if you supply the IP address as part of the server name? For example, on my regular computer my SQL Server instance is JIM-PC\SQLEXPRESS But I imagine (I can't verify this because my computer is in the shop) I could also use \\192.168.1.104\SQLEXPRESS

Thanks for the feedback. I'd just like to point out that it's a good idea to check the dates on threads. This one is two years old and likely has been long since resolved or abandoned.

In order to prevent errors on ' all you have to do is replace each ' with two '. Instead of using name use name.Replace("'","''") If you do that SQL won't complain.

@TnTinMN - Just curious - is their an advantage to doing this rather than using My.Settings?

On a related note, have you considered that recipes don't "scale up" easily when it comes to things like cooking times?

I don't think you should be allowed to use that particular avatar until you have had a job that required supporting end-users (or working with engineers).

The Timer.Tick event fires once every Interval milliseconds so you don't need a loop inside the handler. If you are counting down to zero then just stop the timer at that point. Private Sub ... Handles timer1.tick If datetime.Minute > 0 Then datetime.AddSeconds(-1) Else DirectCast(sender,Timer).Enabled = False end if

What do you mean by "the MySql command is being skipped"? Please remove the TRY/CATCH/FINALLY/END TRY statements and post the exact text of the error message that is displayed. Your MsgBox which displays only "ERROR" is useless for debugging. It would also greatly help if you were to post the …

You could create two new tables named Invoice and InvoiceLine. Each invoice would have a unique primary key named Invoice_ID. The fields in this table would contain information relevant to the entire invoice (Customer_ID, date, status, etc). InvoiceLine would have a primary key consisting of Invoice_ID and Line_ID. This table …

Why not have the remaining letters in a dropdown combobox. Once a letter has been guessed you remove it from the combobox. That way there is no need to validate input.

I have one suggestion (not necessarily a great one). Set a class variable in the main form (call it something like ShowForm). Set it to True initially. Have a timer on the main form and set the interval to 1000. In the timer Tick event do Me.Visible = ShowForm You …

I use [CutePDF Writer](http://www.cutepdf.com/products/cutepdf/writer.asp). It's free and doesn't have to be run on a server. It just installs as a pseudo-printer and can be installed on on the workstations for whichever users need it. I haven't tried this but perhaps it could also be installed as a shared printer if …

If you are only interested in the total number of vowels and not the number of each vowel then a simpler approach is Dim str As String = "the quick brown fox jumped over the lazy dog" Dim numVowels As Integer = 0 For Each ch As Char In str.ToUpper.ToCharArray …

Make all cells in row 1 blue. For Each c As DataGridViewCell In DataGridView1.Rows(1).Cells c.Style.BackColor = Color.Blue Next

If you check out my code snippet [BackgroundWorker IP Monitor](http://www.daniweb.com/software-development/vbnet/code/440614/backgroundworker-ip-monitor) it shows how to use Delegates to access the textbox from another thread. I think that is what you will have to do.

Is it still possible to get a virus in the master boot record? If so, you might have to recreate this.

It's the people who believe the world is coming to an end and decide to help the process along that worry me. It also bothers me that the end of the world (a least this week's version) is one day before my birthday. That blows. I guess I'll just have …

Index is a reserved word. You can either rename the field to something other than Index, or you can specify the field as [Index] as in Dim myUpdateQuery As String = "UPDATE Sensor_Table " & _ " SET Equipment_ID = @id, " & _ " Location = @Loc, " & …

My nephew had this done a few years ago. It was his first one. After a few hours( and only halfway through) the artist asked him if he'd like to finish it up another day. His response was "once I get out of this chair there's no way I'm ever …

Have you seen the second Berserk that was just released?

I have a bit of a family thing at the moment (had to take my father-in-law to emergency) so I can't address the bigger issue just now, but I have a suggestion to simplify the username/password verification. Have the user enter both the username and password at the same time …

But then someone has to go through all replies to all posts to rate how relevant each post is to the question. If the OP doesn't provide full background and someone posts >You need to provide more details such as > > 1. The exact text of the error messge …

What are you comparing the day part of the date to?

There are several examples of encryption/decryption in the VB.Net forum. Just click on Code Snippets and scroll through the list. As for the timer thing, based on what you have said, it would only work if the user left the program running all the time. A timer won't function when …

My Christmas gift is having my older son fly home from Long Island to spend the holidays with us. He's due here Wednesday evening.

The regular expression ^\d+-\d+$ will match any string of the form "#-#" where "#" is any sequence of one or more digits. Once you have a match you can do a Split on the "-". For example Dim s As String = "123-45" Dim nums() As String = s.Split("-") nums(0) …

It is complaining because the compiler has determined that if the loop doesn't get executed then pname will not have a value to return at line 80. By assigning a null string when you Dim pname you ensure that pname will have a value no matter what execution path is …

No, but there are certainly a few available at other sites such as [this one for VB at msdn](http://channel9.msdn.com/Series/Visual-Basic-Development-for-Absolute-Beginners). You can easily find more with a little googling. A complete list of msdn tutorials can be found [here](http://channel9.msdn.com/Browse/Series?sort=atoz)

Aside from the Kinect I can't think of anything.

We don't offer help in that way. Private help doesn't benefit anyone else who might be looking for a similar solution. You also haven't given any indication what you need help with. If you are interested in help then please post your questions here.

You can output the linies by displaying them in a TextBox or RichTextBox control. As a matter of convenience, the RichTextBox control has methods to read/write files. or if this is for debugging purposes you can use Debug.WriteLine, or Console.WriteLine for console applications. In this case something like Module Module1 …

You have to convert the string to a number first. In your case that would be If CDec(CapAmount) >= 3000 Then

IMO I would think that people who are looking for tech help are typically looking for help with programming issues or with operational (configuration, driver, virus, hardware, etc) issues. Tablets are pretty much oriented to content consumers. Programming issues are in the realm of content creators. As for operational issues, …

Gonna take a shot in the dark. When you have your "disappearing" drive plugged in and visible, run diskmgmt.msc and try assigning a different drive letter to it (try Z:). Then see if it still disappears when another device is plugged in.

Whether or not the specs are adequate depends a lot on what you want to do with it. Document editing doesn't require much power. Hardcore gaming is another matter.

The OP hasn't been on DaniWeb for almost seven years. There is no need to revive this thread.

[google this](http://www.google.ca/#hl=en&tbo=d&output=search&sclient=psy-ab&q=what+is+the+difference+between+vb6+and+vb.net&oq=what+is+the+difference+between+vb6+and+vb.net&gs_l=hp.3..0j0i8i30l2.1524.11507.0.12259.45.21.0.23.23.3.1555.6606.0j9j3j4j2j1j8-1.20.0.les%3B..0.0...1c.1.lSPOqM8xzm0&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&bvm=bv.1355534169,d.b2I&fp=1585625df7f66034&bpcl=40096503&biw=1440&bih=783) and check out the first three hits.

>how to find all data in my first listview to another Can you please explain what you mean by this?

Not by itself, but you might find the source code for a custom control to do that [here](http://www.codeproject.com/Articles/3206/Multi-Column-ComboBox)

Perhaps you haven't put any text into fo1. In any case you don't need to have the If. We know the current directory exists and WriteAllText will create the file if it doesn't exist.

Please clarify what you want to do. >i want the AM Field to input in the AccountName is unclear. >I need to get them and put it on a > >Dim AccountName as String You already have them. They are in the ListView.

I'm guessing his 500 gig hard drive was flagged by Windows as unpartitioned so he boot into a linux recovery system from USB and reset the partition table. Then it was OK for a while but got reset back to unpartitioned.

You could create your own class with properties named EmployeeID, LastName and FirstName and create a new list of the new class type or you could use a [detached recordset](http://www.daniweb.com/software-development/vbnet/code/428716/using-detached-recordsets-to-sort-data). You could likely also create a database in memory as well using more modern techniques involving datasets/datatables, etc but I …

I think he is saying that instead of spending $50 for two new cartridges we are better off topping up our landfills with single-use printers by buying a new one whenever the ink runs dry.

The point is to make a worthwhile contribution. My following comment is not meant to point out any similarity but only to make a point. A few months ago we had a member (now banned) who was making dozens of posts daily in [Thoughts of the day](http://www.daniweb.com/community-center/geeks-lounge/threads/83726/thoughts-of-the-day). Most of the …

You could try [AutoIT](http://www.autoitscript.com/site/). I've used it to automate several tasks.

What is a **BondFiled column**? Do you mean a bound field column? What kind of data does it contain and what do you want to happen? How will the timer be started and stopped? Do you want one countdown for each record? Details please.

If you need an "all or nothing" action where if any insert fails then they all fail you will have to create a Transaction and use a Try/Catch so you can roll back the entire transaction on an error.

If you want to copy records from one table to another you have to do an INSERT. Update modifies columns in existing records. The syntax of this type of insert is INSERT INTO table2 (<list of column names>) SELECT <list of column names> FROM table1 If the column names are …

Short answer - The Shawshank Redemption.