Reverend Jim

It depends on where the database is and how heavily it is being used. If the database is on a server and it is heavily used by a large number of people/applications concurrently then best practice is to keep your connection closed until you need it. Then open it, use …

I don't see why an endorsement is any less valid just because the endorsee has departed. I do, however, think endorsements from unverified members, or members with less than a particular level of rep or activity (to prevent bogus self-endorsement) should be excluded.

I think you should have thought of that before you started trolling. I suggest you take the time from now until your infractions expire and try to acquire a little maturity.

Can you please try to explain in clearer detail?

Got you beat. I'm turning 60 on Sunday. >its awful moment happen in my life Sorry to hear you are going through a rough patch. I hope you have friends and/or family to help you through.

You might want to go to the ASUS website and download all the drivers you will need before you get started.

Rather than trying to code up a convoluted query to do that you should instead restructure your table to have separate fields for given name(s) and surname. You run into problems when storing the names as "John Smith". For one thing, if you want to sort by last name you …

[This post](http://joelgrus.com/2013/12/24/why-programming-language-x-is-unambiguously-better-than-programming-language-y/) by Joel Grus is both insightful and highly entertaining. Make sure to read the comments which are also witty and amusing.

Replace dt = ExecuteQuery("UPDATE tblUsers SET UserID = " & txtUserID.Text & ", UserName = '" & txtPassword.Text & "', Password = " & txtPassword.Text & ", LastName = '" & txtLastName.Text & "', FirstName = '" & txtFirstName.Text & "', Position = '" & txtPosition.Text & "', Address = …

Gotta be cheesecake. I know it's bad for me but that wasn't the question.

If the number of links is variable then you will not be able to do this in a single query. Please see [this thread](http://www.daniweb.com/web-development/databases/mysql/threads/469676/loop-in-mysql-query)

You can find a step-by-step procedure [here](http://www.kbpublisher.com/kb/How-to-change-ft_min_word_len-variable_273.html)

Yes. We are a polite people. Rather than breaking out the guns we just said "we'd like to leave now, please."

[Parts of the guitar](http://en.wikipedia.org/wiki/Guitar#Construction_and_components) As for the fingertips, I believe the general rule is practise until they bleed then 20 minutes less. Once the calouses form it gets easier.

You could use regular expressions as follows Imports System.Text.RegularExpressions Public Class Form1 Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'the pattern matches the longest string of letters and/or digits Dim rex As New Regex("[a-z|A-Z|0-9]+") Dim str As String = "abc,123.xyz;praise;end,file,clear" For Each m As Match In rex.Matches(str) …

Can you describe what you want in words? There are several ways to generate the given results. One is SELECT EmpNo FROM EmpList WHERE ReportingTo >= 14 Unless you can tell us what you want it is impossible to give a meaningful answer.

Also private contractor who is able to subcontract all the actual work offshore.

If we reformat the code (with indentation) we get Dim (PlayX) As Integer For PlayX = 1 To 10 If Player(PlayX) = "YT" Then Open "C:\Poker\yt.pok" For Input As #1 Input #1, PlayerName, TournamentGames, TotalGamesPlayed, Points, Member, gamebalance Close #1 TotalGamesPlayed = TotalGamesPlayed + 1 gamebalance = gamebalance + playmoney …

Is there a question here?

You are in your 2nd year of IT and you don't know how to make a form? And you are blaming your professor because he didn't teach you? Daniweb is not a homework service. We will answer specific questions but first you have to show that you have put in …

There are also some examples of using Excel from vb.net in the [Code Snippets](http://www.daniweb.com/software-development/vbnet/code/_/58)

For starters, the target of **AS** should not be in quotes SELECT name, sum(quantity), price, price * sum (quantity) AS value

The solution was to replace the "@" values in the query with "?" as in the following example ListView1.Items.Clear() Dim con As New OleDbConnection("Provider=SQLNCLI10;Server=.\SQLEXPRESS;Database=PUBS;Trusted_Connection=Yes;Connect Timeout=15;") Dim cmd As New OleDbCommand("", con) cmd.CommandText = "SELECT au_lname,au_fname,zip FROM authors WHERE au_lname LIKE ?" cmd.Parameters.AddWithValue("@parm", "D%") con.Open() Dim rdr As OleDbDataReader = cmd.ExecuteReader() …

I was always a big fan of Jim Ignatowski on the TV show Taxi. He was also known as Reverend Jim and, since my first name is Richard (I go by my middle name, Jim) and the initials match in both cases (RJ)...

What is **DESING**?

Do you expect us to tell you what is wrong with that SQL statement? Perhaps it is doing exactly what it is being told, and returning no data is what is to be expected. That's going to be hard to say seeing as how you haven't told us what you …

Try replacing "@Time_OUT" with "?" and make sure you do the AddWithValue calls in the same order in which the "?" appear in the query. When using OleDbCommand, the actual "@" strings in AddWithValue are ignored. The calls replace each "?" in turn no matter what "@Text" you specify.

Yes, it's a great story, but unfortunately it misleads people into believing that writing good code is a skill that can be picked up on the fly. Knowing how to nail two pieces of wood together does not mean you are capable of designing and building a house that won't …

I'll just use local variables for the parameters and you can substitute your control values as appropriate. What you can do is create the query then try to retrieve the number of matches for entered values. If that number is zero then the entered values were incorrect. Dim username As …

**crooked Neake Buttons** **zobrezene** **mam** Either take the time to compose a coherent question or ask someone to help you with the translation. What you are saying makes no sense to me.

At least he isn't creating bogus accounts and endorsing himself. That would be pretty low.

This forum is all about help but we can't do that unless you ask a question. First you have to show that you have put in some effort of your own.

The information can vary but the format cannot. You posted the pseudocode aHighScore[0] <- READLINE(HighScores.txt, 0) but your data does not contain a score value. Can you please post some data that corresponds to what you will be reading? Further questions: 1. do you need to parse the names into …

This sounds like a homework assignment. We are here to offer help if you are having trouble in specific areas but we will not do your homework for you. Please show us what you have done so far.

I would not recommend VBA. I suggest vb.net. Before I retired I would have just written this up in vbScript with one entry per email written to a log file as 2013-12-09 13:49:27 confirmation sent to <email address> But you would probably find vb.net with a folder watch component easier. …

You can find an example [here](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks)

Change your code to Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Static x, y, z As Integer If x < 3 Then BackColor = Color.FromArgb(x, y, z) x = x + 1 ElseIf y < 3 Then BackColor = Color.FromArgb(x, y, z) y = y …

I haven't been to a fast food place in years. I think the final straw was when McDonalds started selling its McCrap (or was that McWrap). It finally woke me up. Then I started noticing new slogans popping up **Arby's** - "I'm so hungry I could eat at Arby's" **Taco …

Let's keep in mind that while there are genuine "experts" here on daniweb, there are also a lot of regular folk like me who are competent, but far from experts. I may not know more things than the person posting a question, just different things, so I may be answering …

The only thing that could make it worse was if a lot of people had guns.

Two problems: 1. You didn't provide any details. 1. We are not going to do your homework for you.

You can use the MouseEnter and MouseLeave events as in Private Sub Button1_MouseEnter(sender As System.Object, e As System.EventArgs) Handles Button1.MouseEnter Button1.Tag = Button1.BackColor Button1.BackColor = Color.Blue End Sub Private Sub Button1_MouseLeave(sender As System.Object, e As System.EventArgs) Handles Button1.MouseLeave Button1.BackColor = Button1.Tag End Sub In this example I use the Tag …

That question can't be fairly answered without knowing what you use your computer for. If you use your computer mostly for consuming content (web browsing, watching videos, listening to music) then likely 8.1 is appropriate (although I personally find 8.1 horrendous). If you are a content creator then I recommend …

"select * from Tran where Acno=" & TxtAcno.Text & " and name='CASH'"

Used to play some piano many years ago.