Solved

Want to change order of columns in datasheet view in Access 2010

Posted on 2012-03-22
16
4,175 Views
Last Modified: 2012-06-27
I have a form that is being displayed in datasheet view in Access 2010. I need to move one of the columns from column 2 (2nd place) to column 9 (9th place). How do I do that?
0
Comment
Question by:bmorriso99
  • 6
  • 5
  • 2
  • +2
16 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37752786
open the form in view mode, select column 2 and drag to the position desired
save the form
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37752788
Open the form in datasheet view, click on the column and drag it where you want it, then save it and close it.

That should do it.
0
 

Author Comment

by:bmorriso99
ID: 37753077
I have tried opening the form in datasheet view, clicking on the column (heading), dragging it and dropping it and then saving and that isn't working for me. It works while I am in the database but when I get out and back in it is back to position 2.
WHen I look at the view in design mode I can drag the field and it's label to where I want it but then when I go to datasheet view it is back to position 2. So for example in design mode the form looks like this

label 1   data 1                                  label 5   data 5
label 2   data 2                                  label 6   data 6
label 3   data 3                                   label 7   data 7
label 4    data 4                                 label 8     data 8
                                                           label 9     data 9


then I drag it so that it looks like this

label 1 data1                                      label 5   data 5
                                                            label 6    data 6
label 3 data 3                                    label 7     data 7
label 4 data 4                                    label 8    data 8
                                                           label 2     data 2
                                                           label 9     data 9


but then on the datasheet view it looks like this

label 1   label 2    label 3    label 4    label 5   label 6   label 7    label 8   label 9
data 1    data 2     data 3     data4      datat 5   data 6   data 7    data 8    data 9
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37753218
Do you have this datasheet as a subform in a main form?  If so, then opening the main form and then dragging the column will not work.

The position or order of the controls in the form design view has nothing to do with the datasheet column order.

You need to open the form(datasheet) in design view (all by itself).  Then switch to datasheet view, reposition the columns as you want, then click the Save button.  You should then be able to go back to design view, and switch back to datasheet and it should be in the correct position.
0
 

Author Comment

by:bmorriso99
ID: 37753747
Here is exactly what I am doing.
1. Double click the .mdb file
2. A switchboard is displayed wiht 4 controls/ buttons.
3. I click on the button that I want (modify comments is the heading)
4. The form called frmRpt comes up in dataasheet view with data.
5. I close out the switchboard tab
6. I click the drop down under 'view' and then 'design view'
7. I click the drop down under 'view' and then 'datasheet view'
8. I drag the column to where I want it
9. I right click the tab and choose 'save'
10. Sometimes I even click the save icon
11. Go back to 'view' , 'design view'
12 go to 'view', 'datasheet view' and the column is not where I want it.


Any ideas?
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37753792
I don't have 2010 available here at work, and I never work with the "tabbed" feature, so I cannot test what you are experiencing at the moment.  However, I will take a look when I get home this evening.

You might want to try changing the Document Window Options from "Tabbed documents" to "Overlapping Windows" (at least that is the way they are described in 2007) and trying it again.
0
 

Author Comment

by:bmorriso99
ID: 37754050
OK. It is not urgent and I appreciate your help. I just tried it with overlapping windows and that didn't work either.  Just so you know when I drag the column there is a dark (blue or black) line on the left hand side of the column and I drag that to where I want. I am not sure if that makes sense but I thought I would mention it. Let me know what you find tonight.

Thanks
0
 
LVL 75
ID: 37754107
"9. I right click the tab and choose 'save'"
Can you post a screen shot of that ?

mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37755182
bmorriso99,

it will be better if you can upload a copy of the db.
0
 
LVL 13

Expert Comment

by:lee555J5
ID: 37755674
I haven't been able drag and save column positions in 2007 or 2010. The only ways I have found to accomplish this are 1) freeze 1 or more columns to the left edge of the datasheet, or 2) go to design view and change the tab order of the fields.

Lee
0
 
LVL 13

Assisted Solution

by:lee555J5
lee555J5 earned 167 total points
ID: 37755685
Based on your original Q, it doesn't look as if my method 1) will help. Therefore, try method 2) by switching to design view, right-clicking an empty area of the detail part of the form containing the fields to order, and selecting Tab Order....
0
 

Author Comment

by:bmorriso99
ID: 37756681
I will try both these methods. How do you freeze columns to the left side of the data sheet? I won't be working on this for a few more hours now.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 333 total points
ID: 37756841
To freeze columns, select as many columns as you want starting at the left and working to the right (I don't think you can skip columns).  Then right click on the selected column headers and select the "Freeze columns" option.
0
 

Author Comment

by:bmorriso99
ID: 37767807
When I right click on the design view in  the blank area and go to tab order the field that I want to move is in the place where I want to move it.

Next I tried freezing the 1st column and moving the second column where I wanted it to be and then I came back and froze the columns before it and that didn't work. The option I had was 'freeze fields' not 'freeze columns'.... is that correct?
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 333 total points
ID: 37768017
Can you post a sample database?

I've got a multi-user solution to this, which involves actually writing the column order to a table in the backend database when the form closes.  Then when the form (datasheet) is opened, it checks the database for the correct order of the columns and positions them accordingly.

Unfortunately, I don't have time to give a lot of details of that effort right now.  Will write an article on this eventually, but day and night programming jobs prevent me from spending the necessary time to write the article and develop the sample database.

You might be able to piece some of it together by searching on ColumnOrder or ColumnHidden within EE (don't forget to add "any activity by fyed" in the search criteria).  I asked a number of questions related to those topics about 10 months ago as I was developing this functionality.
0
 

Author Comment

by:bmorriso99
ID: 37772460
Unfortunately I cannot post the database because of proprietary information but let me see if I can make one up.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question