Question Creating a User friendly Interface

[purceld2]

I have created quite a bit of functionality via Queries, Macros and Modules. What I like to do now is have nice user friendly interface which would be presented to the user when he opens the application.

From the interface he could run macros etc.

I have no idea how this can be done and if it can if it would be difficult.

Thanks in advance

Des

 

[Alansidman]

Des;
I would create a new form to use as a menu. On the form place command buttons that open other forms, queries, reports, etc. You can have them run macros, etc. Then ggo to Tools, Startup and select your new form as the form to open when your dB opens.

Alan

 

[gemma-the-husky]

look at the switchboard provided with access

i use that for most apps

 

[Simon_MT]

Creating your own Menus is dead easy. If you are using 2007 use the Command Buttons and "Use Windows Themed Controls on Forms" and onclick. I don't want to upset the husky but Menus give you total control over the User Interface.

Simon

 

[gemma-the-husky]

simon

i hardly ever use A2007, and then its just to support A2003 converted apps

sounds an interesting alternative

 

[Alansidman]

Des;
Here is something that I have used in the past.

http://www.datawright.com.au/access_resources/access_menu_report_launcher.htm

Alan