JunglesMcBeef
Programmer
- Sep 18, 2003
- 266
G'day,
I have done something a little silly. I am using Office 2000, on Windows 2000 Pro. I have created a form in Access 2000 with a flexgrid. I also have an old installation of visual studio 6.0 tools on my computer, which I think includes a lot of the VB libraries (in particular, the flexgrid object). I have added the reference to the flexgrid object library to my VBA project and it all works fine.
Now, when I go to use this form on a workstation with Office XP, on Windows 2000 Pro, i get the error '438': "Object doesn't support this property or method". I can't install VS6.0 on the workstation because I no longer have access to a legal copy of it. The method it doesn't support is Format() and the first property it stopped at was flxgrd.MergeCells. This is really doing my head in because I wouldn't have a clue which library the Format() method is part of. I know that the MergeCells property is part of the Flexgrid library, but I can't install that library (unless there is a way to install a .msm file without it being in a .msi package). So I think the problem is that I have included libraries that are included only within the VS package. Is there some way to individually install a library or have I wasted my time creating this form, because it won't be supported on any machine that doesn't have a VS components install?
If anyone can give me any information or help on this it would be much appreciated. Thanks.
I have done something a little silly. I am using Office 2000, on Windows 2000 Pro. I have created a form in Access 2000 with a flexgrid. I also have an old installation of visual studio 6.0 tools on my computer, which I think includes a lot of the VB libraries (in particular, the flexgrid object). I have added the reference to the flexgrid object library to my VBA project and it all works fine.
Now, when I go to use this form on a workstation with Office XP, on Windows 2000 Pro, i get the error '438': "Object doesn't support this property or method". I can't install VS6.0 on the workstation because I no longer have access to a legal copy of it. The method it doesn't support is Format() and the first property it stopped at was flxgrd.MergeCells. This is really doing my head in because I wouldn't have a clue which library the Format() method is part of. I know that the MergeCells property is part of the Flexgrid library, but I can't install that library (unless there is a way to install a .msm file without it being in a .msi package). So I think the problem is that I have included libraries that are included only within the VS package. Is there some way to individually install a library or have I wasted my time creating this form, because it won't be supported on any machine that doesn't have a VS components install?
If anyone can give me any information or help on this it would be much appreciated. Thanks.
