Move Form to Top Window

I have a pop up form that appears (with a beep) when a condition occurs. I would like that form to appear on top of all other window applications.

Access is an active application but the pop up form is hidden if other applications are in use.

Is there a way to have the pop up window appear on top?

Any help would be appreciated.

there is a setting in in the forms properties on the other tab for pop up and one for modal. Look at both of those.

Settings Correct

I have the Pop up set as Yes and the modal set as Yes. Opening a modal form disables windows in Access but the other applications continue to operate.

I need the pop up form to show while the person is working on other applications (e.g., Outlook or Word) so they know that customers are waiting to be served.

Thanks for the lead but it doesn't work ... Does anyone have any ideas?

Thanks

i have the same case and please if you have found a cool idea to get it , send it to me ASAP

Here's how to do that without using Windows handles (hWnd). You'll need to know the name of the window in the taskbar (or something close to it). For example, I'm in Firefox right now. On the taskbar, it starts with "Access World Forums". The full taskbar title is "Access World Forums - Reply to Topic - Mozilla Firefox", but you only need enough of it to make it unique as Access will do matching if there's not an exact match.

The code looks like this:


For example, if I want to switch to MS Outlook, it would look like this:


Place the AppActivate command wherever you need it and it will pop Access (or any other app with a taskbar title) you want. The SendKeys("%R") sends an Alt-R, which restores the window.

You may also want to look into the SHELL function, which allows you to pass program handles. It's a little more complex though. What I've provided will force the window to the top in a fairly straightforward manner.

Hope that helps.

~Moniker

I haven't actually tried this, but from the description, it seems the SetWindowPos API might be able to achieve such. Check out http://support.microsoft.com/?kbid=210500

Yup. That link describes the way to do it using the Windows handles (hWnd), which is more complex, but more flexible as well. Thanks for finding the link.

~Moniker