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

[Rocky Smolin]

Anders:

Thank you.  I'll give it a go.

Rocky


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

You could try the code in the attached zip file. I can't take credit for it
myself though, a co-worker wrote it. I've attached both the accde and the
accdb. Seems simple but effective.

Best regards
Anders Ebro // TheSmileyCoder <http://www.thesmileycoder.com> Access MVP
2014-2018 <http://mvp.microsoft.com/en-us/mvp/Anders%20Ebro-5000469>

On Mon, Oct 30, 2017 at 10:09 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> Yes but it could be sent in accde.
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Anders Ebro (TheSmileyCoder)
> Sent: Monday, October 30, 2017 1:43 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> Are you still using mde?
>
> Sent from my mobile device, and thus kept brief.
>
> On 30 Oct 2017, at 19.50, Rocky Smolin <rockysmolin at bchacc.com> wrote:
>
> Bill:
>
> It has to work in an mde or accde.  So I don't think I can open the 
> form in design view. I also have to save the column widths.
>
> Further complication - there are 11 of these sub forms each for a 
> different back end table and an option frame on the parent form with 11
buttons.
> When
> the user selects a different table I change the source of the subform 
> objet.
> Works fine, though - I added an (admitted) kludge to save the field 
> orders and widths.  But it only worked in mdb/accdb not mde/accde.
>
> So I think if I can find a way to do one I can do all 11.
>
> T&R
>
> Rocky
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Bill Benson
> Sent: Monday, October 30, 2017 11:40 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Changing Column Width and Order in mde or accde
>
> I don't think so. Column order defaults to the order in which the 
> fields were added to the data sheet subform. Perhaps what you could do 
> however is keep a table with their column and their user name, on the back
end.
>
> Make the subform control's sourceobject an empty string, save the 
> parent form.
>
> In the open event of the parent form, open the subform in design view 
> (using VBA code), dynamically add fields in the order specified in the 
> backend table, save, and close the local subform. Then in the Load 
> event of the parent form, re-associate the sourceobject.
>
> I think at that point the subform's fields will be in the correct order.
>
> Bill
>
> On Mon, Oct 30, 2017 at 12:27 PM, Rocky Smolin 
> <rockysmolin at bchacc.com>
> 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
>
> --
> 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