Search results

  1. A

    Complie Problem VB6

    I just created a new subroutine in VB6, as below. I now get a compile time error message: "Statement invalid outside Type Block" Can anyone enlighten me as to why? Private Sub ImportData() code etc. End Sub Thanks for any help, ADO-Nick
  2. A

    BeginTrans, CommitTrans & RollbackTrans

    When should BeginTrans, CommitTrans & RollbackTrans methods be used - always? I'm writing a program that will only ever be used by one user at a time - does this make a difference? Thanks, ADO-Nick
  3. A

    Updating fields in recordset

    The following is an extract form my programming, using ADO, to store a value - arValues(i) - into a field - Fields(1), having first created a new record in the recordset. objRS.AddNew objRS.Fields("Data_ID").Value = intIndex objRS.Fields(1).Value = arValues(i) objRS.Update The first &...
  4. A

    ADO Help! / Field Properties

    Hi All, I am trying to set a property defined by MS Access, which applies to an ADO object but isn't recognised by the Jet Database engine. Help that I've found so far suggests that I must: 1) create the property 2) append it to the properties collection 3) then it can be set in the normal...
Back
Top Bottom