var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a table, there have 3 fields
field1, field2, field3
However, I want to write the code to add "field0" in the index 0.
Dim db As Database
Dim tb As TableDef
Set db = CurrentDb
Set tb = db.TableDefs("tbl")
tb.Fields.Append tb.CreateField("field0", dbInteger)
I used the above code, it only append the field0 at the last column,
field1,field2, field3, field0.
How can I move/add to the index 0?
I want to change the datatype in the field1.
tb.Fields("Field1").Type = dbinteger
However, it shows the error message, it is said that it is read-only.
so, we cannot modify it.
How can I modify the datatype?
Please let me know about it. Thanks a lot.
I seem to recall type being a read-only property.
Also,the index of fields really shouldn't matter, that makes me question why you would want to force it. What is the practical application for this index?