dbhiddenobject doesnt work

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • thread
    #1

    dbhiddenobject doesnt work

    hi all,

    i'm trying to hide by database with this code:
    Application.Cur rentDb.TableDef s(CurrentDb.Tab leDefs(i).Name) .Properties("At tributes").Valu e
    = dbhiddenobject

    from some reason it doesnt work
    the table are not hidden,does anyone have an idea what can cause this
    problem?
    Tags: dbhiddenobject
    • Allen Browne
      #2
      Re: dbhiddenobject doesnt work

      Try AND-ing the attribute to the constant:

      If (CurrentDb.Tabl eDefs(i).Attrib utes And dbHiddenObject) <0 Then

      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "thread" <yaniv.dg@gmail .comwrote in message
      news:2b1b7b65-4364-41fa-b49b-eb8a5c942b73@s8 g2000prg.google groups.com...
      >
      i'm trying to hide by database with this code:
      Application.Cur rentDb.TableDef s(CurrentDb.Tab leDefs(i).Name) .Properties("At tributes").Valu e
      = dbhiddenobject
      >
      from some reason it doesnt work
      the table are not hidden,does anyone have an idea what can cause this
      problem?

        Comment

        • thread
          #3
          Re: dbhiddenobject doesnt work

          On 31 מרץ, 18:23, "Allen Browne" <AllenBro...@Se eSig.Invalid>wr ote:
          Try AND-ing the attribute to the constant:
          >
          If (CurrentDb.Tabl eDefs(i).Attrib utes And dbHiddenObject) <0 Then
          >
          --
          Allen Browne - Microsoft MVP.  Perth, Western Australia
          Tips for Access users -http://allenbrowne.com/tips.html
          Reply to group, rather than allenbrowne at mvps dot org.
          >
          "thread" <yaniv...@gmail .comwrote in message
          >
          news:2b1b7b65-4364-41fa-b49b-eb8a5c942b73@s8 g2000prg.google groups.com...
          >
          and what is the statement there?
          i need to make it hide
          no success till now
          >
          >
          >
          >
          i'm trying to hide by database with this code:
          Application.Cur rentDb.TableDef s(CurrentDb.Tab leDefs(i).Name) .Properties("At ­tributes").Va lue
          = dbhiddenobject
          >
          from some reason it doesnt work
          the table are not hidden,does anyone have an idea what can cause this
          problem?-הסתר טקסט מצוטט-
          >
          -הראה טקסט מצוטט-

            Comment

            • Allen Browne
              #4
              Re: dbhiddenobject doesnt work

              Sorry: you were trying to write the property:

              With CurrentDb.Table Defs(i)
              .Attributes = .Attributes OR dbHiddenObject
              End With

              --
              Allen Browne - Microsoft MVP. Perth, Western Australia
              Tips for Access users - http://allenbrowne.com/tips.html
              Reply to group, rather than allenbrowne at mvps dot org.

              "thread" <yaniv.dg@gmail .comwrote in message
              news:59079157-9a68-4697-bd50-15de42c3b63e@e1 0g2000prf.googl egroups.com...
              On 31 מרץ, 18:23, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
              Try AND-ing the attribute to the constant:
              >
              If (CurrentDb.Tabl eDefs(i).Attrib utes And dbHiddenObject) <0 Then
              >
              news:2b1b7b65-4364-41fa-b49b-eb8a5c942b73@s8 g2000prg.google groups.com...
              >
              and what is the statement there?
              i need to make it hide
              no success till now

                Comment

                Previous template Next
                Working...