How to capture a table name from table tab in Access

[Guest]

I'm hoping I'm explaining my question without confusing anyone. I am
relatively new to Access 2003.

Is there a way that I can capture on a form the name of a table a user has
selected in the table tab in Access?

As an example a user has selected 'FILE-1' from the table tab in Access.
Can I capture the name of that table on a form/macro?



Sincerely,

Betty F

 

[Douglas J. Steele]

I'm hoping I'm explaining my question without confusing anyone. I am
relatively new to Access 2003.

Is there a way that I can capture on a form the name of a table a user
has
selected in the table tab in Access?

As an example a user has selected 'FILE-1' from the table tab in Access.
Can I capture the name of that table on a form/macro?

I don't believe it's possible. What is you're trying to do? Why not just
give them a combo box on the form to let them choose the table?

Set the combo box's RowSource to

SELECT [Name]
FROM MsysObjects
WHERE ((Left$([Name],1)<>"~")
AND (Left$([Name],4)<>"Msys")
AND ([Type] In (1,4, 6))
ORDER BY [Name]

 

[Guest]

Dear Douglas,

Thank you for your reply. I also do not think this is possible but just
wanted to ask that question if by chance there was a way.

thanks again,

Betty F

I'm hoping I'm explaining my question without confusing anyone. I am
relatively new to Access 2003.

Is there a way that I can capture on a form the name of a table a user
has
selected in the table tab in Access?

As an example a user has selected 'FILE-1' from the table tab in Access.
Can I capture the name of that table on a form/macro?

I don't believe it's possible. What is you're trying to do? Why not just
give them a combo box on the form to let them choose the table?

Set the combo box's RowSource to

SELECT [Name]
FROM MsysObjects
WHERE ((Left$([Name],1)<>"~")
AND (Left$([Name],4)<>"Msys")
AND ([Type] In (1,4, 6))
ORDER BY [Name]

 

[Guest]

By the way you combo box idea worked!!

Sincerely,

Betty F

I'm hoping I'm explaining my question without confusing anyone. I am
relatively new to Access 2003.

Is there a way that I can capture on a form the name of a table a user
has
selected in the table tab in Access?

As an example a user has selected 'FILE-1' from the table tab in Access.
Can I capture the name of that table on a form/macro?

I don't believe it's possible. What is you're trying to do? Why not just
give them a combo box on the form to let them choose the table?

Set the combo box's RowSource to

SELECT [Name]
FROM MsysObjects
WHERE ((Left$([Name],1)<>"~")
AND (Left$([Name],4)<>"Msys")
AND ([Type] In (1,4, 6))
ORDER BY [Name]