How to capture a table name from table tab in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Betty F said:
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?
Click to expand...

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]
 
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


Douglas J. Steele said:
Betty F said:
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?
Click to expand...

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]
Click to expand...
 
By the way you combo box idea worked!!

Sincerely,

Betty F


Douglas J. Steele said:
Betty F said:
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?
Click to expand...

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]
Click to expand...
 
Back
Top