How can I insert a new field between Existing field?

  • Thread starter Thread starter Alex AU
  • Start date Start date
A

Alex AU

Dear all,

I would like to insert a new field between existing field, how can I do that?

Thanks a lot.



Regards,

Alex AU
 
I'm not sure why this should be important but you can select and drag fields
in the design view.

--
Duane Hookom
MS Access MVP

Dear all,

I would like to insert a new field between existing field, how can I do
that?

Thanks a lot.



Regards,

Alex AU
 
Dear Duane,

Sorry, I should make it more clear, I would like to use VBA/VB to perform the job. As I need to synchronize the structure of two databases without affecting the data, I need the exact structure of the new database tables to be incorporated in my old version one, since the program use the field index instead of field name for data manipulation, field order needs to be the same as the new database.

Moving it in designer work but as the tables modified is unknown and the number of tables are huge, I need to use VBA/VB to perform the modification.

Thanks a lot.



Regards,

Alex AU


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message I'm not sure why this should be important but you can select and drag fields
in the design view.

--
Duane Hookom
MS Access MVP

Dear all,

I would like to insert a new field between existing field, how can I do
that?

Thanks a lot.



Regards,

Alex AU
 
Hi,
field object has .OrdinalPosition property, using it you can specify at what
position you want to insert a field

DAO code to add new field to a table you can find in Access help

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Dear all,

I would like to insert a new field between existing field, how can I do
that?

Thanks a lot.



Regards,

Alex AU
 
You could always add the field to the end, create a query that retrieves the
fields in the required order and use the query, rather than the table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dear Duane,

Sorry, I should make it more clear, I would like to use VBA/VB to perform
the job. As I need to synchronize the structure of two databases without
affecting the data, I need the exact structure of the new database tables to
be incorporated in my old version one, since the program use the field index
instead of field name for data manipulation, field order needs to be the
same as the new database.

Moving it in designer work but as the tables modified is unknown and the
number of tables are huge, I need to use VBA/VB to perform the modification.

Thanks a lot.



Regards,

Alex AU


"Duane Hookom" <DuaneAtNoSpanHookomDotNet> wrote in message
I'm not sure why this should be important but you can select and drag fields
in the design view.

--
Duane Hookom
MS Access MVP

Dear all,

I would like to insert a new field between existing field, how can I do
that?

Thanks a lot.



Regards,

Alex AU
 
Thanks Alex,

I'll try that.



Regards,

Alex AU
Hi,
field object has .OrdinalPosition property, using it you can specify at what
position you want to insert a field

DAO code to add new field to a table you can find in Access help

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

Dear all,

I would like to insert a new field between existing field, how can I do
that?

Thanks a lot.



Regards,

Alex AU
 
Back
Top