Adding New Fields to Tables using Code

R

Richard Krupa

Hi Guys,

I'm writting a small program to update tables with the new fields to save
sometime. Its all working except when it comes to adding a new field thats
of a number type.

The problem is trying to set the decimal places, i'm using:

Set prp = fld.CreateProperty("Decimal Places", dbInteger,
myRs!FieldDecPlace)
fld.Properties.Append prp

myrs!FieldDecPlace = 2

myrs!FieldDecPlace = a value that comes from the NewFields table that stores
the info for the new fields, it just loops through the records in the table.

Thanks in advance
 

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

Repost: Adding New Fields to Tables using Code 9
Error 3211 - tbl already in use 1
Urgent: Adding a Date Field to a Table using VBA 2
Use VBA to set Format Property of a Field 5
Invalid Operation when creating table with Yes/No field VBA 0
Create Properties for Decimal and Date fields 1
Calculate Percent Using Fields Located In Two Tables 1
modify field type of existing field in table 1

Top