Reverend Jim

Show us what you have so far. We don't know what kind of database you are using or how you want to connect. Are you using ADO, OleDB, SqlClient?

Disconnect your computer from the internet and run the app. If it complains then the answer is yes. Alternately you can run the performance monitor as perfmon /res and monitor your app for network activity.

Please do not resurrect old threads. This one has been dead for more than two years.

Please do not resurrect old threads. This one has been dead for more than five years.

Is there an option so that times in Daniweb are displayed in the default (user selected) time format? For example, times on my system are displayed as 18:56 instead of 6:56pm.

You can add items more concisely by ListView1.Items.Add(New ListViewItem({"Column1","Column2","Column3",Column4"}))

I carried a cell phone for ten years before I retired because I was on 24x7 standby. When I retired I turned it in and never got another one. I plan to continue not having one. However, if I did own one I would continue using it as long as …

I suggest you run a disk diagnostic to see if the drive is failing. If you have around $90 to spare (the last time I checked) I highly recommend getting a copy of SpinRite. There is nothing that can touch it for diagnosing disk problems and doing maintenance/repair/recovery.

We'd have to see the structure of the table. Is there one record per student? Are there multiple records where the multiple records have to be added before comparing to other students? Are the grades stored as numbers or letters? The structure of the table will determine the format of …

I moved this to the VB 4-5-6 forum.

I use vmWare but not the vmWare player so this may not help, but in the full version you can set up a Windows folder to be shared with the vmWare session. Before you bother with that though, have you tried just dragging the file from the vmWare session to …

You could always google and include a string that is found on the profile page like dani last seen site:daniweb.com The link containing **/members/** should be at the top of the results

In pseudo code, you could create a listbox then do for each item in the array if item > average then add item to the listbox end if next Do you know how to use a listbox? If not then you could also use a multiline textbox.

You have to use a connection object with the appropriate connection string. That string will depend on what type of database you are connecting to. Sample connection strings can be found [here](http://www.connectionstrings.com/).

If it's MS SQL then BETWEEN is correct.

You can find connection strings [here](http://www.connectionstrings.com/) and a SQL tutorial [here](http://www.w3schools.com/sql/)

In a recent [thread](http://www.daniweb.com/software-development/vbnet/threads/464300/time-conflicts-in-a-reservation-system-vb.net-and-mysql#post2021369), the thread title on the summary page is Time conflicts in a reservation system (vb.net and mysql) However, because of the large font used on the actual thread page, the title displays as Time conflicts in a reservation system (vb.net When beginnerdev went to answer the …

You can set the position by PictureBox1.Location = New Point(xpos,ypos)

Google how do I use an access database from vb.net and read.

A shorter way of coding that would be to reference the controls dynamically as Dim pbx As PictureBox = Me.Controls("PictureBox" & dr("Course")) pbx.Tag = dr("FacultyID") pbx.Image = System.Drawing.Image.FromStream(myMS) That replaces the entire select-case block with three lines of code.

Start by having a look [here](http://www.daniweb.com/software-development/vbnet/threads/438760/cmd-command-error#post1885905). You can always hide the textbox with the results.

The thread identified it as mysql.

Please post your input data. Also, why are you using the ToString method on data that is already a string? Is it your intention to only add strings of a certain minimum length or is there some other reason you are checking for length >2, >3, etc. The code you …

It can happen. It might help to have a Linux system on CD (or even better, on a USB stick) to boot from to check the drive. You also might want to invest a few dollars in a product called SpinRite. It is excellent for disk maintenance and data recovery. …

You can access the controls on Form1 from Form2 by fully qualifying them as (for example) Form1.TextBox1.Text

If you do SELECT COUNT(*) FROM appointments WHERE NAME = 'Jim' AND ABS(DATEDIFF(day,appt_date,GETDATE())) < 90 then you will get 0 if there are no appointments booked for Fred within 90 days of today. Just substitute the proposed appointment date for GETDATE().

Would you please explain more fully?

It's your homework assignment. If we do it for you then you won't learn anything.

1. What database? 1. How temporary?

I suggest using a listview in details mode rather than a listbox. There are examples using ADO, SqlClient and OleDb [here](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks). Multicolumn listboxes are a pain.

Please add the following line after the creation of the string **sql** Debug.WriteLine(sql) And post the result here. In order to tell you what is wrong with the query we have to see the query. To avoid SQL injection attacks you should be using [parameterized queries](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks)

Let's take the string "http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/463764/super-easy-one..-i-hope". If we assign that to the variable s, then do f = Split(s,"/") then f(0) = "http:" f(1) = "" f(2) = "www.daniweb.com" f(3) = "software-development" etc. We can similarly split f(2) using "." as the split character to get the dotted elements of the …

I'm playing around and I came up with this. Create a form and place a PictureBox in Normal SizeMode. Dim original As Image Dim imgscale As Double = 1.0 Private Sub Form1_Load(sender As Object, e As System.EventArgs) Handles Me.Load original = PictureBox1.Image End Sub Private Sub Form1_MouseWheel(sender As Object, e …

Depending on what format the source data is in you might want to look at [BULK INSERT](http://www.akadia.com/services/ora_bulk_insert.html). You could also look at [bulk load](http://docs.oracle.com/cd/E14899_01/doc.9102/e14763/bulkload.htm)

What is your level of expertise? Do you know anything about OleDB?

You shouldn't store the cost of materials in the Products table. The fields, TotalMaterialCost, TotalWoodCost and TOTALCOST should be calculated in the query. If you store the actual costs in the Products table then you have to update all of the fields every time a price changes (as you are …

I'm not sure what you are asking. You set the interval to whatever value you want.

That is such a general question that it cannot be answered. You might as well as "how do I write a program to do something". The answer depends on what type of data you are searching. There are different types of searches. If the data is unsorted then you have …

We've been lucky (mostly) with our dogs. Our first was an Irish Setter that wandered into our livingroom (door was open while the paint dried) in 1981. We contacted the owner who didn't want him anymore. Our best dog ever. Since then we have had another Irish Setter (puppy from …

And a smiling one at that.

If you want to match numeric ranges to strings then please give us the exact mapping and we can help with the code. Your question is very unclear as to what you want.

Norway, Oman, Nigeria, Sweden, Estonia, Netherlands, Singapore, Ecuador. or how about Bosnia, Uruguay, Lebanon, Libya, Scotland, Honduras, Italy, Thailand.

You start a new project and drag a textbox and a button to the form from the toolbox.

I think it's like posting a sign that reads **IGNORE THIS SIGN**

How do I know this isn't someone phishing for email addresses who will then SPAM me to death? If you want to ask me questions other than "how do I..." then feel free to send me a PM through daniweb. If this is legitimate I'd be happy to answer some …

I can't give you a complete query without more information but to calculate durations you can use DATEDIFF as in SELECT Name,Interval=DATEDIFF(DAY,ApplicationDate,InitialSurvey) FROM mytable Details of DATEDIFF [here](http://www.w3schools.com/sql/func_datediff.asp)

That looks like the correct syntax. What does your recordset look like? Is the field name correct? What is the value of searchtxt.Text?

I'm going to go out on a limb here and say that maybe the text box isn't empty. Maybe it just looks empty. It could have blanks in it. Set a breakpoint at the start of the if and look at the value in the debugger.

I had a lot of problems uploading files. It turned out the problem was a Firefox plugin, Ghostery. Try disabling all plugins, then clear your cache and try the upload again. I finally got pissed enough at Firefox that I just switched to Chrome. I haven't had a problem since.