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

preg_replace non-alpha, leave single whitespaces

php regex preg-replace

As the title reads, I'm trying to replace all non-alpha characters and replace all double (or more) white spaces to a single one. I simply can't get around the white spaces stuff.

Allocating memory to a pointer of a class

c++ qt pointers qt-mobility

QGeoRoutingManager: http://apidocs.meego.com/1.0/qtmobility/qgeoroutingmanager-members.html

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.