create a field in the table

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
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
 
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
 
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
 
Back
Top