hide, display and rename a table in VBA

[Paul James]

Can anyone tell me the VBA code to perform the following operations?

1. hide a table named "tblData";
2. display a hidden table named "tblData";
3. rename tblData to tblData2.

Thanks in advance.

Paul

 

[Marshall Barton]

Can anyone tell me the VBA code to perform the following operations?

1. hide a table named "tblData";
2. display a hidden table named "tblData";
3. rename tblData to tblData2.

I am unaware of any way to hide or unhide a table in VBA.
(I think it may be a new feature in A03)

You can rename a table in the current database with this
kind of code:

CurrentDb.TableDefs("tblData").Name = "tblData2"

 

[Paul James]

Thanks, Marsh.

I am unaware of any way to hide or unhide a table in VBA.
(I think it may be a new feature in A03)

You can rename a table in the current database with this
kind of code:

CurrentDb.TableDefs("tblData").Name = "tblData2"