How to get a list of field display labels and database table and column names from an Access Front end

Question

Hi

We have a legacy Microsoft Access front and database file (.accdb ). Think this is access 2010.

This is the front end of an application (data is stored in a SQL server database)

There are some complicated forms with dozens of fields on them. We need to migrate data and would like to match up the display labels that the users see when they use the application to the database column names (in SQL).

Is there a way to query the Access database system tables to list the form field display name and the Sql table and column name that each field is linked to ?

Regards

G

Answer 1

You could start with the Database Documenter under the Database Tools tab of the Ribbon.

---

-Tom. Microsoft Access MVP

Answer 2

You have to query all the controls (

This is a quick and dirty sample...you can extend it to your liking

Function getAllControls
On Error Resume Next
Dim ctl as Control
For each ctl in Me.Controls
Debug.print ctl.Name & " - " & ctl.ControlSource
Next
End Function