We recently installed the Flexibility add-on for Macola Progression. This allows you to add functionality through VBA. We also use a SQL 2000 server for the databases. I had been trying to do some record navigation using ADO, but the more I struggled the more I realized that there is a big difference (limitation?) between VBA and VB. I found this after I opened Visual Studio 6 and found options/methods/properties not available to me in Progression VBA for Flexibility.
Does anyone know of a good source for learning VBA/ADO? Or is there a better method than ADO for data manipulation? I have pleanty of VB sources, but I need something more specific to my situation. Any help is appreciated. Thanks.