用VBA显示或隐藏全部ACCESS对象-Big Young
Access软件网QQ交流学习群(群号码198465573),欢迎您的加入!
首页 >技术文章> Access数据库-模块/函数/VBA


用VBA显示或隐藏全部ACCESS对象

发表时间:2017/10/30 17:45:24 评论(1) 浏览(10145)  评论 | 加入收藏 | 复制
   
摘 要:用VBA显示或隐藏全部ACCESS对象
正 文:
Public Sub HideObjects(Optional booHide As Boolean)
    'Created by Speakers_86
    'You are free to use, modify, and distribute
    'this as long as you leave this comment
    '
    'Purpose:   loops through all of you access objects, and
    '           hides them, the same as using the Access Gui to
    '           hide an object
    'Argument:  booHide
    '           an optional argument.  True hides objects,
    '           false unhides objects
    


    Dim db     As Database
    Dim tbl    As TableDef
    Dim qry    As QueryDef
    Dim str    As String
    Dim i      As Integer


    On Error Resume Next
    
    Set db = CurrentDb()




    For Each tbl In db.TableDefs
            Call SetHiddenAttribute(acTable, tbl.Name, booHide)
    Next tbl




    For Each qry In db.QueryDefs
        Call SetHiddenAttribute(acQuery, qry.Name, booHide)
    Next qry




    For i = 0 To db.Containers("Forms").Documents.Count - 1
        str = db.Containers("Forms").Documents(i).Name
        Call SetHiddenAttribute(acForm, str, booHide)
    Next






    For i = 0 To db.Containers("Reports").Documents.Count - 1
        str = db.Containers("Reports").Documents(i).Name
        Call SetHiddenAttribute(acReport, str, booHide)
    Next i




    For i = 0 To db.Containers("Modules").Documents.Count - 1
        str = db.Containers("Modules").Documents(i).Name
        Call SetHiddenAttribute(acModule, str, booHide)
    Next i






    For i = 0 To db.Containers("Scripts").Documents.Count - 1
        str = db.Containers("Scripts").Documents(i).Name
        Call SetHiddenAttribute(acMacro, str, booHide)
    Next i


    Set db = Nothing
End Sub

Access软件网交流QQ群(群号:198465573)
 
 相关文章
表和链接表隐藏与恢复示例  【十段  2008/5/10】
access隐藏表的一种特殊方法  【未知  2008/12/23】
隐藏/恢复显示MDB内的查询  【叶海峰  2009/7/27】
显示隐藏表  【李制樯  2014/2/13】
隐藏功能区\左侧导航窗体  【qq1985178585  2017/8/27】
常见问答
技术分类
相关资源
文章搜索
关于作者

Big Young

文章分类

文章存档

友情链接