Quick one - refreshing Navigation pane

[oli82]

Hi,

Thanks for the help in advance, this website is a goldmine.

I hide tables using the HideTables module, this works when I run the command button, go back to the navigation pane and press F5.

Is there a way to refresh the tables on the navigation pane using VBA.

Many thanks for your help.

Cheers,

Oliver

 

[CyberLynx]

What is a HideTables module?

If I want to hide a Table I just start the table name with Usys as in UsysMyTableName.

Ayways..to answer your question:

CurrentDB.TableDefs.Refresh
(DAO required)
.

 

[oli82]

Thanks for the help,

Application.SetHiddenAttribute acTable, "MyTable", True ' will hide the table "MyTable"

Application.SetHiddenAttribute acTable, "MyTable", False ' will unhide the table "MyTable"

This works very nicely - I was scarred to go near the sysuser tables.

Oliver

 

[CyberLynx]

uhhh...of course. Sorry my friend. I thought you were talking about a specific Code Module for that sort of thing.

.