Activate window - MS Access

[MUKESHY12390]

Hi Frnds,


I have two database open, How can I switch focus between these two.

any idea?


any help would be appreciate.


Thanks,

Mukesh Y

 

[Micron]

Re: Acitvate window - MS Access

Click on the icon in the Windows task bar for the inactive one?

 

[MUKESHY12390]

Re: Acitvate window - MS Access

thanks for reply.....I'm looking for VBA solution

 

[Micron]

Re: Acitvate window - MS Access

AFAIK, you will need to use Windows API's because applications are containers in the operating system and are not usually accessible directly between themselves via their native code. Recommend you Google ms access vba api activate window or start here
Access/VBA Tutorials - Bring an external application window to the foreground
Seems like a lot of work for something you can do from the task bar. Perhaps your case justifies it.

 

[MUKESHY12390]

Re: Acitvate window - MS Access

thanks...I'll check

 

[xenou]

Re: Acitvate window - MS Access

Why not use one database? Also seems easier.