Results 1 to 2 of 2
  1. #1
    jsunnb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2013
    Location
    Southern California
    Posts
    9

    Show Forms in Taskbar when using Modal/Popup = Yes and Access Window hidden


    Hello all,

    So I've got a bit of a nuisance here, in my Access database I use the fSetAccessWindow Function that I found online (see below for code) to hide the main access window.

    Code:
    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 = 5 Then '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
    But the unfortunate thing is when I use "Call fSetAccessWindow(0)" (which make the access window disappear) it also makes Access disappear in the windows taskbar too. Which makes it difficult for user, especially if they have a lot of windows open. They pretty much have to minimize everything just to find the access popup form.
    I did some searches online and it looked like some people were saying that you can see each form in the taskbar if they are set as popup but not modal. But when I try turning Modal off the forms aren't visible either (It seems that only modal stops them from being hidden with the access window). I also tested it without the Access window hidden, Popup set to yes, and model set to no, but they still don't show up in the taskbar.

    Does anyone know of a way to make a popup form show up in the taskbar? Ideally, even when the access window is hidden.

    Thank you

    Jason

  2. #2
    qa12dx is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    india
    Posts
    112
    it has something to do with - view min max buttons - yes/no
    i ve noticed if my main form has that enabled then that form and forms triggered from there don't cover the taskbar

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hide Access and show only my forms
    By mortenskipper in forum Access
    Replies: 8
    Last Post: 01-20-2016, 08:21 AM
  2. Change Switchboard popup window size
    By Rhemo in forum Access
    Replies: 9
    Last Post: 09-02-2012, 10:54 AM
  3. Show database window
    By rohini in forum Access
    Replies: 2
    Last Post: 05-24-2012, 06:46 AM
  4. Database window partially hidden!!!!!
    By Ray67 in forum Access
    Replies: 4
    Last Post: 09-23-2011, 11:49 AM
  5. Access POPup forms - setting position
    By malcolm.wilcock@tesco.net in forum Forms
    Replies: 5
    Last Post: 02-24-2010, 10:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums