Datasheet Problem

Stew
StarLounger
Posts: 76
Joined: 14 Jul 2010, 19:35

Datasheet Problem

Post by Stew »

I have a table that I allow the user to open in datasheet view. However once I finish I plan on locking right click commands out. Is there a way I can imbede a back button in the data sheet. I want them to being able to sort, filter, and resize like excel. That is why I didn't use a continious form. Is this possible?

User avatar
HansV
Administrator
Posts: 78530
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Datasheet Problem

Post by HansV »

You can't embed any buttons in a datasheet. What would the function of a "back button" be?
Best wishes,
Hans

Stew
StarLounger
Posts: 76
Joined: 14 Jul 2010, 19:35

Re: Datasheet Problem

Post by Stew »

I have set up a navigation through forms, locking out the navigation bar from the end user. So I have button set up on the forms to open a new form, and close the current one. The back button would go to the previous form, and close the current one.

User avatar
HansV
Administrator
Posts: 78530
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Datasheet Problem

Post by HansV »

A datasheet is just that, you can't place any buttons on it. You could place the datasheet form as a subform on an unbound form, and place the button on the unbound main form.
Best wishes,
Hans