Are there any tricks to keeping MS Access active using AppActive? I am
using the following code to start Access and produce a report. The report
is created properly, but the VB app is always current. I would have to use
Alt-Tab or the Task Bar to view the report.
Set objAccess = CreateObject("Access.application.8")
With objAccess
.OpenCurrentDatabase filepath:=gsDatabase
.DoCmd.Maximize
.DoCmd.OpenReport ReportName:=CmbReports, View:=Access.acViewPreview
.DoCmd.Maximize
End With
report = "Microsoft Access - [" + CmbReports + "]"
AppActivate report, 1
Thanks,