By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

IF THEN - Hide toolbars for users

P: 9

I have made a form for entering suggestions, what I want to happen is if I open the form I can see all the toolbars, design view etc . . .

but if another user opens the form all information is hidden.

Also if possible when user "cornsg" opens the database I want that user to be shown a different form to everyone else opening it.

I have set it up so when the database is opening it auto opens a form that says welcome then after 5 secs opens a form that users imput data.

Any help will be really appreshicated please reply / email me

Feb 6 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 446

This depends how much work you want to do!

The simplest way is to design a 'custom' menubar with only the options you want users to have access to; just Quit by the sound of it if you only have one form.

You will then have to set this to your form(s) (Form Properties > Other > Menu Bar) otherwise they will always have a default menu.

Go into Tools > Startup and un-check everything, set your Menu Bar and Startup form.

When anybody starts the system they will only have access to what you have given them on the Menu Bar.

When you start the system, hold down the Shift key while it's firing up and then you will have full design capability.

This is very basic level security but may be OK for your app.

If you want a particular user to have a different experience to others then your first screen must be a login-screen; from that you can redirect him as neccessary.

If you want something more sophisticated you'd better read the Help on User Level Security

Feb 6 '08 #2

P: 9
ok thank you VERY MUCH!!! this was very helpful!

One other question.

I have the database on the network now for testing purpose's however when someone opens it, it locks the database and makes everyone else have read only access how do I make it so that everyone can use the form at the same time?


Feb 7 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.