sackymatt

Hi all I have a situation, i have a form that has a datagridview, on form load, it selects the data from sql db, now what i want is when i right click on one row, i should be able to delete that row and it should also get deleted …

Hi all, i have a table "Contracts", with fields CompanyNumber, MaturityDate and other fields. i have a form in vb.net, with a textbox that should check if the entered company number exist in my db, if it does it should check whether the maturity date is bigger or less than …

Hi all, I have a small problem that i cant figure out. i have a program that i want when a user select a date from a datetimepicker, it filters evrything from the datagridview that are for that date.. Hare is the code i have Private Sub Button1_Click_1(ByVal sender As …

Hi all, i would like to know how to access data in the database using vb6 and the database in ms access 2007. for example i have a table in the database called item, with data fields such as itemname, item-id ,etc, so if i want to access the data …

Hi all, I want to know how i can decrement the value of quantity in stock in my data base. This would be based on how times an item is purchased. So every time an item is clicked, i want to show the quantity has decreased in the database. I …

Hi guys am new on VB6 and would like your urgent help, i have created my POS half way and have created a form for sales, now what i want is when i enter an item code all the other information related to the item diplays at the respective text …

hi there, i have a form in Vb6 and a msacess 2007 database connected using ADODC, on a form is a listbox that i want to populate with the table data from the database, the name of the database is Storenw and the table from which i want to access …

HI THERE, i wana connect msaccess database to vb6, so that i can be able to view the data in the tables in the database in the listbox, so far this the code i used to connect but get this error "The connection cannot be used to perfom this operation. …

[code] option Explicit Private Sub cmdAccept_Click() Dim cn As New ADODB.Connection Dim strCNString As String Dim rs As New ADODB.Recordset Dim Txt As String On Error GoTo ErrHandler 'Connect to database strCNString = "Data Source=" & App.Path & "\databasename.mdb" cn.Provider = "Microsoft Jet 4.0 OLE DB Provider" cn.ConnectionString = strCNString …

Hi guys, am new in this, i have created a database in msaccess and connected it to vb6 using Adodc, now ma question is , how or wat tool must i use to display or populate data from data from the database, ist a listbox , a grid or which …