I am designing a dashboard for our Access database that we use at work. The goal of this dashboard is to provide a more graphical view of the information in the database and make it less likely for a user to intentionally/unintentionally change values in error.
The approach I am taking to the dashboard is this...
1) Create a main form that opens when access loads and prompts for username/password information.
2) Once correct combination is entered, the form will show a summary of that users associated records.
--The idea is to have a "tree" summary on the left hand side that can be expanded and then have graphical representation on the right hand side (such as percentages of this or that, blah blah)
--Some of these things will be hyperlinkes to pull up associated records etc...
--I want to add methods to allow the user to edit values through these forms instead of being able to access the main tables and queries directly.
* Right now I am using frames for the left hand ("tree") side and the right hand (graphical summary) side.
I have a few questions...
1) Is this the most sensible approach or does anyone know a better way to go about this?
and 2) How do i set the backcolor property of a Microsoft Forms 2.0 Frame Object to white?
The approach I am taking to the dashboard is this...
1) Create a main form that opens when access loads and prompts for username/password information.
2) Once correct combination is entered, the form will show a summary of that users associated records.
--The idea is to have a "tree" summary on the left hand side that can be expanded and then have graphical representation on the right hand side (such as percentages of this or that, blah blah)
--Some of these things will be hyperlinkes to pull up associated records etc...
--I want to add methods to allow the user to edit values through these forms instead of being able to access the main tables and queries directly.
* Right now I am using frames for the left hand ("tree") side and the right hand (graphical summary) side.
I have a few questions...
1) Is this the most sensible approach or does anyone know a better way to go about this?
and 2) How do i set the backcolor property of a Microsoft Forms 2.0 Frame Object to white?
