[AccessD] Field Type

That'll Work.

I'll just make a table from that chart and join to it, for the field type
descriptions.

Thanks Rocky,
D

On Wed, Nov 5, 2014 at 9:26 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Is this what you're looking for?
>
> http://allenbrowne.com/ser-49.html
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
> Sent: Wednesday, November 05, 2014 9:23 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Field Type
>
> In Access (2003), How can I get the Field Type, for a given Table Def Field
> Type integer?
>
> I used the following code to populate a table with field names and types
> for
> given tables:
>
>     Set db = OpenDatabase(Path & mdbName)
>     Set td = db.TableDefs(TableName)
> '****************************************
>     For Each fld In td.Fields
>         strSQL = "INSERT INTO tblFieldsInISRRE (FieldName, FieldType,
> FieldSize, JunctFKID) VALUES ('" & fld.Name & "', '" & fld.Type & "', " &
> fld.Size & ", " & JunctPKID & ")"
>         DoCmd.SetWarnings False
>             DoCmd.RunSQL (strSQL)
>         DoCmd.SetWarnings (True)
>     Next
>
> Now when I query the table, I get everything that I need except the field
> type (Number, text...)
>
> Instead I get 10,12,15,20,3,4,5,8 (and that is sorted ascending?!?!?)
>
> Is there a sys table that I can join to, or make my own?
>
> Thanks,
> D
>