Access

[JohnDK]

Im new to vba, please be patient. Thx

I've created command buttons in a spreadsheet to open an access mdb's located on a comman drive.

I managed to locate and open the mdb's trhu

"GetObject" statement.

It works for some mdb's, but not all.

ON those it doesn't work i can see access opening and then it closes immediatly after opening.

The access versions is 97.

ON those it managed to open - How can i make it the active window? It opens it but the focus is still on the spreadsheet.

Any help appreciated
Thanks

[Tom Ogilvy]

Sounds like you might have unclosed instances of Access still running. Look
in the Task Manager in Windows and make sure no instances of Access are
open. Make sure you release all references to Access in your code.

You can look at AppActivate for bringing the instance to the front.

You can also look in the Automation help file:
http://support.microsoft.com/?kbid=167223
Microsoft Office 97 Automation Help File Available on MSL

--
Regards,
Tom Ogilvy




"JohnDK" <[email protected]> wrote in
message news:[email protected]...
>
> Im new to vba, please be patient. Thx
>
> I've created command buttons in a spreadsheet to open an access mdb's
> located on a comman drive.
>
> I managed to locate and open the mdb's trhu
>
> "GetObject" statement.
>
> It works for some mdb's, but not all.
>
> ON those it doesn't work i can see access opening and then it closes
> immediatly after opening.
>
> The access versions is 97.
>
> ON those it managed to open - How can i make it the active window? It
> opens it but the focus is still on the spreadsheet.
>
> Any help appreciated
> Thanks
>
>
> --
> JohnDK
> ------------------------------------------------------------------------
> JohnDK's Profile:
http://www.excelforum.com/member.php...fo&userid=7184
> View this thread: http://www.excelforum.com/showthread...hreadid=480430
>