In VB6 and ACCESS how do I run ACCESS Macros and queries using VB code (I use recordset, etc)
Posted on 2007-11-27
I program in VB 6 using ACCESS by using recordset commands (movefirst, movelast, Addnew, etc.). I now need to be able to execute macros and queries withing the database using VB code. With Currendb set to the table I need to be able to run the Macros and queries. I know how to convert a macro into a vb function and insert it into a VB program, how ever it dos not work. What references and components must I have installed. I have Microsoft Access 11.0 Object Library on. as well as DAO 3.6.