[AccessD] Changing Column Width and Order in mde or accde

Jim Lawrence accessd at shaw.ca
Tue Oct 31 15:26:48 CDT 2017


Very good answer.

Aside: How do you think MS Access runs so well on a Linux box(?)...it must be constantly tricked with work arounds. ;-)

Jim

----- Original Message -----
From: "stuart" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, October 31, 2017 1:09:57 AM
Subject: Re: [AccessD] Changing Column Width and Order in mde or accde

You're correct.   That link uses the the fact that Access stores that data in the registry, but 
there is no reason you can't store and retrieve it yourself from somewhere else.

On 31 Oct 2017 at 7:33, Gustav Brock wrote:

> Hi Stuart
> 
> Oh no. "All you need" is to read and save the properties of the
> columns to a set (a tree) of tables before closing the form, then read
> from the tables and restore the settings when opening the form.
> 
> I once wrote a full system for a client who wanted this feature. It
> went a bit like this:
> 
> ID UserSettingFormSubformID Name ColumnOrder	ColumnWidth	ColumnHidden
> 1  1	ID		1	-1	Sand 2  1	Dimension		2	1875	Sand 3 
> 1	DimensionElementOrder	4	-1	Falsk 4  1	DimensionElement	3	1995	Falsk
> 5  1	DimensionElementProportion 5	2850	Falsk
> 
> Those basic settings are not difficult. The challenge is the get hold
> on frozen columns. Sort order for each column was also added.
> 
> I considered writing an article about this but gave up, as the setup
> was heavily intermixed with application settings for Format and
> Conditional Formatting, as well as default settings which - and this
> is important - the user could choose to revert to in case he/she got
> the layout garbled beyond easy restoring at the user level.
> 
> Add to this maintenance of the settings. It was a large application
> and just about all forms had subforms in datasheetview. We made a
> function to rebuild all the current settings as default settings; this
> function was called when the user belonged to the developer group of
> users.
> 
> /gustav
> 
> 
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> Stuart McLachlan Sendt: 30. oktober 2017 21:58 Til: Access Developers
> discussion and problem solving <accessd at databaseadvisors.com> Emne:
> Re: [AccessD] Changing Column Width and Order in mde or accde
> 
> Just found this - turns out you need to manipulate the Registry!!! 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list