Search results for query: *

I've allready seen the FAQ mentioned. It doesn't solve my problem. The main problem is in what event of the primary form should I put the txtDescricao.text=ValueSelected instruction! Thanks, João Pinto

I've looked at the FAQ and the one that you've mentioned. None have the solution to my problem. My problem is: what event should I call on form1 to retrieve the value that I've selected on form2 and assign it to a field on form1? Example: On form1 I click a button that opens form2 that has a...

Does annyone knows how to solve this problem, please? Thanks. João Pinto

Hello bobmori, The first think that I've tryed was what you say: Private Sub OK_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_Button.Click Me.DialogResult = System.Windows.Forms.DialogResult.OK OcorrenciaSelected =...

Hello, I've a form that when the user clicks on a button opens a new form with a treeview with data for the user to select. After the user selects the data and clicks OK button I want to pass the value of the row selected to a field from the first form. I'm using a variable to put the value of...

I've a treeview on my form that as a Parent node "Familia" and a child node "Ocorrencias". Here's the code: Private Sub frmListaOcorrenciasTree_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim x, y As Integer Dim NomeFamilia...

The problem was with the field "Password" on the SQL statment because "Password" is a reserved word from VB. So is as simple as doing this: sSQL = "UPDATE Utilizadores SET [Password]=@Password WHERE User= '" & Utilizador & "'" instead of this: sSQL = "UPDATE Utilizadores SET...

Annyone can help, please? I'm stuck with this problem for days! Thanks, João Pinto

I still get the sintax error message on the da.Update(ds, "Utilizadores") line of the code! João Pinto

Even tryed to use the code provided by you for update throught dataset/dataadapter but I get the same sintax error message. I've tryed to do what you told me on access but I didn't got more information about the error. João Pinto

Jebenson, Thanks for your help but I get the same error message saying that there is a sintax error on the UPDATE. Do you see anything wrong on the code? Maybe the SQL statment is not correct? João Pinto

I've tryed with the OleDbCommand code that you provided but I get a sintax error on the UPDATE. I don't see nothing wrong on your code, do you? Thanks, João Pinto

Now I've the following code: Imports System.Data.OleDb con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=""C:\Programaçao\Visual Basic\Inapal\ReportIt\ReportIt.mdb"";" con.Open() sSQL = "SELECT * FROM [Utilizadores] WHERE (User= '" & Utilizador & "')" da = New...

I didn't find anny help on the link that you provided. Can annyone help me with the above code, please? Thanks, João Pinto

Hi, I've the following code used to update a record on my Access database: con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=""C:\Programaçao\Visual Basic\Inapal\ReportIt\ReportIt.mdb"";" con.Open() sSQL = "SELECT * FROM [Utilizadores] WHERE (User= '" & Utilizador &...

Thanks for your help. In fact, the mistake that I had was the single quotes. Without it, it works fine. João Pinto

Hello, I'me trying to select the records that are on the database with the field 'Data" between two dates that are inserted into two fields: "DeData" and "aData". I've the following code but I'm getting an error on my SQL statment: Private Sub DeData_ValueChanged(ByVal sender As System.Object...

Hello, I want to change the cursor type when the mouse goes over a certain column in a dataview. I've the following code: Private Sub DataGridView1_MouseHover(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGridView1.MouseHover If DataGridView1.CurrentCell.ColumnIndex...

TigGiver, Can you please show me some sample code of what you mean? Thanks, João Pinto

Hello, I need to display on a form, on a textbox, the value of a sum of records that is on a Query on my database. I've the following code: con2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=""C:\Programaçao\Visual Basic\Inapal\ReportIt\ReportIt.mdb"";" con2.Open()...