Option for fields to show up in datasheet view

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Since most people are more familiar with excel then access, my users prefer
to see it in datasheet view. However, since it could be too long, anyone can
help me how to make an option to show up only field that we can chose in the
form.

I remember there is a sample of database that has that one, but I do not
know where is it now. Please help.

Thanks in advance,

Frank
 
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,

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 o
the form, based on the fields the user wants to see

-
Allen Browne - Microsoft MVP. Perth, Western Australi
Tips for Access users - http://allenbrowne.com/tips.htm
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/tutorial...2-50071241e1d3/asp-nested-includes-probl.aspx
 
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

Reply to group, rather than allenbrowne at mvps dot org.


in message
news:[email protected]...
 
Back
Top