I'm writing a scheduling program in Access. All the tables, forms and queries have been set up and now I'm into writing code to 'make it all happen'. I'm in over my depth but slowly it is coming together. I've got to a stage where the program has become too large and am wondering how anyone can write a large program in VBA when you are only allowed 64kB in a single procedure. How do I break it up when most of the program consists of a large Do...While loop?
Just while I have your attention, I read somewhere that you can only have one recordset open at a time. Is that true?
Just while I have your attention, I read somewhere that you can only have one recordset open at a time. Is that true?
Last edited:
