Re: list of fields to show

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@xxxxxxxxxxxx
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

.

Relevant Pages

  • Re: fields updatable only if a condition is met (Access 2002)
    ... You should be able to set the control's Visible property - unless it has the ... Allen Browne - Microsoft MVP. ... >> You probably want to use the Undo event of the form to reset the controls ...
    (microsoft.public.access.forms)
  • Re: Check box to control editability of certain fields in a form
    ... Change the Visible property of the controls instead of the Locked property. ... That will trigger an error if you try to hide the control that has the focus, so you will need to use error handling. ... Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.forms)
  • Re: Option for fields to show up in datasheet view
    ... 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. ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.formscoding)
  • Re: fields updatable only if a condition is met (Access 2002)
    ... > You should be able to set the control's Visible property - unless it has the ... > Allen Browne - Microsoft MVP. ... >>> PmtMethod is changed, and also whenever a record is loaded into the form. ... >>> You probably want to use the Undo event of the form to reset the controls ...
    (microsoft.public.access.forms)
  • Hide Controls in Subforms
    ... > Depending on the user level I want some controls to be hidden so I ... > the following code in the Form Open Event of the Subform ... I believe that when you are using a subform in datasheet view the ... visible property is not working so after I read this to Microsoft's ...
    (microsoft.public.access.forms)