Reverend Jim

I took a soda straw (a nice fat one is ideal) and taped it to the end of a vacuum hose (if you use the vacuum hose without reducing the diameter you risk sucking the keys off your keyboard). Then I used the straw to vacuum out the keyboard. Granted, …

I'm going to make a suggestion or two without knowing the complete structure and intention of your table ("something like" does not help me be more precise). Having two separate but equal tables is rarely a good idea as it makes aggregate queries more difficult. Also, you are limiting your …

My father-in-law got one of the first Vic-20s. I waited until the Commodore-64. I hacked away at that (even got a couple of articles published in The Transactor). I was also an early adopter of the first Amiga. I remember getting a 40 meg (huge capacity) hard drive for $800. …

You didn't mention what post.

>I get 75 errors for Resources is not a member of my What is the rest of the error message? Can you post all of the errors? What version of Visual Studio are you using? Does your project use any third party controls?

A dataset does not exist in the database. It is created in memory inside a running app. Same thing with a datatable. What exists in a database is stuff like tables, views, stored procedures, triggers, etc. As I recall you installed SQL Server Management Studio. If it is visible there …

I use [Networx](http://www.softperfect.com/products/networx/) under Windows 7. It will likely work under 8 as well. It's free.

>They can't expect you to do double work That hasn't been my experience.

You double click on an entry (a student) in a listview. This brings up an edit form. If you click on cancel (which is what you stated), typically the response is to discard the changes in the edit form so hitting refresh would be pointless as there are no changes. …

The SQL command (you didn't specify what type of database) to create a table looks like qry = "CREATE TABLE [xxxxxxx] ( " _ & " [LastName] varchar](50) NOT NULL, " _ & " [FirstName] varchar](50) NOT NULL, " _ & "CONSTRAINT [PK_xxxxxxx] PRIMARY KEY CLUSTERED " _ & " …

If you install the (free) Microsoft Sql Server Management Studio then you can right click a database or table and select "SCRIPT ...", then pick an option such as CREATE, DROP, etc and it will generate the required commands to the clipboard or a query window. Instructions on how to …

There is an example of one [here](http://www.daniweb.com/software-development/vbnet/threads/268430/if-statement-in-a-okcancel-msgbox). It is a thread that was marked as solved three years ago. A new poster popped in just to say "Thanks. It worked in my VB2010 also." Hardly a valid reason to resurrect an old thread.

You can use Access for the database back end and do all the programming through vb. Likewise you can install (free) MS SQL Express (which would be better in my opinion) and use that. I would not use Excel. Depending on which version of vb you are using you might …

>CBeebies (Very Small Children's BBC). That would make it the **BaByC** instead of the BeeBeeCee

>i want go next 2 GroupBoxes afther Clicking the Next Button.. I don't understand what you want to do. If you have three groupboxes on the one form then why would you have to click next?

You have four button controls but you haven't told us what they do and you haven't even given them descriptive names. Instead, you dump the code here with almost no explanation and expect us to figure out what it is supposed to do. Put some effort into asking the question …

Your update query string is "UPDATE Status_tbl SET " & Statustype & "= @1 WHERE CustomerID=" & customerID What is the name of the date field you want to update? You didn't specify the field name in the query. What is the purpose of that field? If it is to …

We appreciate your willingness to contribute but please check the dates on posts before you respond to them. This thread is several years old and it is likely that the original poster (OP) no longer needs help with this issue. Reviving this thread pushes more recent threads further down the …

I reformatted your code. Notice how you are missing a few **End If** statements. Close your if blocks and you should be fine.

@akeera - Please start a new thread and show us you have made some effort by providing some code. @Don - I'll say it one more time. If you specify **integrated security** then you don't need a userid and password. You are authenticated by your windows logon.

It might consume infinitesimally more because of increased disk activity due to swapping but that would only be because of the stepper motor. That's my guess. Good luck measuring something that small.

Hey maj. SELECT * FROM myTable WHERE StoreID = someid ORDER BY DOB will return a recordset for a given store with DOB sorted from earliest to most recent. Don't forget to use parameterized queries.

You can download the [service manual](http://www.dell.com/support/Manuals/us/en/19/Product/xps-17) which should provide details.

But before you reverse the string you should normalize it. 1. convert everything to upper or lower case 1. remove all non-letters If you were to check the phrase "Able was I ere I saw Elba" without normalizing it would not be flagged as a palindrome. After normalizing it would …

The @ values are just place holders. The names, such as @phone, don't have to be the same as (or even remotely close to) the actual fields in the database. It's just good practice to make them the same or similar. As I pointed out in the example, when using …

To start with, you'll declare the array as Private intTemps(6, 1) where the row numbers range from 0 to 6 and the columns from 0 to 1 (giving you 7 rows and 2 columns). To input the data you will have to prompt for two values for each of the …

You can set the advanced properties on a folder to make it a compressed folder. Then, you can store the string in a file in that folder. The file, and therefore the string, will be automatically compressed when saved and decompressed when read into the app.

Considering your apparent obession with achieving stats like **Top Members by Activity Points Today** and your prior **endorse me and I'll endorse you** signature, I agree that **a little fishy** is appropriate here. Most of us prefer quality posts over quantity and a scoring system that reflects that. As I've …

I got here from your last thread. I'm assuming you are changing the sa password because you don't want to leave it as the default when you installed (an all too common mistake). I'm not sure what your problem is with establishing a connection. Is your database set to use …

I would skip the enumeration. I would also declare an array to hold the various counts such as Private Counts() As Integer = {0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0} Then when you generate the next rollsum you just have to do Counts(rollsum) += …

Look at the example [here](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks) which also shows you how you should be forming your queries using parameters rather than concatenation. By the way, if you are using SQL Server you should not be specifying the name and location of the database file. You should let the database server handle …

So some moron out there decided to start a **this site sucks** thread, basically poking the bees' nest with a stick for fun just to provoke a response and you all jumped right in. Do you really expect to accomplish anything? I prefer to just ignore comments like this unless …

Can you provide a little more code? Are you using SqlClient, OleDb, ADO, etc? Does the sample code [here](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks) help?

The little dot that shows that a user is online is a great feature. I just responded to a question from a user who was flagged as online. I thought it would be a nice feature that if a user is online when someone posts to his/her thread that there …

I don't see a variable that contains the angle. I expected to see something like Private Angle As Double in which case whenever the **scored** code is executed you could reset **Angle**. By the way, you should be using **Public** or **Private** instead of **Dim** when declaring at the class …

Assuming the lines are terminated with CRLF you can do Dim lines() As String = text.Split(vbCrLf) If you are not sure if they end with CRLF or just LF you can do text = Replace(text,vbCr,"") Dim lines As String = text.Split(vbLf)

You should use this instead TextBox1.Text = DateTimePicker2.Value.Date

I'm having intermittent problems with scrolling via the wheel on my Logitech Anywhere MX mouse. I have been spending a lot of time editing old DaniWeb posts to correct formatting errors so this is where I tend to see the problem as it requires a lot of scrolling. After a …

Depending on how many random numbers you need and over what range, regenerating when you get a duplicate might not be a good idea. For example, if you need ten random numbers from 1-1000 there won't be a problem. However, if you need 1000 random numbers (with no duplicates) then …

Add the closing single quote as command.CommandText = command.CommandText & " where name like '%" & Me.txtsearch.Text & "'"

>ExecuteNonQuery() is not an error. It is a statement. Please post the text of the error message. Because the source of the error is likely the query, please also post the value of SqlQuery. It would also help to know the field types of your database table. For example, if …

You have to specify a particular SQL Server instance in the connection string. For example, on my computer it is "Server=.\SQLEXPRESS;Database=PUBS;Trusted_Connection=yes;" or "Server=JIM-PC\SQLEXPRESS;Database=PUBS;Trusted_Connection=yes;"

If you are using Access the correct syntax is SELECT * FROM table WHERE datefield = #datevalue# otherwise use SELECT * FROM table WHERE datefield = 'datevalue'

You could keep the database name (fully qualified path and file) in a settings variable like My.Settings.DatabaseFile and use the connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & My.Settings.DatabaseFile & "MOMS.accdb" You'd have to prompt for the location on the first run then save that value back into the settings variable for subsequent …

What do you consider valid text? If you limit it to only letters and blanks then names like **Ryan O'Neal** and **Joseph Gordon-Levitt** would both be invalid. Why not just allow any characters, then parse on a blank. If you get more than two names then disallow. If the two …

>I'm not sure I see the benefit of showing who down votes, given the potential for revenge voting. >usually, it's someone who, as you call it, "takes revenge" on someone that downvoted them and did bother to explain why. You mean as opposed to the downvotes (which have been reversed) …

I defined a datagridview to pull a table froom a database. The datagridview has AllowUserToAddRows set to false (otherwise there is a **Nothing** row at the end). Clicking any cell causes that entire column to be copied to the ListBox. Private Sub DataGridView1_CellClick(sender As System.Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick …

You can scan through the rows with a For Each, then scroll to the row (if found). An example is For Each row As DataGridViewRow In DataGridView1.Rows If row.Cells(1).Value = txtName.Text Then row.Selected = True DataGridView1.FirstDisplayedScrollingRowIndex = row.Index Exit For End If Next

Awesome!!

I'd have to see your table definitions to recommend a solution but the problem is that if you want to specify two tables in a query then the tables have to be related (share a common field). Please post the table definitions and we'll see what we can do. In …