Quote:
|
Originally Posted by gazzae
Ah right, control arrays aren't supported in VBA AFAIK.
|
Ahh, that could be a problem then.....
Do I actually
need a control
array though? All I need to be able to do is create a control, assign the properties, give it a name..... It wouldn't persist once the form was closed.
Quote:
|
Originally Posted by gazzae
You could create a bodge job control array but that would mean having to create the labels yourself.
|
By hand, or with code?
Quote:
|
Originally Posted by gazzae
There is a CreateControl command in VBA but I remember it not working correctly.
|
Ah, sounds about right for MS and Access
Quote:
|
Originally Posted by gazzae
Do you have a copy of VB? You could use access as the backend and create your frontend in VB.
|
That would be a nice solution, we've actually got a SQL Server running here on the site so that would be even better. I've got VB6 at home so I could certainly knock something up.....
The only problem with that is that (because of the restrictions on our usage of the machines, and on what we can put on the network) we would never get it approved for use at work.
We're still using NT and Access 95 - that should give you an idea of how much fun we have
