4,901 Posted Topics
 | A string of the form "MM/yyyy" is not a valid date. A valid date has day, month and year parts.  |
| | Let's ignore the error checking for now and just get the logic right. In pseudo-code we have clear output string for 3 students get name set total to 0 for 3 scores add next score into total next calculate average as total / 3 convert average to letter grade add …  |
 | CURTIME([fsp]) As of MySQL 5.6.4, if the fsp argument is given to specify a fractional seconds precision from 0 to 6, the return value includes a fractional seconds part of that many digits. Before 5.6.4, any argument is ignored. |
 | A little more information please.  |
| | "Action figure" is only a marketing term used to sell dolls to boys. |
 | Just have a look at the output from Sysinternals' Filemon to see what it is possible to detect. |
| | Re: Data mining I'll address the first problem - you have to provide more information. I do not know what PCA/SVD is. Please provide a sample of the data and an explanation of what you are trying to do. "Data mining" is far too broad a term to be of use. |
| | Here's my current setup Dell Inspiron 1720 laptop 42" digital TV with just about every input imaginable Wired/wireless router What I want to do is stream audio/video from my laptop to the TV wirelessly. Is there a device I can connect between the router and the TV, along with software … |
 | Try running it in a command prompt as Administrator. |
| | Why not just Public Class Form1 Private CountDown As Integer Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load CountDown = 15 Timer1.Interval = 1000 Timer1.Start() End Sub Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick CountDown -= 1 If CountDown > 0 Then Me.Text = CountDown … |
| | That's the trouble with TNBT (the next big thing). The world seems to oscillate between hype and boredom. We get TNBT and that's all you hear about for a few months or possibly a few years. Then TNBT comes along with new hype and all you hear about TLBT (the … |
| | You could tell us what line is causing the error. Instead of doing an AddNew, do an insert query such as sql = "INSERT INTO Applicant " & " (LAST_NAME, FIRST_NAME, MIDDLE_NAME, ADDRESS, " & " CLASSIFICATION, CONTROL_NO, BARANGAY) " & "VALUES('" & txtappln.Text & "'," & " '" & … |
| | I did the same thing for a browser app that I wrote. I also wanted to be able to rename the current file but I ran into problems because loading the file directly leaves the file in use. If you load the image using a filestream then the file is … |
| | A few problems here 1. you haven't said what DBMS you are using 1. you haven't said what programming language you are using 1. you apparently haven't put any effort into this yourself 1. you expect us to do this for you with almost zero input |
| | Or you could replace the single quote in **hi what's up** with two single quotes as in **hi what''s up**.  |
 | Please post the value of dr("cstmrpic_name"). It would also help to comment out the error handling lines and identify which line is throwing the error. |
| | |
| | You could do Dim qry As String = "SELECT COUNT(*) AS numrec FROM Applicant" & " WHERE LAST_NAME = '" & txtappln.Text & "'" & " AND FIRST_NAME = '" & txtappfn.Text & "'" & . . . rs.Open(qry, con, 2, 3) If rs("numrec").Value = 0 Then 'the record does … |
| | I did an edit on [this code snippet](http://www.daniweb.com/software-development/vbnet/code/339714/simple-way-to-add-a-fade-effect) to coect the code formatting but it isn't working. What gets displayed is not what I edited. Please see the two attached snaps to compare what I edited and what is being displayed.    |
 | And what are you having a problem with? I suggest you start by reading [this](http://www.daniweb.com/software-development/vbnet/threads/424836/please-read-this-before-posting). It's at the top of the thread list for a reason. |
| | What type of database are you using? Oracle? Access? MS SQL? MySQL? |
 |  |
| | Would you put Federation outposts in the Neutral Zone? My understanding of a DMZ is that's where you put stuff you are willing to expose to those outside your secure area. In that case my response would be NO.  |
| | How about a little more detail?  |
 | Your declaration should be kv = New Dictionary(Of String, String) You should probably be using something like "=" for a separator because a comma might appear in a definition. If you use a common handler for the radio buttons you won't need to use a complex If statement. For example … |
| | Can I ask why, since you are a beginner, you are choosing to learn VB6 rather than VB.net?  |
| | Let's say you have the field, id, as the only field in both tables. The query INSERT INTO tb2 SELECT id FROM tb1 WHERE id NOT IN (SELECT id FROM tb2) will do what you want. |
 | Sample ADO using MS SQL and copying data to a listview. Change the connection string for access. Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Open("Driver={SQL Server};Server=.\SQLEXPRESS;Database=PUBS;Trusted_Connection=yes;") rec.Open("SELECT au_lname,au_fname,zip FROM authors", con, CursorTypeEnum.adOpenStatic) Do Until rec.EOF ListView1.Items.Add(New ListViewItem({rec("au_lname").Value, rec("au_fname").Value, rec("zip").Value})) rec.MoveNext() Loop rec.Close() con.Close() |
| | It depends on what kind of update you are trying to do and that depends on things like 1. are you updating one table or multiple tables 1. are you updating one field or multiple fields The more information you can provide the more likely you are to get a … |
| | The constraint Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) prevents you from adding a record unless EmployeeSupervisorID already exists. How, exactly, do you add the supervisor to the table? The constraint will prevent you from adding the supervisor until you add his/her supervisor first? Of course, it's 3:00 am and I … |
| | Change it to dim qry as string qry = "INSERT INTO Accounts(Username, Password, Fname, Lname, Age, Cnumber, Eadd, Add) VALUES ('" & logintxt.Text & "', '" & passwordtxt.Text & "', '" & firstnametxt.Text & "', '" & lastnametxt.Text & "', '" & agetxt.Text & "', '" & contacttxt.Text & "', …  |
 | A share path is usually specified as \\MACHINE\SHARE\PATH\FILE where SHARE is defined on the sharing machine and is never specified as an actual device like C:. If an administrative share is used, C: might be replaced with C$. In any case, if you can't browse to the file using the … |
| | Re: Voting online I think we need a dual system. The voter makes his/her selections on a computer monitor, then a ballot is printed with the selections clearly indicated. The voter reviews the printed ballot then either 1. presents it to a poll clerk to complain about a machine error, in which case …  |
 | Seen it. Love it.  |
| | You start by reading the manual. If you do not know how to create a database then you have not bothered to do any reading. Thirty seconds of googling will give you the answer. |
| | I did this Dim key As String = "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{002568CE-7595-46A3-A1C1-53F41A4ADC34}" Dim regKey As RegistryKey = Registry.LocalMachine.OpenSubKey(key, False) If regKey Is Nothing Then MsgBox("Registry key does not exist!") Else MsgBox("Registry key exists.") End If on my system (Windows 7 Pro) and it worked just fine. Note that I used **False** as the … |
| | You can't. If a user has the rights to save (modify) a file then by saving gibberish or blanks the file is effectively, if not physically deleted. All you can do is ensure that backups are done frequently and have employees (or ex-employees) punished severely and publicly. |
| | If your Excel spreadsheet is laid out as regular columns and rows with a header row that identifies the columns then this code will allow you to read the data using ADODB the same way you would read records from a database table. To try this code 1. Create a … |
| | @oussama - How long did it take you to unravel that? For expressions that already evaluate to Boolean there is no need to do the comparison so If q.Created = True Then can be written as If q.Created Then |
| | That would depend on the format of the data. It is possible to connect to an Excel spreadsheet as an ADODB data source but there are certain conditions. What is the format of your spreadsheet? |
| | I just posted a sample in the [Code Snippets](http://www.daniweb.com/software-development/vbnet/code/_/58) with the title [How to read an Excel spreadsheet using ADODB](http://www.daniweb.com/software-development/vbnet/code/474907/how-to-read-an-excel-spreadsheet-using-adodb). Have a look and see if that helps. |
| | A progress bar is only useful if you know the endpoint. For example, if you know how long the process will take, or if you know how many iterations are necessary then you can display a progress bar indicating where you are in the process. |
| | One field in your table should be declared as being the PRIMARY KEY. What you can do is execute the query SELECT COUNT(*) FROM Applicant WHERE PKField = somevalue If the query returns the value 0 then that record does not exist and it is safe to add it. You … |
| | In the FormClosing you could always do e.Cancel = True But you should also give the user some other way to exit. For example, if the user selects **Exit** from a menu you could set a class flag as in Private ReallyExit As Boolean = False Private Sub Form1_FormClosing(sender As … |
| | Try typing this at the command line net use /persistent:yes If it is set to no then connections will not be automatically re-established. |
 | This might be tricky but you could try to edit the partition table on the disk. You could try [this free one](http://www.pendriveapps.com/partition-table-editor-ptedit/). Make sure you save a copy of the initial values before you start changing them. If you need to get more "intimate" with the disk you can try … |
| | Does the same thing happen if you use IE or chrome? |
| | I started havinig an odd problem with Chrome a couple of weeks ago. Today I tried to resolve it by uninstalling and re-installing Chrome but the problem persists. The window display frequently (as in every minute or so) refreshes, then displays two overlapping images. Please see the attached shot. If … |
| | There are several examples in the [Code Snippets](http://www.daniweb.com/software-development/vbnet/code/_/58) including [here](http://www.daniweb.com/software-development/vbnet/code/423678/create-controls-at-run-time-with-events). If you want to create an array of references to existing buttons then it helps to pick good names. For example, if you name your calculator digit buttons btn0 to btn9 then you can do Private btnDigits() As Button (declared … |
 | Your loop is creating a new Panel (pnl) then trying to remove it from the Me.Controls collection but you never added it to the Me.Controls collection to begin with. If you are trying to get a reference to a panel for deletion then you should not use the New keyword. … |
The End.