Search results

  1. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Yes, lesson learned that this is something to be careful with. Just seems like if a checkbox On Click event on a report is an option that is not supposed to be used then it wouldn't be designed into the software to begin with. If Assumptions![Checkbox On Click].[Can Be Used On Reports] = True...
  2. Mike_10

    Solved Report Checkbox On Click Fires Twice

    That's only for a form. I'm only talking about reports because that's the only place that exhibits this behavior. There is not an After Update event for a checkbox on reports.
  3. Mike_10

    Solved Report Checkbox On Click Fires Twice

    I'm surprised people don't use the On Click event for a checkbox. Obviously I have no formal training in this so I've been doing it. There is not an AfterUpdate event for a checkbox so that's why I was using the On Click event. What do most people do instead? Let's say we want to display or...
  4. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Why wouldn’t you want to use it? The user clicks the checkbox, and something should happen. Seems obvious (to me at least) to put the instructions in the On Click event sub. Oh and that something that should happen, shouldn’t happen twice unless the programmer tells it to. Even if it’s poor...
  5. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Why would the sub need to fire twice to make the value change (assuming unbound)? Obviously this isn’t necessary with forms. I just can’t wrap my brain around why this is necessary change the value. At least let the programmer write code to make the value change but don’t fire twice. Would...
  6. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Seems weird to me at least. Why just the checkbox control? Either way, I figured out a simple workaround. If you execute a requery on the report from inside the checkbox "On Click" event it will only run the sub once. The only part to this is that it will not change the value of the checkbox...
  7. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Yes of course I could use a button if this issue is going to remain. Just seems more intuitive to use a check box in this case. I’m giving the user the option to either display or not display a part of the data. It’s just such a bizarre behavior, I’d love to know what’s causing this.
  8. Mike_10

    Solved Report Checkbox On Click Fires Twice

    Yes, viewing in report view and clicking the checkbox from there.
  9. 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...
  10. Mike_10

    Resetting Seek Criteria Inside Loop

    MasterRS contains all records, and was opened with ascending ordering applied by account number, which is the first field (second after the Access defined ID). Often times an account number is used multiple times in that recordset. So UniqueAccountNumbersCOL is a collection of each unique...
  11. Mike_10

    Resetting Seek Criteria Inside Loop

    I edited the code in my post above because some of the indention did not paste correctly and because I inadvertently left out MasterRS.MoveNext inside the inner loop, it is there in the actual code, otherwise it looks like I had a perpetual loop. But @arnelgp, I noticed that you moved that...
  12. 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...
  13. Mike_10

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

    Just to check my understanding here, it is a correct assumption to say that when the table is built via import as per arnelgp's suggestion vs. as an in-memory recordset, that it stores it into ROM leaving my RAM more freed up?
  14. Mike_10

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

    Gotcha, my misunderstanding. I found what you were referring to now. Will do, as soon as I get caught up.
  15. Mike_10

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

    @arnelgp Yes this is exactly what I did, I set up the import spec and saved it, that's what I was referring to when I said "import template." In addition to that, right after I sent that post I remembered seeing, at one time, a way to code the import process, so I'll work on automating these...
  16. Mike_10

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

    Wow you guys are giving me lots to study! Much appreciated. @The_Doc_Man here are the results from your test: Access memory started at 13.7 MB and after starting the procedure slowly walked up finally stopping at 964.9 MB when the out of memory error occurred. This process is consistently...
  17. Mike_10

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

    Sorry all, not sure why my code indentions collapsed, that made it harder to read, I promise I put them in. One more detail that might be of interest, when the error occurs and I check the debugger, "i" is at approximately 190,000, just to give you guys an idea of how far into the loop it's...
  18. 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