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

[Rocky Smolin]

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/Save-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