ACCDE ignoring my OnOpen

[Forbes]

So I have all my Forms set as Modal and Popup, I have the Access DB set to hide, all works well. Once I save into an ACCDE the window will not hide when opened from ACCDE anything I am missing here? The DB is Split I noticed this mentioned on another forum but it was never followed up on.

[Homegrownandy]

you can disable the ribbon and navigation from access and make a "background form" full screen.

That's what I do anyways. If you're interested ill help you out.

[Forbes]

I disabled the ribbon and nav panels but essentially I need it to be gone entirely for security purposes, my last db worked fine when I transferred it over to ACCDE so I feel as though I'm missing something fairly obvious. the code I'm using is this

Option Compare DatabaseOption Explicit


Global Const SW_HIDE = 0
Global Const SW_SHOWNORMAL = 1
Global Const SW_SHOWMINIMIZED = 2
Global Const SW_SHOWMAXIMIZED = 3


Private Declare Function apiShowWindow Lib "user32" _
Alias "ShowWindow" (ByVal hWnd As Long, _
ByVal nCmdShow As Long) As Long


Function fSetAccessWindow(nCmdShow As Long)


    Dim loX As Long
    Dim loForm As Form
    On Error Resume Next
    Set loForm = Screen.ActiveForm


    If Err <> 0 Then
        loX = apiShowWindow(hWndAccessApp, nCmdShow)
        Err.Clear
    End If


    If nCmdShow = SW_SHOWMINIMIZED And loForm.Modal = True Then
        MsgBox "Cannot minimize Access with " _
        & (loForm.Caption + " ") _
        & "form on screen"
    ElseIf nCmdShow = SW_HIDE And loForm.PopUp <> True Then
        MsgBox "Cannot hide Access with " _
        & (loForm.Caption + " ") _
        & "form on screen"
    Else
        loX = apiShowWindow(hWndAccessApp, nCmdShow)
    End If
    fSetAccessWindow = (loX <> 0)
End Function

and my call on open is

Private Sub Form_Load()
fSetAccessWindow (0)
End Sub

I have tried on load and on open.

[Forbes]

**ANSWER** Here is what I had to do:

I had to set the form event to OnOpen, then change fsetaccesswindow (0) to 1 then save and reopen the db.
then shift bypass open the db again and change it back to (0) save as ACCDE then when prompted to save the form say yes all will close and tada!!.
Thanks for the help as always!

[RuralGuy]

Thanks for your solution. Others could find this valuable.

[Homegrownandy]

This is really helpful indeed.

[Forbes]

***UPDATE*****

The above process worked for me, upon updating the database it seemed as though this stopped working, after looking around I finally found a solution, regardless of whether or not you have auto compile activated, you must just before converting go into your debug menu and compile manually then save, this solved the issue once again for me.