[maxx_eclipse]

Afternoon everyone,

I'm attempting to use an AutoExec code that will execute certain functions when the database opens. However, I know that some people in the Office have the full version of Access, while others need to use the runtime environment to run the database. The problem with using the runtime environment is that the LockNavigationPane event in AutoExec won't execute because the navigation pane does not exist in the runtime environment, which then forces the database to close on a macro error.

I originally tried to use On Error Next in the AutoExec macro, but the runtime environment won't recognise that. So I was wondering if there is some way that I can tell the AutoExec macro to check whether the full Access program or runtime environment is being used, hence determine the code to be used.

So, basically I'm wondering if it's possible for the AutoExec macro to include a piece of code to determine whether the runtime environment is being used or not.

Thank you for your time.

[maxx_eclipse]

*bump*

Any ideas as to how to go about this?

[maxx_eclipse]

Here's the answer given on the Microsoft Discussion forum:

Discussions In Programming

[maxx_eclipse]

THE SOLUTION:

Function StartUp()

    If SysCmd(acSysCmdRuntime) = True Then
    DoCmd.OpenForm "Task List", acNormal, , , acFormEdit, acWindowNormal
End If
    If SysCmd(acSysCmdRuntime) = False Then
    RunCommand acCmdWindowHide
    DoCmd.OpenForm "Task List", acNormal, , , acFormEdit, acWindowNormal
    DoCmd.LockNavigationPane True
End If

End Function