[adodc] Forum Topics

I am trying to update some records.The moment the line Adodc2.Refresh executes, I get an error message saying that the "Operation is not allowed when the object is closed" Yet, when I put "On Error Resume Next", it updates the records as I want it to. Please help me thank …

i am having a problem after saving the entire project. i have connected the database with Visual Basic forms using Adodc connectivity. when i close it and reopen it after a few hours to continue working the Adodc connectivity is lost and shows a blank box instead of Adodc box.

greetings everyone!. I'm making Clinic system for my project. I just want to ask how to get the total quantity of the medicine and display it on textbox. I'm using using vb6 and adodc. Any help will be greatly appreciated.Thank you... Table name inventory fields: Medicinename StockQuantity

Dear users. i am making user choice database programe. how can i make relationship between multi combo box. IN FORM1 for example. Table 1 customer name city name area name NY FL TO ETC tabel 2 INVOICE combox1 area(NY) thyen display specify area customers IN COMBO BOX 2 combox2 customers …

Can someone help me I'm having some problem with this. I am supposed to make a sytem that will alert if the medicine was expired. here is my code. Private Sub DataGrid1_Click() On Error Resume Next Command2.Enabled = True With frmmed1 .Combo1 = Adodc1.Recordset.Fields("MedicineName") .Text3.Text = Adodc1.Recordset.Fields("StockQuantity") .Combo2 = Adodc1.Recordset.Fields("Expmonth") …

Run-time error '-2147217887 (80040e21)' Multiple-step operation errors. Check each status value. === The one highlighted was: **Adodc2.Recordset.Update** Private Sub Command1_Click() Adodc2.Recordset.AddNew Text13.Text = Label19.Caption Text14.Text = Label15.Caption Label5.Caption = Text6.Text + "-" + Text7.Text Label3.Caption = Text1.Text Label21.Caption = Text10.Text Text11.Text = Text6.Text Label17.Caption = Text3.Text + ", " + …

I'm really new in ADO for just a substitution on Data Control (I cannot dl any access 2003 D:) --- Whenever I enter command3, it says: *Compile Error: Method or data member not found* and the highlighted one was **.EOF** Code: Private Sub Command3_Click() Adodc1.Recordset.MoveFirst Adodc1.Recordset.Find "SID = '" & …

I WAS CREATING AN INVENTORY SYSTEM USING VB 6 AND ADODC. HERE IS MY CODE [CODE]Private Sub Command1_Click() Dim temp2 As Integer Dim temp As Integer If Text1.Text = 0 Then error.Show Else If Text1.Text > 0 Then purchase.Show Form38.Hide Set rs = New ADODB.Recordset rs.Open "select *from purchasetable", cn, …

can u help me about this

delete the highlighted row ADODC DATAGRID MYSQL