by "AccessVandal via AccessMonster.com" <u18947@[EMAIL PROTECTED]
>
Dec 3, 2008 at 07:02 AM
If the user hide the column in datasheet view, the next time when the user
open the form again the column hidden will still be hidden until the user
unhide the column. So there no need to use any code.
jskernahan@[EMAIL PROTECTED]
wrote:
>Hi there,
>
>I have created a database that has login names and users. In this
>database, I have a datasheet form which can allow users to Hide/Unhide
>columns using format -> Unhide columns. I am trying to make the
>database remember which columns were hidden by which users so that the
>users don't constantly have to hide/unhide the columns they want to
>see.
>
>My approach to this is the following:
>- Create a table with two field names: UserName, HiddenColumns
>- Run a VB procedure on the "On Load" even of the form which looks
>into the table and sees which columns are hidden by the logged in
>user, then hide the appropriate columns.
>- Run a VB procedure on the "On Close" even of the form which looks to
>see which controls on the form are hidden, then then adds them to the
>HiddenColumns Table with the appropriate username.
>
>I am a relative novice when it comes to coding so I'm hoping there's
>someone out there that can help me?!? Thanks
>
>James
--
Please Rate the posting if helps you
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200812/1
