Data sheet view

[Beeyen]

Good Day

In access 97, I have chosen to not allow full menu at startup in order to
prevent accidentally tampering with the design. But I have users that need to
use the Data Sheet view option. Is there a way for this to be accomplished
without allowing access to the full menu and the Design View?
Let me know
Thanks

 

[Rick Brandt]

Good Day

In access 97, I have chosen to not allow full menu at startup in
order to prevent accidentally tampering with the design. But I have
users that need to use the Data Sheet view option. Is there a way
for this to be accomplished without allowing access to the full menu
and the Design View?
Let me know
Thanks

Datasheet view of what exactly? Tables, Queries, Forms? Only the letter
shoud be "required" for any user. Any of them can be opened from a menu or
switchboard without displaying the db window or default menus.

DoCmd.OpenTable
DoCmd.OpenQuery
DoCmd.OpenForm (with acFormDS as the FormView option)

 

[Beeyen]

Good Day Mr. Brandt and thank you for the quick response;
What is happening is some users are doing a filter by selection of a
specific field in a form then looking at the items selected in the Datasheet
view. If I disable the full menu at startup the view icon (with design view,
form view and datasheet view) is not available. I would like for them to
only have access to the datasheet view, again to prevent entering the design
view. Your thoughts!

 

[Arvin Meyer [MVP]]

You can build custom menus, or customize the current existing menu. I
suggest that you use the existing menu as a guide, and create your own menu,
with just the commands you want on it.

Right-click on the toolbar, and choose Customize, then click on the Tollbar
tab and choose New.

 

[Beeyen]

Thanks you Mr Arvin,

Very good solution and most productive. I will give it a try.