Prev: calculations between subforms
Next: Open form to specific record from button on continuous form
From: Frank on 22 Dec 2009 09:54
Allen,

What I want is when we are in form view, I create a button to see it in datasheet view, but bofore go to it, there is a form to promt us list of all fields by tick it up that is to say those are the fields that we want to see in the datasheet view, and when we want to export, those are what we want.

Thanks in advance

Frank



Allen Browne wrote:

Simplest solution might be to set the Visible property of the controls onthe
22-Dec-09

Simplest solution might be to set the Visible property of the controls on
the form, based on the fields the user wants to see.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP nested includes problem
http://www.eggheadcafe.com/tutorials/aspnet/9ccc4fde-e460-439a-ae22-50071241e1d3/asp-nested-includes-probl.aspx
From: Allen Browne on 22 Dec 2009 11:08
Easy enough to use a multi-select list box with Row Source Type set to Field
List so the user can select the fields they want.

Then set the ColumnHidden property of the controls to hide them in Datasheet
view.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Frank Situmorang" wrote in message
news:2009122295415hfsitumo2001(a)yahoo.com...
> Allen,
>
> What I want is when we are in form view, I create a button to see it in
> datasheet view, but bofore go to it, there is a form to promt us list of
> all fields by tick it up that is to say those are the fields that we want
> to see in the datasheet view, and when we want to export, those are what
> we want.
>
> Thanks in advance
>
> Frank
>
>
>
> Allen Browne wrote:
>
> Simplest solution might be to set the Visible property of the controls
> onthe
> 22-Dec-09
>
> Simplest solution might be to set the Visible property of the controls on
> the form, based on the fields the user wants to see.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> Previous Posts In This Thread:
>
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> ASP nested includes problem
> http://www.eggheadcafe.com/tutorials/aspnet/9ccc4fde-e460-439a-ae22-50071241e1d3/asp-nested-includes-probl.aspx

 | 
Pages: 1
Prev: calculations between subforms
Next: Open form to specific record from button on continuous form