TheDougmeister
New Member
- Joined
- Oct 12, 2021
- Messages
- 25
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Was in a hurry and tried the first two options... didn't work for me so I did option #3 from here:
and ran this code:
Private Sub Form_Open(Cancel As Integer)
Call ShowWindow(hWndAccessApp, SW_HIDE)
DoCmd.OpenForm "Switchboard", windowmode:=acDialog
End Sub
But it threw an error and I accidentally closed MS Access before I added this code:
3. Reset the Access window when the application closes:
Private Sub Form_Unload(Cancel As Integer)
Dim lngRetCode As Long
lngRetCode = ShowWindow(hWndAccessApp, SW_MAXIMIZED)
End Sub
Now when I double-click the desktop shortcut to the application, nothing happens. I have a backup from a month ago; is that the only way to recover?
Hide the main Access window
Hide the main Access window and the database window so that the user sees nothing but your form.
www.alvechurchdata.co.uk
and ran this code:
Private Sub Form_Open(Cancel As Integer)
Call ShowWindow(hWndAccessApp, SW_HIDE)
DoCmd.OpenForm "Switchboard", windowmode:=acDialog
End Sub
But it threw an error and I accidentally closed MS Access before I added this code:
3. Reset the Access window when the application closes:
Private Sub Form_Unload(Cancel As Integer)
Dim lngRetCode As Long
lngRetCode = ShowWindow(hWndAccessApp, SW_MAXIMIZED)
End Sub
Now when I double-click the desktop shortcut to the application, nothing happens. I have a backup from a month ago; is that the only way to recover?