create a field in the table

F

Frank Dulk

To create a field in the table through code type númeric with decimal house,
for
that doesn't make automatic rounding.

field double
 
F

Frank Dulk

thank you


"Jonathan Parminter" <[email protected]> escreveu na
mensagem
Frank said:
-----Original Message-----
To create a field in the table through code type númeric with decimal house,
for
that doesn't make automatic rounding.

field double
Click to expand...

Hi Frank,

use the following as an example...

Dim tdf As dao.TableDef

Set tdf = CurrentDb.TableDefs("tableName")
With tdf
.Fields.Append .CreateField("NewFieldName", dbDouble)
End With

Note that the object library is DAO.

Luck
Jonathan
 
J

Jonathan Parminter

Frank said:
-----Original Message-----
To create a field in the table through code type númeric with decimal house,
for
that doesn't make automatic rounding.

field double
Click to expand...

Hi Frank,

use the following as an example...

Dim tdf As dao.TableDef

Set tdf = CurrentDb.TableDefs("tableName")
With tdf
.Fields.Append .CreateField("NewFieldName", dbDouble)
End With

Note that the object library is DAO.

Luck
Jonathan
 
Top