Great video, as always. Thanks, Richard. I never thought to open two recordsets at once like that. My tendency is to dim one rs, and then recycle it by opening, closing, and redefining it as needed. I think I was laboring under the impression that only one was allowed at a time. I love how your videos break my preconceptions. Cheers.
I love recordsets! Like you, I've been programming for "many" years. Recordsets are easier for me than trying to figure out SQL. But lately, I've been using the Query wizard(s) to build the SQL statement. LOL!
Great Video, got me playing around with the code, one thing if more jobs are added to the JobT table, how do you stop it from duplicating the records in the JobPartT table?
Great video, as always. Thanks, Richard. I never thought to open two recordsets at once like that. My tendency is to dim one rs, and then recycle it by opening, closing, and redefining it as needed. I think I was laboring under the impression that only one was allowed at a time. I love how your videos break my preconceptions. Cheers.
I love recordsets! Like you, I've been programming for "many" years. Recordsets are easier for me than trying to figure out SQL. But lately, I've been using the Query wizard(s) to build the SQL statement. LOL!
You are awesome Richard
Great Video, got me playing around with the code, one thing if more jobs are added to the JobT table, how do you stop it from duplicating the records in the JobPartT table?
Thanks helpful video❤.
Another grate video very interesting and informative thank you Richard steve b.
Awesome tips in this video thank you. Do you think an alternative method is also possible using query?
There's always alternate methods for everything in Access
amazing 👌
Cool.👍🍵