Recent content by jpinto

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 &...