Question how to make a user friendly access?

[ariansman]

There are many forms and queries on the database which are visible on the left pane. Is there a kind of shortcut available that can be put on the desktop by which the user can directly go to a specific form or report directly?
thank you

 

[pr2-eugin]

I am not sure if this is exactly simpler enough, but I would suggest creating a Interface Form that will have button which on click will take you to the exact form/report/table/query, then you can go to Options-->Current Database-->uncheck Display Navigation Pane option and also Make sure the display form to be the interface. then close and reopen the Database. You will have just ONE plain interface you could interact with the whole database. Hope this is understandable..

 

[Lightwave]

For something which is very quick and dirty you can go to the database window and drag a form onto the desktop. That will take you to the exact form you are interested in.

Be warned if there is no navigation on this form users may get access to the database window.

 

[ariansman]

I am not sure if this is exactly simpler enough, but I would suggest creating a Interface Form that will have button which on click will take you to the exact form/report/table/query, then you can go to Options-->Current Database-->uncheck Display Navigation Pane option and also Make sure the display form to be the interface. then close and reopen the Database. You will have just ONE plain interface you could interact with the whole database. Hope this is understandable..

thank you this sounds great. Could you let me know where i should make this "Interface Form"? i could not find it on create/forms. moreover will this "Interface Form" have an isolated icon so that the user starts it easy?

 

[Simon_MT]

I is just a Form with Buttons on it shall we say Menu.

Here is an example

Simon

 

[pr2-eugin]

Hello ariansman, if you follow the steps i have mentioned, you will have only one form(virtually visible) to the users, thus you can just open that by double clicking the file. When you open it you will find something like what Simon_MT has shown.

You have to create this 'Interface Form' which is not bound to any table. So go to Create--> Form--> Blank Form Design. Add as many buttons as you like each associated with a DoCmd in the OnClick event.
http://www.access-programmers.co.uk/forums/member.php?u=102490