-
Replied To a Post in How can I check whether the quiz answer was correct?
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 … -
Replied To a Post in Get Count in text box from Access
I am assuming that the Sub, Recordset, does what I expect. You didn't provide the code so I can't tell for sure. Dim qry As String qry = "SELECT COUNT(*) … -
Replied To a Post in Random Facts
@mike said >one of the primary uses for firearms is to commit suicide @jwenting said >You claimed the main reason people buy guns for is to commit suicide Regardless of … -
Replied To a Post in Simple SQL Error (Beginner) Please help!!!
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 … -
Replied To a Post in recordRedundancyVB2010
You could do Dim qry As String = "SELECT COUNT(*) AS numrec FROM Applicant" & " WHERE LAST_NAME = '" & txtappln.Text & "'" & " AND FIRST_NAME = '" … -
Replied To a Post in Invalid Column
Please post the SQL code to create the database. -
Edited Random Facts
I'm hoping that people will post unusual or little known facts here. It would be proper to include a link to a source for confirmation. Here's a start. Speedy Gonzales … -
Replied To a Post in Random Facts
Lest you think I've got nothing better to do than rag on the gun nuts... Over the past 50 years, gun owners have been responsible for over $2 billion in … -
Replied To a Post in Why does Windows XP refuse to die?
>they screwed up networking with home-groups That's one of the reasons I stick with the **Pro** version of all of the Windows releases. It gives me more networking options. -
Replied To a Post in Creating a new database and a listener
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 … -
Replied To a Post in Get Count in text box from Access
That's your code that doesn't work. There is nowhere in my code where you will find If txtShaha = .Fields!Sha_no Then There is no need for the **If** statement. Doing … -
Replied To a Post in HOW COULD I UPDATE DATASET WITHOUT USING FOR LOOP IN ONE COMMAND
I see a large number of queries in a large block of undocumented code. What are you trying to do in one query? B y the way, because you are … -
Replied To a Post in Voting online
I am prepared to name you a dozen or so examples of poll intimidation and vote rigging by Republicans in recent years. I presume your "Black Panther" reference was implying … -
Replied To a Post in Bad Grammar
These are technically not grammar issues but... ##You should use "less" when talking about non-discrete quantities, and "fewer" when talking about discrete quantities. For example: 1. This line is for … -
Replied To a Post in Get Count in text box from Access
I repeat, is there a question? -
Marked Solved Status for Failed to check registry key is exist with parenthesis
Hi guys, need help here. I would like to check the registry key is exist for this code: Sub main() Dim regKey As Object = Registry.LocalMachine.OpenSubKey("SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{D75F38ED-E49A-48F3-9B72-D4BC5FE73B44}", True) ' Check if … -
Replied To a Post in Failed to check registry key is exist with parenthesis
I don't have that particular key so I can't run the same test, however, my example does show that the brace brackets are not the cause of the problem. -
Created Random Facts
I'm hoping that people will post unusual or little known facts here. It would be proper to include a link to a source for confirmation. Here's a start. Speedy Gonzales … -
Replied To a Post in How to read an Excel spreadsheet using ADODB
It is not required. -
Replied To a Post in shortcut of multiple if and else statement
I will make a couple of suggestions that may help. You can access a control by creating the name dynamically. For example, if you have five radiobuttons named q111, q112, … -
Replied To a Post in shortcut of multiple if and else statement
You are giving snippets of information instead of describing the problem. If you are not going to post the problem you are trying to solve with enough information for us … -
Replied To a Post in shortcut of multiple if and else statement
That's not "explaining the logic". That's just giving one example of what happens when you select one particular set of buttons. Are the radio buttons for each question worth 1, … -
Replied To a Post in To Import data from Excel to MS access
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. -
Replied To a Post in shortcut of multiple if and else statement
Perhaps if you explained the logic behind the code we could suggest a shorter alternative. -
Edited How to read an Excel spreadsheet using ADODB
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 … -
Edited How to read an Excel spreadsheet using ADODB
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 … -
Edited How to read an Excel spreadsheet using ADODB
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 … -
Replied To a Post in excel import into sql database
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. -
Created How to read an Excel spreadsheet using ADODB
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 … -
Replied To a Post in Memorable Quotations
“I always said that if I wasn’t studying psychopaths in prison, I’d do it at the stock exchange.” – Robert Hare, creator of the Hare Psychopathy Checklist -
Replied To a Post in Hare Psychopathy Checklist
“I always said that if I wasn’t studying psychopaths in prison, I’d do it at the stock exchange.” – Robert Hare, creator of the Hare Psychopathy Checklist -
Replied To a Post in How is the weather today in your country?
Anybody remember Ray Bradbury's short story, "All Summer in a Day"? After more than three months of polar vortex super-chill we are going to +1C today. They keep telling us … -
Replied To a Post in To display data in combo box from database
How about a little more detail? -
Replied To a Post in To Import data from Excel to MS access
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 … -
Replied To a Post in shortcut of multiple if and else statement
@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 = … -
Replied To a Post in Voting online
As for "modernized voting"... Since the introduction of touchscreen voting, anomalous congressional election results have been increasing. In 2000 and 2002, Senate and House contests and state legislative races in … -
Replied To a Post in SQL Query + Progressbar
I was referring only to the responsiveness of the query. In my opinion, a progressBar that does not reflect reality is worse than useless. Even in the best case, the … -
Gave Reputation to akajmer in Display Specific data in listview
how to create a database in SQL by which it can be linked with vb 6 -
Replied To a Post in SQL Query + Progressbar
SQL queries return sets. You issue the query then wait for the response. There is no loop into which you can embed a progress bar update. Doing a SELECT COUNT … -
Replied To a Post in The last song you heard/ listened to
Vincent as covered by Josh Groban. -
Replied To a Post in Voting online
A famous US billionaire recently proposed that you should get one vote for every dollar you pay in taxes. I presume he is exemptinig sales tax because that would be … -
Replied To a Post in Voting online
>scratched and clawed his way to the top spot I completely disagee. He's a spoiled rich snot who was handed everything he ever got. I forget who said it but … -
Gave Reputation to mike_2000_17 in Voting online
> Bush would still have won had there been a recount. The problem with the 2000 Florida elections was not about the recount, but about [the disenfranchisement of tens of … -
Replied To a Post in Check if there is an existing record on ms access 2007
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 … -
Replied To a Post in SQL Query + Progressbar
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 … -
Replied To a Post in HOW COULD I UPDATE DATASET WITHOUT USING FOR LOOP IN ONE COMMAND
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 … -
Replied To a Post in Voting online
>You need to pay more attention to Canadian politics instead of American politics where you have no say one way or the other. Sort of like the average American voter. … -
Replied To a Post in Things I hate about TV shows
I believe E. E. "Doc" Smith actually considered the possibility decades ago. In "First Lensman" he wrote >He flashed up to within one and a quarter detets, stopped, and checked … -
Replied To a Post in Voting online
>That never happened. Yes. It did. While the other networks waited for official results, Fox News just went ahead and called it for Bush. The other networks decided to follow … -
Gave Reputation to Stuugie in Bad Grammar
I think I'm not a fan of anything ung, it's all dung to me.
The End.