Using access to refer to objects within access

Question

I have a basic table in access with several populated fields. I would like to explore if there is a way, preferably through the GUI (or maybe through SQL), to add a field containing the name of the table itself. I see only the following data formats for fields: Short text, Long text, number, Date/time, Currency, Autonumber, Yes/No, OLE Object, Hyperlink, Attachment and Calculated. There is nothing pertaining to data object parameters themselves such as table, field or query names or parameters...

It is not clear what you want. Please explain a little more. — NineBerry
– NineBerry, Commented May 14, 2016 at 21:04

NineBerry · Accepted Answer · 2016-05-14 21:12:44Z

1

You can access the meta data of the database via VBA (Visual Basic for Applications) macros.

For example, this can show all table names:

Option Compare Database

Public Sub Test()
    Dim database As DAO.database
    Dim tableDef As DAO.tableDef
    Set database = CurrentDb
    For Each tableDef In database.TableDefs
            MsgBox tableDef.Name
    Next
End Sub

answered May 14, 2016 at 21:12

NineBerry

28.8k4 gold badges68 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using access to refer to objects within access

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related