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

Is there a better way in C# to round a DateTime to the nearest 5 seconds?

c# algorithm datetime performance

I want to round a DateTime to the nearest 5 seconds. This is the way I'm currently doing it but I was wondering if there was a better or more concise way?

javascript_tag and <script> tag are being stripped from erb templates

javascript ruby-on-rails ruby tags erb

I am a Ruby/Rails noob and have just started working on a legacy Rails app that's running on Passenger using ree-1.8.7.