4,911 Posted Topics

Member Avatar for mattster

Several times a day I browse the vb.net forum (and a few others) to see what's new and to check if there are any questions for which I can provide feedback. What happens to those questions that don't fit into an existing forum? If, for example, I had expertise in …

Member Avatar for happygeek
2
488
Member Avatar for jayamandalapu

Google [How to use the Windows 7 Task Scheduler](https://www.google.ca/search?q=how+to+use+the+windows+7+task+scheduler&oq=how+to+use+the+windows+7+task+scheduler&aqs=chrome..69i57.8684j0j8&sourceid=chrome&es_sm=93&ie=UTF-8)

Member Avatar for Reverend Jim
0
131
Member Avatar for jason allen

Free keyfinder at [url]http://download.cnet.com/3001-2094_4-10694022.html?spi=f34fce99a2880231b8f73c05a543996e[/url] or you can Right-Click on My Computer and select "Properties". The bottom section of the window should say "Windows Activation" followed by "Windows is activate", then "Product ID: #####-#####etc"

Member Avatar for smr.sresta.1
0
1K
Member Avatar for diafol

My nephew had a tattoo done in 2009 that he said was extremely painful. The artist got halfway through and asked if he wanted to wait until the next day to complete it. The response was "If I get out of this chair there is no way you'll ever get …

Member Avatar for ChrisHunter
5
1K
Member Avatar for malatamil

Just add more clauses to the ORDER BY as in ORDER BY fld1 DESC, fld2 ASC, fld3 ASC

Member Avatar for malatamil
0
120
Member Avatar for Reverend Jim

Cliven Bundy does not have the "ancestral rights," claimed because his family had worked the land since the 1870s, before the creation of the BLM. In fact, according to Clark County property records, his family purchased the land in 1948 from Raoul and Ruth Leavitt. The United States Bureau of …

Member Avatar for Reverend Jim
0
433
Member Avatar for ckide

I like to have a mix. I like the adjustable fonts of an ebook reader but I need a paperback when I want to read in the hot tub. I don't have a dedicated ebook reader like Kindle or Nook. I just use Calibre on my laptop.

Member Avatar for hericles
0
377
Member Avatar for mouaadable

Try downloading a linux livecd and booting off that. Copy the files to another folder/device then delete the bad folders.

Member Avatar for mouaadable
0
293
Member Avatar for Nebil

The problem is that you are leaving the control to ask the user to enter a value and when you get back to the textbox the got-focus event fires again. If the only valid response to "Do you want to define a value" is "Yes" then why do you ask …

Member Avatar for Reverend Jim
0
161
Member Avatar for nitin1

I've never personally had a problem with Dells and there have been five in my immediate family. On the rare occasions I've had to get service it was always easily arranged with a fast turnaround time. I was even able to get a replacement battery out at the cottage in …

Member Avatar for blackmiau
0
444
Member Avatar for iAssistant

-24C with a wind chill of -31C. It's warmer now than it's been for the last few days.

Member Avatar for Stuugie
0
4K
Member Avatar for vbshad

You do the INSERT when there is no value entered for locid. Is this really what you want? Also, why are you using ExecuteReader for the INSERT? Use ExecuteNonQuery instead. You use ExecuteScalar when you are returning one value or ExecuteReader when you are returning more than one value. In …

Member Avatar for Mr.M
0
2K
Member Avatar for Elvi

Regardless. You are still asking for someone to do your homework for you. You haven't shown us that you have put in any effort.

Member Avatar for Elvi
0
255
Member Avatar for vbshad

If you are using OleDb then try access = "UPDATE tbl_location WHERE locid = ? SET locname = ?, locadd = ?"

Member Avatar for vbshad
0
747
Member Avatar for dw85745

Nobody can say with any certainty what languages will still be around in 20 years. Even 5 years is difficult with some. If you want to port old VB programs with as little difficulty as possible I suggest just going to vb.net. I think you'll find porting vb to C++ …

Member Avatar for Reverend Jim
0
374
Member Avatar for henryz_box

Let's look at the statement Dim MySQLStatement As String = "INSERT INTO player_log (Last_Name, First_Name) VALUES (' " & TxtLastName.Text & " ' , ' " & TxtFirstName.Text & " ')" If we plug in values "Jim" and "Jones" it evaluetes to INSERT INTO player_log (Last_Name, First_Name) VALUES (' Jones …

Member Avatar for henryz_box
0
1K
Member Avatar for rikb53

You can find lots of good stuff in the [Code Snippets](http://www.daniweb.com/software-development/vbnet/code/_/58) section such as how to [Export ListView to Excel Spreadsheet](http://www.daniweb.com/software-development/vbnet/code/464769/export-listview-to-excel-spreadsheet)

Member Avatar for Reverend Jim
0
233
Member Avatar for John.

>Who wants to be seen by clients discussing grey hat matters on bing? For that matter, who wants to be seen on Bing?

Member Avatar for emmaharward789
0
322
Member Avatar for henryz_box

You don't need a datareader. All you need to know is if you have a record that matches the username and password. cmd.CommandText = "SELECT COUNT(*) FROM userinfo" & " WHERE usname = '" & textbox1.Text & "'" & " AND [password] = '" & textbox2.Text & "'" If cmd.ExecuteScalar …

Member Avatar for henryz_box
0
14K
Member Avatar for AQWst

Question 1 Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Cursor.Position = MousePosition + Button2.Location - Button1.Location End Sub Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click Cursor.Position = MousePosition + Button3.Location - Button2.Location End Sub Private Sub Button3_Click(sender As System.Object, e As System.EventArgs) Handles Button3.Click …

Member Avatar for Reverend Jim
0
108
Member Avatar for Start4me

The reason is that Me.Controls("CheckBox" & i) evaluates to a generic control and while a generic control has a **Visible** property, it does not have a **Checked** property. That is why you have to cast it to the correct control type first. You could also use a more specific for …

Member Avatar for Reverend Jim
0
335
Member Avatar for Sadaf_1

You could use the COALESCE function. Given two or more parameters, it evaluates to the first parameter that is not null. SELECT fieldName = COALESCE(fieldName,0) FROM myTable SELECT fieldName = COALESCE(fieldName,'0') FROM myTable will replace all null values with 0 or '0' in the returned data depending on whether the …

Member Avatar for Reverend Jim
0
342
Member Avatar for tirumalai

Judging by the other post I'm assuming MS Access. I suggest you have a look at the [W3 SQL Tutorial](http://www.w3schools.com/sql/sql_intro.asp)

Member Avatar for Reverend Jim
0
149
Member Avatar for tirumalai
Member Avatar for Centorpe

And even if it is read only you can still set the background colour to anything you want. Or you could just use a label control.

Member Avatar for Centorpe
0
88
Member Avatar for asif49

Have you considered a career in technical writing? Your thoughts are clear and well organized and you seem to have a good grasp of proper grammar. There is a demand for people with those skills.

Member Avatar for iamthwee
0
630
Member Avatar for Ryan Huxley

We are not going to teach you everything you need to know about databases. I suggest you do a little googling. You can start with [W3 SQL Tutorial](http://www.w3schools.com/sql/default.asp?PHPSESSID=300ae3404d5fa2612f238abeebb8869c).

Member Avatar for Reverend Jim
0
171
Member Avatar for Papa_Don
Member Avatar for akkbkht

As far as I know you can't override that behaviour from within the application. Access to system folders is restricted to protect your system. If it could be overridden from with the application with some code then the system would not be aable to protect itself from malicious code. There …

Member Avatar for deletedaccount
0
3K
Member Avatar for tshukela.george

Please post your code. My guess is you are modifying the in-memory copy of the table but not saving it to the database.

Member Avatar for Reverend Jim
0
173
Member Avatar for Gus_19

The statement Not_Business = True & MessageBox.Show("missing dob") is invalid. MessageBox returns type DialogResult. You have to compare that result to something to get a boolean. Example If MessageBox.Show("missing dob") = DialogResult.yes What are you trying to accomplish with that statement?

Member Avatar for Reverend Jim
0
308
Member Avatar for OTOSystem

What is the code behind **Knock()**? You could always create a sound file that has the desired sound repeated. Then you would only have to call the routine once as KnockKnock()

Member Avatar for oussama_1
0
193
Member Avatar for airhalynn101

Do you mean that when you bring up a blank form (so you can create a new entry) the ID number of the record that will be added is displayed? The answer depends on whether or not there is only one user hitting the database at a time.

Member Avatar for airhalynn101
0
2K
Member Avatar for Sushma Somesh

Try rec.Open "select * from Body_Markings_new where [Part Number] like '%" & txtsearch.Text & "%' ", conn, adOpenDynamic, adLockOptimistic It's my own preference, but I always avoid putting spaces in field names. It always leads to problems like this.

Member Avatar for Sushma Somesh
0
206
Member Avatar for Dr.Lipe

There is no such thing as a SQL form, and reading information from an ini file does not require SQL.

Member Avatar for Reverend Jim
0
79
Member Avatar for Cygnus333

I use [DIVX Converter](http:\\www.divx.com) but I have also used [virtual dub](http://www.virtualdub.org/index.html) which can be run from the command line so you could build a batch file or script it to scan and convert a folder.

Member Avatar for SaintAce
0
643
Member Avatar for KushMishra
Member Avatar for PerplexedB

I think a better way to do this would be Private Sub TextBox1_KeyPress(sender As System.Object, e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress If e.KeyChar = vbCr Then Me.SelectNextControl(Me.ActiveControl, True, True, True, True) e.Handled = True End If End Sub Private Sub TextBox2_KeyPress(sender As System.Object, e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox2.KeyPress If e.KeyChar = …

Member Avatar for Reverend Jim
0
1K
Member Avatar for lavanya uppala

A handy reference for regular expressions can be found [here](http://www.regexr.com/). It also includes an area for interactive testing of regular expressions. You can use the provided sample text or paste your own sample text and refine the expression until it gives you the results you want.

Member Avatar for PerplexedB
0
1K
Member Avatar for prashant9928

A handy reference for regular expressions can be found [here](http://www.regexr.com/). It also includes an area for interactive testing of regular expressions. You can use the provided sample text or paste your own sample text and refine the expression until it gives you the results you want.

Member Avatar for Reverend Jim
0
395
Member Avatar for Nebil

Try doing a `SELECT COUNT(*)` on the record with that ID. If you get a result of 0 then the record does not exist.

Member Avatar for Nebil
0
568
Member Avatar for ahmedsa
Member Avatar for cmo3223

To start with, you do strInput = InputBox("Please Enter Test Scores", "Enter Score") which prompts the user to enter the test scores. Then (supposedly once the user enters the scores) you ask for 10 more scores in For intCounter = 1 To 10 Step 1 Before the loop you set …

Member Avatar for Reverend Jim
0
171
Member Avatar for GilbertB

>filter up every Company ID on keeping only two records What exactly do you mean by this?

Member Avatar for Reverend Jim
0
222
Member Avatar for Dani
Member Avatar for Nebil

Try removing the single quotes from the numeric fields as in qry = "SELECT * FROM [per_diem_accomodation] " & " WHERE [project number] = " & projcode & " AND [employee number] = " & empcode & " AND [current month] = '" & resultdate & "'" Also, you didn't …

Member Avatar for Nebil
0
206
Member Avatar for ahmadzina85

In the last week or so I posted a new tutorial on creating and managing background threads. You can find it [here](http://www.daniweb.com/software-development/vbnet/tutorials/477520/how-to-use-backgroundworker-to-create-threads).

Member Avatar for Reverend Jim
0
389
Member Avatar for mrkm1188

Go to a command prompt (running as administrator) and type icacls /? I think you want the /remove[:[g|d]] Sid removes all occurrences of Sid in the ACL. With :g, it removes all occurrences of granted rights to that Sid. With :d, it removes all occurrences of denied rights to that …

Member Avatar for Reverend Jim
0
188
Member Avatar for danyalempire
Member Avatar for ddanbe
0
360
Member Avatar for alpha849321

You could download and burn a Linux LiveCD, boot from it, then copy the folder/files to a FAT32 partition. Then delete the original files and copy the copied folder/files back to their original locaion. That should kill the original ACLs (access control lists).

Member Avatar for LaxLoafer
0
412

The End.