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

Rocky Smolin rockysmolin at bchacc.com
Mon Oct 30 19:18:38 CDT 2017


I saw the line break - pasted in the whole URL.  Fail.

Anyway, the tinyurl worked.

Thanks

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Monday, October 30, 2017 5:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Changing Column Width and Order in mde or accde

Yes, but watch for line break and/or a space in that long URL.  Here's the
TinyURL
http://tinyurl.com/ydb4ld89


On 30 Oct 2017 at 16:54, Rocky Smolin wrote:

> That's remarkable! Or could be - I'll know better when I can get to 
> their site ('An error occurred while processing my request')
> 
> I'll check again later. Does the link open for you?
> 
> R
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Stuart McLachlan Sent: Monday, October 30, 2017 1:58 PM To: Access 
> Developers discussion and problem solving Subject: Re: [AccessD] 
> Changing Column Width and Order in mde or accde
> 
> Just found this - turns out you need to manipulate the Registry!!!
> 
> http://www.databasejournal.com/features/msaccess/article.php/3627056/S
> ave-an d-Retrieve- Datasheet-Layout-with-the-Windows-Registry.htm
> 
> "In addition to the scenario I described above, this process must be 
> followed if you want to allow users to modify datasheet layout when 
> they are using a compiled MDE version of your Access applications.
> Since the design view is locked in an MDE, users cannot save "changes"
> to the form. They can move around columns and resize them, but once 
> the form is closed, the changes are lost forever. The only way around 
> it is to implement the code I show below. " ... "The data for each 
> datasheet's settings are stored in the Windows Registry under a key 
> with the name of the datasheet. The LoadUserColumnSetup pulls that 
> data and applies it, while the SaveUserColumnSetup writes the latest 
> data back to the Registry. Each of those functions take an Access.Form 
> variable, which can be identified by the Me object to simplify the 
> application of the code. Below is a listing of all the code involved.
> Comments interspersed will explain the process. " ...
> 
> 
> On 30 Oct 2017 at 9:27, Rocky Smolin wrote:
> 
> > Dear List:
> > 
> > 
> > 
> > I have a form with a sub-form - the subform is datasheet view 
> > because the user needs to be able to change the column widths and 
> > order.  This works in a mdb and an accdb - the changes are save so 
> > when the user returns to the form the altered order and widths are 
> > retained and displayed.
> > 
> > 
> > 
> > But while the user can change the order and column widths in the mde 
> > and accde versions, the changes are not saved.
> > 
> > 
> > 
> > Is there a workaround for this?  
> > 
> > 
> > 
> > MTIA
> > 
> > 
> > 
> > 
> > 
> > Rocky Smolin
> > 
> > Beach Access Software
> > 
> > 760-683-5777
> > 
> >  <http://www.bchacc.com> www.bchacc.com
> > 
> >  <http://www.e-z-mrp.com> www.e-z-mrp.com
> > 
> > Skype: rocky.smolin
> > 
> > 
> > 
> > 
> > 
> > --
> > 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
> 
> --
> 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