Error handling in objects?

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.
 
G

Guest

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.

You have to add VBA code to get messages like that.
So the menu has to call through to a VBA function.

There are a couple of ways to achieve that. You could replace
all your forms with dummy forms, or use menu calls to macros
instead of forms. We just call functions from the menu items.

(david)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top