-
Replied To a Post in Problem in copying data from a temporary table to a main table
Do all of the tables have the same structure? What is that structure? Are you getting any error messages? Try changing qry = "INSERT INTO [ptempTable] ([project number],[project name],[description]) VALUES … -
Replied To a Post in Bad Grammar
Here's a bonus one I came across today. A company claims to have a process for producing solar cells that is three times cheaper than existing technology. I don't see … -
Replied To a Post in Bad Grammar
Here's a new one - the difference between further and farther. **Further** is synonymous with **additional**. You would say "further study is needed" but not "She lives further away". You … -
Replied To a Post in Quebec Referendum
I guess the PQ learned a hard lesson about trying to push a referendum on people who quite obviously are not interested. -
Replied To a Post in How is the weather today in your country?
I know what that's like. We had clods living next door to us at the cottage. Once they moved away the climate improved considerably. -
Replied To a Post in Skype
It might help if you posted the error message and number. What version of Windows are you running? -
Replied To a Post in Why does Windows XP refuse to die?
>I hear it's 100x more secure than XP How would you even measure that? That sounds like a blanket statement made by someone who is just pulling numbers out of … -
Replied To a Post in How is the weather today in your country?
I'm in Winnipeg and it was t-shirt weather today (in spite of the several feet of snow on the ground). It was +5C and sunny. -
Replied To a Post in referencing textbox data in vb.net
You'll have to try explaining again. Your description is very confusing. -
Edited referencing textbox data in vb.net
Dim item As String = InputBox("Enter Item ordered", "Place an order") Dim quantity As Integer = InputBox("Enter Quantity odered", "Quantity ordered") Dim price As Integer = InputBox("Enter price", "Price each") … -
Replied To a Post in Syntax error in INSERT statement
You can make the code a lot cleaner and safer by using [Parameterized queries](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks). Here is an example using your INSERT cmd.CommandText = "INSERT INTO Product ([Item ID], [Item Name], … -
Replied To a Post in Add items from database to a listbox
There are examples [here](http://www.daniweb.com/software-development/vbnet/code/445801/use-parameterized-queries-to-avoid-sql-injection-attacks) for both OleDB and SQLDB. Just modify the code to add the items to a listbox instead of a listview. -
Replied To a Post in What works with XP that doesn't with 7
>but with the fact that 7 is just designed for noobs Yeah. My father-n-law finds that it is much easier to screw up his computer under Windows 7 then it … -
Replied To a Post in What works with XP that doesn't with 7
The only problems I have had are with drivers for an old Lexmark printer and a Plextor USB TV tuner. I do not agree that XP is "so much better … -
Replied To a Post in saving checkbox value to database in vb.net
I've never had the need to use databound controls so I can't offer any help in that area. As for applying the code to 20 checkboxes, you'll want to have … -
Replied To a Post in Why does Windows XP refuse to die?
I still use Office 2003. The newer versions all have "the ribbon" which I hate passionately. -
Replied To a Post in saving checkbox value to database in vb.net
Unless **cmd** is declared outside the If-Then-Else it goes out of scope once you try to execute it. You could try the following Dim query As String = "" If … -
Replied To a Post in retrieve data by order
If all values in that column have the same value (zero) then sorting on that column won't do much. Here is an example of sorting on two columns using the … -
Replied To a Post in How to skip the access denied files and folders
Post the contents of the manifest file here. -
Replied To a Post in .dbo database connection string
Never **ever** use 'sa' for anything other than db administration. You can create a user/password by CREATE LOGIN [appUsername] WITH PASSWORD=N'appPassword', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON You'll still have to assign … -
Replied To a Post in How to read line and refer to it.
The easiest way is For Each filename As String In System.IO.File.ReadAllLines(MyFile) MyCustomSub(filename) Next Just add your file processing code in MyCustomSub. Some people would suggest you use a StreamReader but … -
Replied To a Post in .dbo database connection string
You haven't said whether you are on a domain or a workgroup or whether both computers are in the same domain/workgroup. I suggest you try SQL authentication (SQL username/password) and … -
Replied To a Post in Dog Ears
I'd look for another vet. That's an absurd price. -
Replied To a Post in Why does Windows XP refuse to die?
Compare the cost and capabilities of today's hardware with what was available in, say, 1995. Now adjust for inflation. I use the [RBC Calculator](http://www.bankofcanada.ca/rates/related/inflation-calculator/). How much cheaper and efficient do … -
Replied To a Post in VB.NET 2010 Developed apps not working on win7
There are a thousand ways that an application can "not work". What happens when you run it? -
Replied To a Post in .dbo database connection string
You can connect to the server using Windows Authentication or SQL Authentication. The first method uses the Windows logon ID and assumes that both computers are in the same domain … -
Replied To a Post in How is the weather today in your country?
I suppose, given a choice, I would rather have snow than tornados. We had an F5 tornado about 30 miles out of town in 2007 but that sort of thing … -
Replied To a Post in How is the weather today in your country?
More (rude gerund) snow! -
Replied To a Post in Dog Ears
That is true but the point was that if the dog's ears fold down then they are more likely to get dirty and infected. If they stand up (for whatever … -
Replied To a Post in Dog Ears
You can try equal parts of vinegar and warm water. Use cotton balls (not Q-Tips). @AD - Ew! -
Replied To a Post in Swapping Systems
You can't just swap system disks. The OS was installed for specific hardware and will have drivers for that hardware. Even if you got installation media with those computers (and … -
Edited Swapping Systems
I had to get the wife a new pc, she didn't want my 4 year old hand me down. While a 2.3 Ghz system with 3.5 terabytes of disk and … -
Replied To a Post in Dog Ears
As you've heard several times over, take your dog to the vet. He/she can check for infection and suggest a cleaning solution which should be used on a regular basis. … -
Replied To a Post in Trip through the US
Have you taken into account the pollution caused by the production and transportation of the fossil fuels? And not just the normal case but the pollution caused by spillage? -
Replied To a Post in How to recover data from corrupted Word documents
You might try strings.exe from the free [Sysinternals Suite](http://technet.microsoft.com/en-ca/sysinternals/bb545027.aspx). This may allow you to recover all/most/some of the text. -
Replied To a Post in What is your favorite English word?
At least for today, my favourite word is "banned". -
Replied To a Post in .dbo database connection string
If you aren't sure then I suggest you put it on a USB stick and try it before you start burning. -
Replied To a Post in .dbo database connection string
If the database is in the same place (GEN-PC) and the other computer has access rights then you shouldn't have to change the connection string. -
Replied To a Post in Transparent label in VB?
Glad to help. -
Replied To a Post in how we can store values in array
To copy from array1 to array 2 do For i = 0 To 4 array2(i) = array1(i) array2(i+5) = array1(i) Next -
Replied To a Post in vb2012 Create textboxes as array
If you are adding multiple textboxes at design time then the IDE will assign sequential names by default whether you drag and drop or copy/paste. -
Replied To a Post in Database running on SSD
Why does the DB server have to be on the factory floor where all the vibration is occurring? And if it is a requirement for some reason, there are ways … -
Replied To a Post in Transparent label in VB?
Here's an example. I created a blank form, added a picturebox, then added a label at the centre of the picturebox. Note that even though the label is over the … -
Revoked Solved Status for Transparent label in VB?
I'm quite a newbie when it comes to coding, but i feel like i have done everything as it should be. I believe to get a transparent label i need … -
Replied To a Post in vb2012 Create textboxes as array
And if you want to attach event handlers to the textboxes just do AddHandler <event>, AddressOf <subname> as in AddHandler TextBox1_TextChanged, AddressOf MyHandlerSub . . . Private Sub MyHandlerSub(sender As … -
Marked Solved Status for Transparent label in VB?
I'm quite a newbie when it comes to coding, but i feel like i have done everything as it should be. I believe to get a transparent label i need … -
Replied To a Post in Transparent label in VB?
In the form load event handler just add the code to put the label in the proper container. You can set the transparent property there at run time or in … -
Replied To a Post in Transparent label in VB?
It works for me. What version of vb are you using (I am on vb 2010)? If you added the code after double clicking the picturebox then the code won't … -
Replied To a Post in Random Facts
The [hyoid bone](http://en.wikipedia.org/wiki/Hyoid_bone) is the only bone in the human body that is not connected to any other bone. -
Replied To a Post in Use a RAM engine for database: MySQL and MS SQL Server
If you keep your database in RAM then you could set it up for replication to a database on disk so that you would have a permanent version in case …
The End.