Advertisement

04.18.2008 at 12:00AM PDT, ID: 23333384
[x]
Attachment Details

MS Access Hide DB Window... on Pop Up / Modal Form...

Asked by a260148 in Access Architecture/Design, Windows 2000 Operating System, Access Coding/Macros

Tags: Microsoft, Office, 2003, Access

I currently have an Access App with a Pop Up / Modal Form. Upon opening, it hides the Access DB window using the attached code...
It works perfectly... except when the app is minimized, the minimized form goes to the bottom left had side of the screen... and the app doesn't show in the taskbar. In order to select or maximixe the app again, you have to go the bottom left of your desktop to get it.
Wondering if there's anyway to still Hide The Access window, use a Pop up / Modal form, and still have it show in your taskbar.
Help is much appreciated.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" (ByVal hWnd1 As Long, ByVal hWnd2 As Long, ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
Private Declare Function PostMessage Lib "user32" Alias "PostMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
Private Sub Form_Open(Cancel As Integer)
    Dim lngReturn As Long
    lngReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
End Sub
[+][-]04.18.2008 at 08:14AM PDT, ID: 21386516

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Architecture/Design, Windows 2000 Operating System, Access Coding/Macros
Tags: Microsoft, Office, 2003, Access
Sign Up Now!
Solution Provided By: dds110
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628