Results 1 to 1 of 1
  1. #1
    chackramp54 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    1

    Need Help hiding White DB Application Background

    **Update -
    Thank you all but I found out what I was doing wrong.
    Solution:
    File -> Current Database -> Document Window Options : Tabbed Documents (UNCHECK Display Document Tabs).

    New question? If I set to Pop-up and Modal - No. Is it possible to hide then the Access DB Background Application (read bar and window) while at same time, having App icon visible on taskbar and task manager? The VBA code I find for this forces Modal and hides from task bar and manager. Any tips? Thanks in advance



    Hi All,
    I'm seeking your help in hiding the white background on my form (scribbled part). I'm including a screenshot of the property sheet. And VBA code below. Any help is greatly appreciated thank you

    Private Sub Form_Load()
    'Hidding Navigation Pane
    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdWindowHide
    DoCmd.MoveSize , , 711, 405

    'Hidding Ribbon
    DoCmd.ShowToolbar "Ribbon", acToolbarNo
    DisableStdOption
    End Sub


    Sub DisableStdOption()
    On Error GoTo Err_DisableStdOption

    ChangeProperty "StartupShowDBWindow", DB_BOOLEAN, False


    ChangeProperty "AllowFullMenus", DB_BOOLEAN, False
    ChangeProperty "AllowBuiltinToolbars", DB_BOOLEAN, False

    'turn off the database window in normal use
    DoCmd.SelectObject acTable, , True
    DoCmd.RunCommand acCmdWindowHide

    Exit_DisableStdOption:
    Exit Sub

    Err_DisableStdOption:
    MsgBox "Error #" & Err.Number & ": " & Err.Description
    Resume Exit_DisableStdOption
    End Sub


    Function ChangeProperty(strPropName As String, varPropType As Variant, _
    varPropValue As Variant) As Integer
    On Error GoTo Change_Err
    Dim dbs As Object, prp As Variant
    Const conPropNotFoundError = 3270

    Set dbs = CurrentDb
    dbs.Properties(strPropName) = varPropValue
    ChangeProperty = True

    Change_Bye:
    Exit Function

    Change_Err:
    If Err = conPropNotFoundError Then ' Property not found.
    Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue)
    dbs.Properties.Append prp
    Resume Next
    Else ' Unknown error.
    ChangeProperty = False
    Resume Change_Bye
    End If
    End Function

    Private Sub btnExit_Click()
    DoCmd.Quit
    End Sub
    Attached Thumbnails Attached Thumbnails accessform.jpg   accessform-propertysheet.jpg  

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

Similar Threads

  1. Replies: 2
    Last Post: 01-21-2016, 02:40 PM
  2. Replies: 1
    Last Post: 08-08-2014, 06:35 AM
  3. Replies: 2
    Last Post: 06-01-2014, 12:05 PM
  4. Replies: 4
    Last Post: 08-25-2011, 01:59 PM
  5. Hiding the Ribbon in a dB Application
    By jtvcs in forum Access
    Replies: 0
    Last Post: 03-26-2011, 09:41 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