Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Taborder and sequence of columns in datasheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tore - 15 Nov 2007 22:30 GMT
I have a form with a subform. In the subform there is a datasheet where the
operator do edit, add, delete.

The sequence of the columns in the subform datasheet is set in design mode
by setting taborder. The operator can select a column and drag it with the
mouse to alter the sequence of the columns.

How can I prevent the user from dragging the columns and changing their
sequence?

Alternatively I could repair the sequence of columns every time the subform
is opened. How can I do this in vba?

Regards

Tore
Al Campagna - 16 Nov 2007 00:13 GMT
Tore,
  You could make a continous subform that looks just like a datasheet
subform.
  You'll find you have a lot more flexibility with continuous than
datasheet.  (Headers, Footer totals, colors, etc...)
Signature

   hth
   Al Campagna
   Microsoft Access MVP
   http://home.comcast.net/~cccsolutions/index.html

   "Find a job that you love... and you'll never work a day in your life."

>I have a form with a subform. In the subform there is a datasheet where the
> operator do edit, add, delete.
[quoted text clipped - 13 lines]
>
> Tore
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.