tfurnivall
Registered User.
- Local time
- Today, 03:47
- Joined
- Apr 19, 2012
- Messages
- 81
I'm trying to create a navigation control on the fly.
When a user logs in to my application they have the possibility of accessing several parts of the application at several levels. Specifically there are seven main areas each of which has up to 10 sub-areas. Depending on the capabilities of the user some (or possibly all) of the main areas are available, and any number (including none) of the sub-areas are available - either as a class of objects or as a single object.
As an example, one of the sub-areas concerns surveys. Some users are allowed to access all surveys, while others are allowed to access only the survey (or surveys) for which they have signed up. In this case the main area for surveys will be available, but in one case the Surveys sub-area would be captioned "Surveys", while on the other it would have the caption of the Survey name. The first user would have a sub-form that provides (relatively ;-) unlimited access to all the surveys in the system, while the second user would have access only to the "fill out survey" capability for the survey - or surveys - where they have a presence.
Just to make this a little more problematic, different users can have widely - and wildly - differing sets of capabilities. Some administrative users would have unrestricted access (makes development so much easier, doesn't it), but others could have 'clerical' like access to a whole class (of membership organizations, say), but only access to a single survey, while others would have access only to their own membership information, while being able to look at all administrative data for other organizations. The security design for this was fun, but is done. Now I have to implement it!
So - I want to build the navigation form on the fly, customizing it to different users. This is what I've gathered so far.
A two level navigation control actually seems to be one Main navigation control (I think its default name is NavigationMainOptions), to which are attached a series of (secondary) Navigation Controls called, appropriately enough, NavigationSubOptions. There is also a subform area (NavigationSubForm, and an EmptyCell area at the top left hand corner. All of this is provided by the Navigation Wizard.
Question is, how do I create all this using nothing but VBA?
The MS documentation is, as usual, remarkably silent on this sort of thing. After all why would anybody want to do this, when they have a wizard available to do it for them?
Any one got any ideas, or tried this before?
Tony
When a user logs in to my application they have the possibility of accessing several parts of the application at several levels. Specifically there are seven main areas each of which has up to 10 sub-areas. Depending on the capabilities of the user some (or possibly all) of the main areas are available, and any number (including none) of the sub-areas are available - either as a class of objects or as a single object.
As an example, one of the sub-areas concerns surveys. Some users are allowed to access all surveys, while others are allowed to access only the survey (or surveys) for which they have signed up. In this case the main area for surveys will be available, but in one case the Surveys sub-area would be captioned "Surveys", while on the other it would have the caption of the Survey name. The first user would have a sub-form that provides (relatively ;-) unlimited access to all the surveys in the system, while the second user would have access only to the "fill out survey" capability for the survey - or surveys - where they have a presence.
Just to make this a little more problematic, different users can have widely - and wildly - differing sets of capabilities. Some administrative users would have unrestricted access (makes development so much easier, doesn't it), but others could have 'clerical' like access to a whole class (of membership organizations, say), but only access to a single survey, while others would have access only to their own membership information, while being able to look at all administrative data for other organizations. The security design for this was fun, but is done. Now I have to implement it!
So - I want to build the navigation form on the fly, customizing it to different users. This is what I've gathered so far.
A two level navigation control actually seems to be one Main navigation control (I think its default name is NavigationMainOptions), to which are attached a series of (secondary) Navigation Controls called, appropriately enough, NavigationSubOptions. There is also a subform area (NavigationSubForm, and an EmptyCell area at the top left hand corner. All of this is provided by the Navigation Wizard.
Question is, how do I create all this using nothing but VBA?
The MS documentation is, as usual, remarkably silent on this sort of thing. After all why would anybody want to do this, when they have a wizard available to do it for them?
Any one got any ideas, or tried this before?
Tony
