Type Mismatch when Trying to Fill Array from Field Names

[isladogs]

I have asked isladogs, as he has extensive knowledge of the deep stuff. After all, the property sheet must get them from somewhere?

Just to confirm:
Although the details of all database objects are stored in the system table MSysObjects, the fields are stored as table properties.
They aren't in any of the deep hidden tables, all of which I have viewed. Those are used to hold details of complex data stored in MVF, attachment and column history fields



I would suggest looking at Allen Browne's procedure to extract the field names, save them to a table and run a query on them as already suggested
See http://allenbrowne.com/func-DAO.html#ShowFields

Alternatively use the Database Documenter built in to Access to view a list of fields, datatypes etc.
The problem is that it gives far too much info and is only available as a report in print preview mode
Here's a deliberately simple example:


Unfortunately you can't get to design view to view the report record source and query it. However you can export to e.g. Excel

[Micron]

You can limit output to just field names, types and sizes though? Good point about Excel; spreadsheet could even be used as a table.

[isladogs]

Yes you can omit the indexes part.
I've tried exporting to Excel. The output is usable but not ideal
Personally I wouldn't use the documenter approach for anything more than a quick check

[Welshgasman]

arnelgp over on AWF approached the problem in the same way the O/P was attempting.

See post 5 in https://www.access-programmers.co.uk...post-1823735#5

[Welshgasman]

Now spoilt for choice with all the methods available.
All because an array was not declared correctly.