Tell if Access is controlled by Automation 1

[PWise]

Is there a way to tell if A Access Application was opened by Automation or by clicking on the database icon?

There is code that I want to run/not run depending if the Access Application is controlled by Automation.

There are Access Application that I want only to be run by Automation.

PWise

 

[PHV]

straight from the VBA help:
MsgBox "The user started Access: " & Application.UserControl

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

Have A Star
missed that one
thanks for all the help
PWise