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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing Fields in a Word Form 5
How to paste this down? 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Mail Merge Directory Conditional Page Break 0
Decimal places in a temporary table 3
ASK Field Formatting 1
Mail Merge - displaying a conditional number of decimals 5
Appending tables 0

Top