When I was confronted with this need/problem/challenge, I went out and bought (for *very* little money) a piece of source code which saves and restores datasheet layouts for your users.
http://www.mosstools.de/index.php?option=com_content&view=article&id=79&Itemid=78
It's a german site (and I'm not associated with them in anyway, other than the fact that I've bought some of their stuff) but the downloadable example (mde format) might be enough to show you that it works and is worth the six euros, unless you earn less than that per hour ;-)
--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> Hi
>
> I am trying to move a column in datasheet view but when I save it and then reopen the form again (it defaults to datasheet view), it reverts to its original position.
>
> I have many forms that I use in this way and I can move cols and save them and they stay in the new position.
>
> What could it be about this particular form?
>
> NB no subforms are involved and the form is opened via a macro in order to default to datasheet view
>
> I would appreciate any help
>
> Phil
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (12) |
Tidak ada komentar:
Posting Komentar