hide, display and rename a table in VBA

  • Thread starter Thread starter Paul James
  • Start date Start date
P

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
 
Paul said:
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.
Click to expand...

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"
 
Thanks, Marsh.


Marshall Barton said:
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"
Click to expand...
 
Back
Top