Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Controlling Columns in Datasheet View

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  No need for customized menus, toolbars, or ribbon..  
Author Message
Neil Ginsberg

External


Since: Dec 2, 2008
Posts: 1



(Msg. 1) Posted: Tue Dec 02, 2008 2:44 am
Post subject: Controlling Columns in Datasheet View
Archived from groups: comp>databases>ms-access, others (more info?)
Is there a way to control which columns the user displays in Datasheet view?
I have certain fields hidden, and I want to prevent the user from being able
to display them by going to Unhide Columns.

Is there any event that is triggered when the columns in Datasheet view are
changed, or is there some other way to control which columns are displayed
in Datasheet view? I'm using Access 2003.

Thanks!

 >> Stay informed about: Controlling Columns in Datasheet View 
Back to top
Login to vote
Allen Browne

External


Since: Dec 2, 2008
Posts: 25



(Msg. 2) Posted: Tue Dec 02, 2008 7:13 pm
Post subject: Re: Controlling Columns in Datasheet View
Archived from groups: per prev. post (more info?)
Simplest way is to create a query that delivers only the fields you want.
Then there is nothing for the user to unhide.

If that's not suitable, perhaps Continuous View would suit, rather than
Datasheet View.

 >> Stay informed about: Controlling Columns in Datasheet View 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Information in 'form view' not displaying in 'table view'? - Is this a common problem? Data in certain columns in my form view are not diaplying when i change to 'table view'. I need to perform calculations on the data in table view but can't access it. Any ideas? Help will be much appreciated. Thanks.

Right-Click Datasheet Menu Help - Access 2007 I would like to create a right-click menu that replicates the built-in sorting/filtering one that appears when you right-click on a form in datasheet view. Microsoft in their infnite wisdom don't allow you to use the built in toolbars wit...

Design View from Form View - I seem to remember that it was possible to move into design view from form view by right clicking on the mouse whilst pointing at the bar at the top of the form where the caption is held. However, I do not seem to be able to do this now. Is there a..

Columns to Raws possible? - Hi I've a query that looks like this: Language Activity1Volume Activity2Volume Activity3Volume Activity4Volume English 3 0 5 9 French 9 4 ...

How to view a reply to a question - I posted a question and was notified there is a reply waiting, but I only see a blank white screen. How can I view the response? Perhaps you could reply directly to my email. Thanks.
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]