RonPaii
Active member
- Local time
- Today, 02:07
- Joined
- Jul 16, 2025
- Messages
- 439
Attached is a sample database of my Access menu system.
The main form is SYS which uses the menu system to show Forms and Reports with the option to change access level and module. Only 3 of the forms on the menu are included Accounts Receivable, Job: Master and Parts: Detail. The beMenu table holds the menu items, this was originally a report menu but now [ReportName] holds both form and report names. The forms fills combo box with the form's menu using the [Key] value for that form. Set the FORMMENUKEY constant in each form to that key value.
The menu handles 3 types, Forms, Reports and Actions.
In this sample, USER ID, User Type ID and Allowed Types are handled in the SYS form. In production they are handled by as user class.
The main form is SYS which uses the menu system to show Forms and Reports with the option to change access level and module. Only 3 of the forms on the menu are included Accounts Receivable, Job: Master and Parts: Detail. The beMenu table holds the menu items, this was originally a report menu but now [ReportName] holds both form and report names. The forms fills combo box with the form's menu using the [Key] value for that form. Set the FORMMENUKEY constant in each form to that key value.
The menu handles 3 types, Forms, Reports and Actions.
In this sample, USER ID, User Type ID and Allowed Types are handled in the SYS form. In production they are handled by as user class.
