Columns not saving where I placed them.

[punter]

Hi,

I'm new at access but getting the swing of it. It is a pretty cool toy.

I have a table that I am adding various columns of data. Once added I move the columns to where I want them to be. I am hitting the little save disk on the top toolbar but when I reopen the file the columns are not where I placed them. I'm not sure why this is happening. Any thoughts?

Thanks in advance for your help.

Eddie.

 

[The_Doc_Man]

In a table, if you move fields around, do it by going into table design mode and do a drag'n'drop of field names from that view.

Access won't let you move a field that is a primary key. In fact, if you declare a primary key in the middle of your fields, Access will move that for you.

 

[neileg]

A table isn't meant for viewing data. It doesn't matter to Access what order the fields are in other than the primary key. If you view the data in a form you can have any order you want.

 

[Mile-O]

A table isn't meant for viewing data. It doesn't matter to Access what order the fields are in other than the primary key.

But they still retain their index. Otherwise such code as the following snippet wouldn't be possible.

With rs
    .AddNew
    .Fields([b]1[/b]) = NewData
    .Update
    .Close
End With

 

[punter]

Thank you for your quick replies. I see what you are saying about changing the order of the columns in design view. That makes sense.

Thank you again for all your help.

Eddie.

 

[punter]

Sorry, forgot to leave this off the reply.

I understand what you are saying about the forms. I'm not at the point yet (but getting their fast) where I will need to view the forms. Just having the data in the table and being able to run queries off it is good enough for now. I'm sure I'll have some form questions in the future.

Thanks everyone,

Eddie.

 

[neileg]

But they still retain their index. Otherwise such code as the following snippet wouldn't be possible.

With rs
    .AddNew
    .Fields([b]1[/b]) = NewData
    .Update
    .Close
End With

I bow to your infinitely superior knowledge.