J
jskernahan
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
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