Sean I like your explanation style but I am getting a error code 0. Everything works as it should (I'm exporting a query to Excel). How do I stop this?
Error code 0 is the best of all! It means no error. So, you probably just forgot to put Exit Sub just before your error block. Your code should exit before the error block, if there is no error.
The technique is the same as for a local table. How to Open a RecordSet in Access VBA and Loop Through the Records th-cam.com/video/7HckYjH_wg4/w-d-xo.html
![เปิดบ้าน นาราเครปกระเทย 1 ไร่ ขายขาดทุนหลัก10ล้าน เอามาใช้หนี้!!! l [Nickynachat]](http://i.ytimg.com/vi/0jz84VFWVP4/mqdefault.jpg)
Sean I like your explanation style but I am getting a error code 0. Everything works as it should (I'm exporting a query to Excel). How do I stop this?
Error code 0 is the best of all! It means no error. So, you probably just forgot to put Exit Sub just before your error block. Your code should exit before the error block, if there is no error.
@@seanmackenziedataengineering You are correct Sean. FYI from the UK, living west of Edmonton Alberta, cheers
@@adrianbridge3474 Welcome aboard!
Excellent explanation.
Thanks!
Hello Sir, how can I open a recordset for a linked table?
The technique is the same as for a local table. How to Open a RecordSet in Access VBA and Loop Through the Records
th-cam.com/video/7HckYjH_wg4/w-d-xo.html
Thank You!
Welcome!
Good tutorial, thank you for sharing, Cheers
Thanks for watching!
error access .→accde File Type .] vba projects is correct
You should try to open the accdb version of the application, not the accde version which has many things locked down.