In the following sections I’ll develop a series of routines leading up to one that should satisfy the most demanding call for field information. ![]() When programming for information about fields, we’ll need to take into account just how much information you want to list and how many fields there are in any one table. Microsoft Access currently allows for up to 255 fields in a single table, and up to 64 characters in a field name. VBA can examine many of the properties of a field, including the two we’ll focus on, namely name and data type. ![]() How to make lists of the names and properties of fields (columns) in the tables of Microsoft ® Access databasse. (e) How to List Fields in Access Database Tables
0 Comments
Leave a Reply. |