izyrider

I am using update query statment but is not working for this code [CODE]Dim myConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../lms/DBLMS.mdb") Dim item As Integer myConn.Open() myComm = New OleDbCommand("UPDATE tblVehicles SET Vehicle_Type = " & cboVehicle_Type.Text & ", Vehicle_Model = " & txtVehicle_Model.Text & ", Plate_No = " & …

Is it possible that when a user clicks, the fact that she may have clicked on two overlappping labels, for instance, be responded to ? In other words could the Sub for a click on Label1 check that Label2 has actually been clicked simultaneously ? Thanks.

Hi guys pls help me with my problem this is for my update code [CODE]Private Sub BtnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnUpdate.Click Dim StrSQL As String = "updatePatient" classLibrary = New ConnectionLibrary classLibrary.openConnection(strConnection) 'label1.text = databasestatus If Not classLibrary.isConnectionOpen() Then Exit Sub End If classLibrary.initializeCommand(StrSQL) classLibrary.addParameter("@IPD_ID", …

Hi, I m using vb.net with access 2007. I have field with datatype "datetime" and values in format dd/mm/yyyy e.g 8/2/2011. Now I have problem when i fire a query [CODE] SELECT * FROM tbl_name WHERE tbl_name.datefield= (Select Max(tbl_name.datefield) from tbl_name)); [/CODE] I have some records with dates 11/1/2011 and …

If i may ask, Is it possible to update multiple rows in a database at once. if yes, how? I have a dbase of almost 100 people. Each one has a unique reference number like this: NPHCDA/MSS/109 but i want to update the records of the hundred people and include …

Hi, I have a Windows Form frmMain() holding seven more-or-less unrelated UserControls, "ucFlopsy", "ucMopsy", "ucCottontail", etc... I say "more-or-less" because each of the seven UC has three similar public read/write properties: IsLocked (a boolean indicating if the following two properties are "Locked") IsLockedID (if IsLocked=True then IsLockedID is an integer) …

Hi, I m usng Ms-Access 2007 with vb.net. My problem is that I have a table with column name strval which has following values: 2,3,43,5,6 etc in each row. Now I want to search for that row which contains e.g 2 in cloumn strval . i use SELECT * FROM …

I have a combo populated with: [code] With Me.cboOwner '// populate cboOwner .DataSource = dtMyCos .DisplayMember = "CoName" End With [/code] DtCos datatable contains: CoID int CoName string So far so good! Then I have a second combo cboIssuer that needs to contain all the items in cboOwner **PLUS** an …

Hi, I have a DataTable oDT. oDT is populated from SQL Server with 6 columns including a column "bAAA" of varbinary(200) I have a function fx(ByVal byteArray As Byte()) as String I would like to add a calculated column to oDT something like this: [code] oDT.Columns.Add("sAAA", GetType(String), fx(bAAA)) 'bAAA is …

Hi, My first post, please be gentle. I have 64 booleans - all must be displayed on a single screen as a series of checkboxes ([B]no[/B] - I don't care about the 65th bool, [B]yes[/B] - it [U]must[/U] be a single no-scroll screen on the UI). As a VBA-refugee, I …