CODEWITHSUNDEEP
excelms-accessms-access-2010excel-2010vba
AxxieD
AxxieD

Reputation: 614

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?

Upvotes: 1

Views: 238

Answers (1)

Soulfire
Soulfire

Reputation: 4296

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

Upvotes: 2

Related Questions