Posts by mrbungle

Hmm, just thinking out loud here-

I have a table called "users", and each row will have a few different users. It will include their name, ID number and some other stuff, and also each "user" will have some stats they need to track. So as mentioned above, the text box they enter a "stat" into will need to be saved in their "users" row.

So I guess I opened up another problem-

Dim SQLStatement As String = "INSERT INTO users(stat1) VALUES('" & Me.txtStat1.Text & "')"

I guess if each user needs to log into the app to ensure their stuff is getting added to their row, then this statement above may also be wrong, because I don't see in there how it adds to any one persons specific row... Also, there is a login box at the start of the app that connects to the MySQL database and confirms their login then lets them in under their ID number (which works fine)...

The users ID number is set as a Primary Key in the database.

Dang Codeorder, you've saved the day again! A huge public thanks- this guy has helped me more than anyone can imagine. He's gone above and beyond over and over and over to help me, and it's so much appreciated. Thanks dude!

Need help.

I have a combobox (cmbCharge1) that gets populated by a text file. Inside the combobox, the data inside is laid out like this:

41-1A-1303: EXPIRED REGISTRATION

Now, autocomplete works fine, if I start typing in the statute (like the 41 part). But what I need is for it to autocomplete based of whats after the :

So if I type in EX, then everything starting with EX pops up.

Anyone have a code snippet?