Private Sub btnAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddNew.Click


Dim myConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data...

Hi,

When I tried to add your code, it reads an error saying 'Option strict On disallows implicit conversions from 'Integer' to 'String'.

Hi,

I have a quick question.. regarding my data.. when I make the customerID as Number in the access database, it is prompting a error 'data type mismatch in criteria expression' however, when I...

Thanks for your help!

I just thought maybe I could do it on just one button, but I guess it doesn't work... Once again, thanks for your help .. really appreciate it:)

Hi,

Then how would I go about this? See, the concept is when I do a search, the info will be populated onto all the textboxes and if I tried to add a new item after that, the data from the search...

Hi,

Well, on clicking 'add new item', it should clear the textfields, so that the user can input their new details.

Hi,

Here is the code:

Private Sub btnAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddNew.Click


Dim myConnection As New...

Hi,

I am getting an error called 'Data type mismatch in criteria expression'. This only happen when I tried to add an item. Can anyone tell me what is the problem with my code? I am using...

Hi,

I have a question regarding my vb.net code. I have a button called 'Add New Item', when the user clicks on that button, the text fields should be clear. I tried this code...

Hi,

Thanks for all your help! It worked....:)

Hi,

Here is my code to do a Select function. However, how do I modify this code to do a search function. In other words, the user has to input the customerID onto a textbox 1, which then...

Hi,

Okay, If I were to search the ID, how do I go about that. Can you provide me a sample code? Thanks

Hi,

I need help with importing database into form. The problem that I am having is, when a user inputs their firstname into textbox1, it should search for their name in the database (MS Access) ,...

Hi,

I am using Northwind database and I am trying to delete the Products information from the Products table using SQL. However, when I tried to do that, it says that it can not be deleted...

Hi Alekhan,

Here is the sample code:

Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ nwind.mdb;User Id=admin;Password=;")
Dim myCmd As New...

Hi Alekhan,

Yes, that is the issue that I am having. I am stuck pretty much there. How do I delete the relationship by using the code rather than doing it manually?

Thanks

Hi Alekhan,

I need to delete from the table called 'Salary' in where there is a column called 'hours'. How do I do that?

Thanks

Hi,

I have used oledb connection with sql to populate one of my listbox with data from the database. However, I have to remove. on click of a button. the information from a specific table called...

Hi,

I have a quick question. I have a listbox, on click 'all' btn, it should transfer to the right listbox. So, those are working fine. However, I have to prompt an error message when the user...

Hi,

I have an another quick question, since I am new to vb.net..

I got all the listbox buttons working fine now..

When a user clicks on any of the buttons without choosing an item from the...

Hi,

I have an another quick question, since I am new to vb.net..

I got all the listbox buttons working fine now..

When a user clicks on any of the buttons without choosing an item from...

Hi,

I need help with Listbox. I have two listboxes and when one selects from the listboxLeft it should go to listboxRight and that seems to be working fine. However, when I tried to remove the...

Hi,

Can someone help me with Listbox issue in Vb.NET. I have two listboxes and I want on a click function, to transfer selected items from listbox 1 to the listbox 2. How do I go about that?
...

Hi,

I have a quick question, I have this code on the combobox and I wonder how I should change this to the Select..Case format:

'If the user select a Minus sign on the combobox then
...

Hi,

Thanks for that code. It worked fine. Sorry to bother again, but if I were to use a Select.. Case function, where would I implement it and how? Is it possible to implement it on the Textbox 3,...

Hi,

Thanks for that code. It worked fine. Sorry to bother again, but if I were to use a Select.. Case function, where would I implement it and how? Is it possible to implement it on the...

Hi,

Thanks for the quick response. Since I am totally new to VB.net, I have so many questions in my mind. First of all, if I were to restrict the user from tying an alphabet characters, how...

Hello,

I have four textboxes in my calculator. Textbox 1, Textbox 2, Textbox 3 (acts for the Operand) and Textbox 4 (the result).

I have a button called Result and when clicked, I want the...