Bring Access Window On Top When Opened From Excel

I have an Excel 2010 spreadsheet that brings in data from an Access 2010 database. The user has to login to be able to access the records. When Access opens, the icon in the taskbar flashes, but stays behind whatever else is on the screen. What I want is for Access to become the active window so that there's no chance of the user missing it.

What would be the best way to go about doing this?

Answers


I have used AppActivate before, but I don't necessarily know the pros and cons.

Sub ActivateAccess()
  On Error Resume Next
  AppActivate "Microsoft Access"
  On Error GoTo 0
End Sub

Need Your Help

Maven GWT 2.0 and Eclipse

java eclipse maven-2 gwt

Does anyone know of a good guide for creating a project with the new 2.0 release of GWT using maven and eclipse? I am running into a lot of problems getting them to play nicely together.

How to change this code to ARM assembly instructions?

assembly arm

How to change this code to ARM assembly instructions?