My question is for the ACCESS 2002. I have started ACCESS and VBA for about 2 months. My approach to the ACCESS is through the VBA route.
Application Background: I have a table (created dynamically through the SQL in my Code) that have X and Y coordinate values. I want to create "Image" object in Run-time and "Move" to the location according to the X and Y value.
So Far: I can move 1 Image object using the values. But I want to create "multiple" objects in Run-time. In VB 6, the "Image" object allows Indexing, but the VBA doesn't.
Question: How can I create Index property for the Image object in ACCESS?
What I "think" are my options: Create my own Class? Automation? Buy a commercially available Modules? Learn VB and create everything from it rather than using VBA.
The form I have crated, gathers two variables (x) and (y). I would like to create many Image objects (small dots in JPEG) over the form and use .Move method to move them into their X and Y location. Since it is a dynamic SQL in gathering X,Y pairs, I assign those values using array.
Perhaps, you suggest another option?
Originally posted by jmrSudbury
Why do you need an index property?