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

Bill Benson bensonforums at gmail.com
Wed Nov 1 08:33:35 CDT 2017


My solution already demonstrated that no external items are required.
Maintaining a table inside the MDE/ACCDE works just fine.

On Wed, Nov 1, 2017 at 9:12 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> Gustav:
>
> Well that's true - they would have to re-establish their preferences. So
> putting those setting in an external mdb/accdb or a text file which would
> reside in the user's front end folder would solve that, yes?
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Gustav Brock
> Sent: Wednesday, November 01, 2017 1:03 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> Hi Rocky
>
> Or maybe not, as all settings will be lost when you update the frontend.
> We used a separate backend for storing user settings.
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af
> Rocky Smolin
> Sendt: 31. oktober 2017 22:19
> Til: 'Access Developers discussion and problem solving' <
> accessd at databaseadvisors.com>
> Emne: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> As I think about it, since it would be an advantage to let each use save
> their own field order and widths, saving the properties in a front end
> table might be an advantage.
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Jim Lawrence
> Sent: Tuesday, October 31, 2017 1:40 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> An excellent method to save your last position.
>
> I did a similar process many years ago with VB. Had a module that would
> open a registry set and then loop around pushing all global variables and
> position variable into the stack. When the application opened again, even
> after a system update, each user would have the environment they exited
> with...if they so chose. Unfortunately, even with the best efforts it was
> never a hundred percent.
>
> We do now have some excellent sync tools which could make much of that
> type of work redundant.
>
> Jim
>
> ----- Original Message -----
> From: "Gustav Brock" <gustav at cactus.dk>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>
> Sent: Tuesday, October 31, 2017 12:33:54 AM
> Subject: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> 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