dbhiddenobject doesnt work

hi all,

i'm trying to hide by database with this code:
Application.CurrentDb.TableDefs(CurrentDb.TableDefs(i).Name) .Properties("Attributes").Value
= dbhiddenobject

from some reason it doesnt work
the table are not hidden,does anyone have an idea what can cause this
problem?

Re: dbhiddenobject doesnt work

On 31 מרץ, 18:23, "Allen Browne" =
wrote:
> Try AND-ing the attribute to the constant:
>
> If (CurrentDb.TableDefs(i).Attributes 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" wrote in message
>
> news:2b1b7b65-4364-41fa-b49b-eb8a5c942b73@s8g2000prg.googleg roups.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.CurrentDb.TableDefs(CurrentDb.TableDefs(i).Name) .Properties(=
"At­tributes").Value
> > =3D dbhiddenobject
>
> > from some reason it doesnt work
> > the table are not hidden,does anyone have an idea what can cause this
> > problem?-הסתר טקסט מצ=
וטט-
>
> -הראה טקסט מצו=D7=
˜×=98-

Re: dbhiddenobject doesnt work

Sorry: you were trying to write the property:

With CurrentDb.TableDefs(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" wrote in message
news:59079157-9a68-4697-bd50-15de42c3b63e@e10g2000prf.google groups.com...
On 31 מרץ, 18:23, "Allen Browne" wrote:
> Try AND-ing the attribute to the constant:
>
> If (CurrentDb.TableDefs(i).Attributes And dbHiddenObject) <> 0 Then
>
> news:2b1b7b65-4364-41fa-b49b-eb8a5c942b73@s8g2000prg.googleg roups.com...
>
and what is the statement there?
i need to make it hide
no success till now