A
Access
I have a db that I have given to three different users on three different
companies. Each user has paid for a different portion of the db. eg user 1
has file management, user 2 has file and inventory management, and user
three has all the above plus employee management.
Each of them can use all the "modules" but they have not bought them. So (to
make my life easier) I just deleted the forms and queries that each user has
not bought, thus if one wishes to buy an "module", I just update only the
FE. This also got me to delete the references to these forms and reports
from the menus.
But (to put a touch of marketing) I want to not have to alter the menus,
just the db objects, and when a user clicks a menu item, that the
corresponding form doesn't exist, I want a dialog box to pop up to inform
the user that has to buy that "module" for that form/report to work.
To sum all the above up, is it possible to add error handling to the menu
items, and if so, how is it done?
PS. I am very fond of the drag n' drop function in the menu & toolbar
customize and I wouldn't like to change that ease.
thanx in advance.
companies. Each user has paid for a different portion of the db. eg user 1
has file management, user 2 has file and inventory management, and user
three has all the above plus employee management.
Each of them can use all the "modules" but they have not bought them. So (to
make my life easier) I just deleted the forms and queries that each user has
not bought, thus if one wishes to buy an "module", I just update only the
FE. This also got me to delete the references to these forms and reports
from the menus.
But (to put a touch of marketing) I want to not have to alter the menus,
just the db objects, and when a user clicks a menu item, that the
corresponding form doesn't exist, I want a dialog box to pop up to inform
the user that has to buy that "module" for that form/report to work.
To sum all the above up, is it possible to add error handling to the menu
items, and if so, how is it done?
PS. I am very fond of the drag n' drop function in the menu & toolbar
customize and I wouldn't like to change that ease.
thanx in advance.