How do I launch a query stored in MS Access from VB6?
I have a HUGE query in MS Access that I want to launch from VB6 by passing 2 parameters from two VB6 combo-boxes to the MS Access db---which will then load the results of the query into a VB6 MSHFlexGrid control.
It's not practical to try to write such a huge query again in VB6 code, so that's why I'm pursing the pass-the-parameters solution. I've seen some EE posts on this, but I can't get a clear grasp of them---I guess I need someone to talk me through it.
Anyone know how to do this?
Many thanks for any help.....
Microsoft AccessVisual Basic ClassicVisual Basic.NET
It is simply just easier to open the querydef and copy the SQL string. All you have to do is modify the part where it gets its parameters.