
Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
Thank you Doug
It is working fine now in my Access apps.
However, when I try the same thing in my VB apps, I get the
Compile error: Constants,fixed-lengths strings, arrays, user-defined types
and Declare statements not allowed as Public members of object modules.
I created a new class module and put the Declare FindWindow after Option
Explicit as I have done in Access.
Any suggestions
george
> Take a look at http://www.mvps.org/access/api/api0013.htm at "The Access
> Web" for how to determine the class name of all running applications. Use
[quoted text clipped - 17 lines]
> > Many thanks
> > george
Douglas J. Steele - 27 Feb 2005 21:18 GMT
Odd. I don't see anything public in that code (other than the fEnumWindows
function).
Do you have to use a class module, or can you use a regular module instead?
Otherwise, you're probably better off asking in one of the VB groups. (I
don't have VB installed on this machine, so I can't test anything for you)

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Thank you Doug
>
[quoted text clipped - 33 lines]
>> > Many thanks
>> > george
GeorgeMar - 28 Feb 2005 02:01 GMT
Thank you Doug
I moved everything into a module and it works fine.
regards
george
> Odd. I don't see anything public in that code (other than the fEnumWindows
> function).
[quoted text clipped - 41 lines]
> >> > Many thanks
> >> > george