Search results

  1. Mike_10

    Solved Report Checkbox On Click Fires Twice

    I can not figure out why the On Click event for a checkbox placed on a report is executing the sub twice. I double checked this in a new database with nothing else except a blank report with the checkbox and it’s still doing this. What’s going on here? I have a database that I built several...
  2. Mike_10

    Resetting Seek Criteria Inside Loop

    I'm looking for a way to reset my .seek method criteria inside an outer loop so that the inner loop will start over with a new set of account numbers. See below: 'Run through each unique account number and assign values to each field For Gi = 1 To UniqueAccountNumbersCOL.Count...
  3. Mike_10

    "Run-time error '-2147024882 (8007000e)': Out of memory." while building ADO recordset

    Hello, I have done hours of combing the web trying to solve this problem myself but still can't find anything to help. I am not experienced in any type of coding and am trying to teach myself some of the Access VBA coding basics. I have a large text file (590,352 KB) that consist of about 1.1...
Top Bottom