Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-03-22
16
Medium Priority
?
5,053 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 49

Expert Comment

by:Dale Fye
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 49

Expert Comment

by:Dale Fye
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 49

Expert Comment

by:Dale Fye
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 668 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....
1
 

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 49

Assisted Solution

by:Dale Fye
Dale Fye earned 1332 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 49

Accepted Solution

by:
Dale Fye earned 1332 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

971 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