Access 2010隐藏Access窗口

Question

我想永久隐藏访问窗口。我有一个自动执行宏，它最初会隐藏窗口，但如果用户在任务栏上单击我的数据库图标，它就会出现在我的表单后面，这是相当烦人的。我想知道是否有一种方法可以降低它，而不必复制每个地方的隐藏窗口宏

Answer 1

以下内容适用于旧版本的access (来源：http://www.vbaexpress.com/kb/getarticle.php?kb_id=74)：

Option Compare Database 
Option 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 

只需调用fSetAccessWindow(0)来隐藏，调用fSetAccessWindow(1)来显示。或者，您可以使用fSetAccessWindow(2)和fSetAccessWindow(3)来显示最小化/最大化。该应用程序也将隐藏在任务栏中，防止用户单击它。

如果它在Access 2010上不起作用，你也可以试试这个：http://www.tek-tips.com/faqs.cfm?fid=2562