Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mansukh20
  • Content: Threads
  • Order by date
  1. mansukh20

    Using Data Environment and Data Report

    Hi Guys, I am trying to print the customer records on for one of my tables. Rather than printing all the records, how can i implemented a set of codes to print the selected records identified by a primary key. The selection is done using a DataCombo control. Manny
  2. mansukh20

    Generate autonumber

    Hi guys, I have developed a system using oracle 9i and visual basic 6. Im not quite sure how to generate an autonumber for the next row. All i need is when i click on add button on my form, i want the next number in the series to be generated and displayed on the assigned text box. It would be...
  3. mansukh20

    Update sql statement

    Hi guys, I am trying to update my database using the code below unfortunately it seems to be doing nothing at all. Any suggestions? Dim strSQL4 As String strSQL4 = "UPDATE VEHICLE SET VEHICLESTATUS = 'Booked' WHERE VEHICLEID = '" & dbcVehicleID.Text & "'" adoVehicleUpdate.RecordSource =...
  4. mansukh20

    Using ADODC control instead of Connection string

    Hi Guys, Im finding difficulty implementing this code using ADODC control component. Any suggestions Private Sub dbcClassType_Change() Dim sql As String sql = "SELECT * FROM RATE WHERE CLASSTYPE = '" & dbcClassType.Text & "'" Set RS = New ADODB.Recordset RS.Open sql, CON...
  5. mansukh20

    Using two datacombo

    Hi guys i have this code: Private Sub DataCombo2_Change() Dim sql As String sql = "select * from creditcard where CUSTOMERID = '" & DataCombo2.Text & "'" Set RS = New ADODB.Recordset RS.Open sql, CON DataCombo3.ListField = RS2!creditcardnum When the customerID is...

Part and Inventory Search

Back
Top