Search results

  1. G

    VBA error 3035

    Thank you's to MarkK and RuralGuy!!!! Especially for quick response. Appreciate the help. Anxious to hear why replacing string var in OpenRecordset made a diff.
  2. G

    VBA error 3035

    Closed db and reopened. Query ran. no error. Why do you suppose that is?
  3. G

    VBA error 3035

    Error occurs on db = CurrentDb
  4. G

    VBA error 3035

    Strange. Replaced string var with SQL statement in quotes, not getting VB error: Run-time error '3734: The database has been placed in a state by user 'Admin' on machine 'my machine' that prevents it from being opened or locked.
  5. G

    VBA error 3035

    Hi thanks for quick reply... No lookup fields. Query appears to run and then bombs out with error on openrecordset command
  6. G

    VBA error 3035

    BOM is a table
  7. G

    VBA error 3035

    Code causing the error is: Set rs = db.OpenRecordset(sfilt, dbOpenDynaset) Actual error is System Resources Exceeded.
  8. G

    VBA error 3035

    Using Win 7, Access 2010 I have a relatively straightfwd vba code that steps through a table and updates a field by placing a string that represents an operation number. The base table has 56K records and I am stepping through each record and based on certain criteria updating the value, record...
Back
Top Bottom