[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1095
  • Last Modified:

Control the orders of columns in datasheet form 2010

Hi
I need to reorder the columns in datasheet  subform .
In access 2003 I was just drag the column to the place needed and then save it , and that’s all.
I try it several times in access 2010, but no way.
Please help
1.JPG
0
Mohammad Alsolaiman
Asked:
Mohammad Alsolaiman
  • 3
  • 3
  • 2
  • +2
4 Solutions
 
Dale FyeCommented:
Open the datasheet by itself (not as a subform).

Drag the column where you want it, then save the form.  Then open it via your main form and it should be where you want it.
0
 
mbizupCommented:
Make sure that your datasheet columns are not frozen by unfreezing all columns.

There is an image of this in the following article:
http://office.microsoft.com/en-us/access-help/freeze-fields-in-an-access-datasheet-HA102489824.aspx
0
 
Jeffrey CoachmanCommented:
1. For fun, just try changing the "Tab Order" of the subform...

2. Also make sure that you actually created a "datasheet" form.
I just created a datasheet form in 2010 and I was able to move the columns just fine...

3. The "Multiple Items" or "Tabular" (continuous) form options are not the same thing as a datasheet form, even though they look similar (display multiple records).

To be sure, to move a column in a datasheet view form:
a. Click once *and release* the column heading.
b. Then click *and Hold* the column heading, then you will see a back line (as you move the column) indicating where it will be moved to.
c. Then simply drop (release) the column.

Final Notes:
Make sure the default view of this subform is actually set to: "Datasheet View"


;-)

JeffCoachman

Sample attached
Database531.accdb
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You can do it in VBA code ... in the OnLoad of the Form ... that way, it will always be what you want it to be ...

This shows how:
http://msdn.microsoft.com/en-us/library/ff822068.aspx

mx
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
boag2000: For fun, just try changing the "Tab Order" of the subform...
yes that was the problem in my case
i had try whats : fyed & mbizup say but nothing .
0
 
Jeffrey CoachmanCommented:
OK, but again, in the sample I posted I was able to "move" the colums just fine.
This is what mbizup suggested as well...

Are you saying that this did not work for you, ...even in the sample I posted?
0
 
mbizupCommented:
Jeff,

My understanding is that he is saying your suggestion worked, and that he may have simply  forgotten to close the question.
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
boag2000: Are you saying that this did not work for you, ...even in the sample I posted?
your sample is work fine in the subform datasheet, but not in the report.
the  "Tab Order" is work fine with me
maybe some thing concern in my accdb or the arabic version, not sure.
anyway it works good right now by adjusting the column tabs order
0
 
Mohammad Alsolaimanapplication programmerAuthor Commented:
thanks to all of you for the good information
0
 
Jeffrey CoachmanCommented:
OK

;-)

Jeff
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now