New to Navigation Forms (1 Viewer)

ReginaF

Registered User.
Local time
Today, 14:12
Joined
Sep 23, 2019
Messages
26
Hello!

I would like to ask for your kind help in the use of Navigation Form.

I have already created a bunch of forms that are 'linked together' with buttons. They work really well, but now I decided to create one Navigation form for some of my already existing forms.
When is inserted the forms to the Navigation Form my command buttons stopped working (many of those buttons are for closing the form and opening a new one).
I have already inserted one form to the Navigation Form and when I click the Open button on the form it does not close the navigation form, however opens the desired 'other form' (that is not in the navigation form). And when I click the Back button on this other form it closes it, however it can not open the form inserted into the navigation form :(

I would like to ask for your help in resolving this problem. I have never used navigation forms before, and I do not know how to refer to it and its subforms.

Thanks in advance.
Regina
 

vba_php

Forum Troll
Local time
Today, 08:12
Joined
Oct 6, 2019
Messages
2,884
Regina,

Your mention of using so many forms doesn't really sound like that great of practice. Please post either the code that is not working or a sample file that we can take a look at.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:12
Joined
Oct 29, 2018
Messages
21,358
Hi Regina. When using a Navigation Form, instead of using the OpenForm method, try using the BrowseTo method.
 

AccessBlaster

Registered User.
Local time
Today, 06:12
Joined
May 22, 2010
Messages
5,828
Hi Regina, did you use the wizard to help build your Nav form? I have done a few of these, as long a the donor form(s) are operational prior to adding them to the nav form it should work.
 
Last edited:

Micron

AWF VIP
Local time
Today, 09:12
Joined
Oct 20, 2018
Messages
3,476
Why use buttons on forms to open some other form rather than the navigation buttons themselves? As stated, seeing the code might be required because nav forms behave somewhat like a form/subform design. The nav form adds an extra layer in the hierarchy.
@ReginaF - hope you have decided to go this route after researching the use of nav forms. They do have their issues - perhaps mostly that you can only have one form open at a time. Open a second form and the first closes.
 

AccessBlaster

Registered User.
Local time
Today, 06:12
Joined
May 22, 2010
Messages
5,828
I think the Nav Form is Microsoft's way of updating their switchboard without using that pesky table and button limit. As stated it adds confusing layers.

For people who haven't seen this:
 

Attachments

  • NavForm.jpg
    NavForm.jpg
    68.3 KB · Views: 77

Micron

AWF VIP
Local time
Today, 09:12
Joined
Oct 20, 2018
Messages
3,476
I would roll my own switchboard or instead of a nav form, use a form with a tab control. You could get the same look and allow several forms to stay open; could even swap form recordsources, load on demand, swap forms on demand, etc.
 

ReginaF

Registered User.
Local time
Today, 14:12
Joined
Sep 23, 2019
Messages
26
Hi Regina, did you use the wizard to help build your Nav form? I have done a few of these, as long a the donor form(s) are operational prior to adding them to the nav form it should work.

Hello,
I think my forms are working. However after I added one of them (Only the the one that is like a Main form, where the other forms are linked to it) to the Nav Form, I can no longer 'return' to that form on the Nav Form(with buttons on my other forms), only to "version" of the form that was not added to the Nav Form. But I would like to create the Nav Form to make my work more user friendly, so it would be really cool if I could fix this, so that my Nav Form would be functional.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 06:12
Joined
Oct 29, 2018
Messages
21,358
Hello,
I think my forms are working. However after I added one of them (Only the the one that is like a Main form, where the other forms are linked to it) to the Nav Form, I can no longer 'return' to that form on the Nav Form(with buttons on my other forms), only to "version" of the form that was not added to the Nav Form. But I would like to create the Nav Form to make my work more user friendly, so it would be really cool if I could fix this, so that my Nav Form would be functional.
Hi Regina. To "fix" your buttons, you could try changing the code from using OpenForm to BrowseTo. Either that or just hide those buttons because the Nav Form already has the buttons either at the top or at the side, depending on your chosen setup.
 

ReginaF

Registered User.
Local time
Today, 14:12
Joined
Sep 23, 2019
Messages
26
Why use buttons on forms to open some other form rather than the navigation buttons themselves? As stated, seeing the code might be required because nav forms behave somewhat like a form/subform design. The nav form adds an extra layer in the hierarchy.
@ReginaF - hope you have decided to go this route after researching the use of nav forms. They do have their issues - perhaps mostly that you can only have one form open at a time. Open a second form and the first closes.

Hello, thanks for your reply :)
To be totally honest, I did not do a lot of prior research on Nav Forms before I decided I want to add it to my database :/
I thought it would be a good idea to make my program more "user friendly", as I have a bunch of forms, and I do not wnat them to search through all to find the ones that they need.
 

Micron

AWF VIP
Local time
Today, 09:12
Joined
Oct 20, 2018
Messages
3,476
I believe it does appear more user friendly. What it also does is add complexity to the designer and perhaps even introduce obstacles. If you research, you will probably find plenty of posts that for example, ask why they can't pass a value from one form to another. It is possible, but they don't realize that the form is no longer open so their usual methods don't work. Or they want to reference a value on a loaded form but can't figure out the syntax (as I said, the nav form adds a layer).

Anyway, not saying that you should abandon your current design, just that you should know the limitations of nav forms. I'd recommend doing some research to help decide if the issues will be a barrier to your process or simply require some learning to deal with them.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:12
Joined
Feb 19, 2002
Messages
42,981
I think the Nav Form is Microsoft's way of updating their switchboard without using that pesky table and button limit.
The Navigation form has its own limits. The switchboard as originally built limited each page to 8 items but the number of pages was infinite, not so with the Navigation Form.

I didn't like the 8 item limit to the Switchboard. I also didn't like the embedded macros version so I built my version to have 12 items and used the A2003 version as the base. changing the items to 12 per page was easy enough. It's only one line of code plus adding however many new controls as you want but once you get beyond the original 8 limit, you can no longer use the wizard to add items, you have to update the table directly. This is easy enough to do so I never even bothered building a form to help me although that would be easier. I also added the ability to open main forms in DS view without creating a macro.
Here's a picture of one example. Notice the last button is different. By convention, button 12 is always the "return" or "exit" button. You can do what you want but I like the separation. At the top of the switchboard are two textboxes that are only visible when I am logged in. They don't show for ordinary users.


If you are interested, I can upload a completely custom switchboard that uses a subform rather than hardcoded buttons but which is otherwise similar in concept to the built-in Access switchboard. This sample includes rudimentary security that is managed by the switchboard table. this sample isn't well documented at the moment so you're pretty much on your own but I will try to answer questions.

The custom switchboard app also includes this modified old style switchboard.
 

Attachments

  • Switchboard2.JPG
    Switchboard2.JPG
    55.7 KB · Views: 250
Last edited:

AccessBlaster

Registered User.
Local time
Today, 06:12
Joined
May 22, 2010
Messages
5,828
I agree the roll your own approach is superior, I take inspiration from the designs you and others have shared.
 

Micron

AWF VIP
Local time
Today, 09:12
Joined
Oct 20, 2018
Messages
3,476
Pat; if a user has no rights for using a particular button (e.g. View Log), do you just hide it and leave the gap?
 

AccessBlaster

Registered User.
Local time
Today, 06:12
Joined
May 22, 2010
Messages
5,828
I suspect a routine checks your credentials then either enables or disables the button leaving no gaps, just a dead button.

I have never seen a path displayed on a switchboard before, interesting approach.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:12
Joined
Feb 19, 2002
Messages
42,981
Pat; if a user has no rights for using a particular button (e.g. View Log), do you just hide it and leave the gap?
You could do that but you are correct in that it would leave a gap. However, in the completely custom version, omitting items would NOT leave a gap and so that would be fine. I don't omit the items from the switchboard. I leave it to the form to give users a message, mostly because forms are almost always available for viewing whether the user has update permissions or not.

I have never seen a path displayed on a switchboard before, interesting approach.
As I mentioned, the paths are only shown when I am the logged in user. The users have no need for this information. It is there to remind me whether I am working with a test or production FE and which BE I am connected to. In some apps, I've gone to the trouble of having a big red outline on forms to remind me that the BE is production. I'm pretty careful when I'm testing changes but visual clues help.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:12
Joined
Feb 19, 2002
Messages
42,981
Here's a copy of the custom switchboard. I haven't posted this before so please test carefully and let me know if I need to add any explanations or fix anything.
 

Attachments

  • SwitchboardForm20191125.zip
    1.4 MB · Views: 69
  • CustomSwitchboard.JPG
    CustomSwitchboard.JPG
    65.2 KB · Views: 187

Micron

AWF VIP
Local time
Today, 09:12
Joined
Oct 20, 2018
Messages
3,476
You could do that but you are correct in that it would leave a gap.
I asked because I was curious as to what your approach is. If I understood, you have a version (of the form or db, not sure which) that fits the user's profile or permissions. To help in an old post I developed a form that has all the controls in a pile. Depending on user, each allowed control is shifted down by an amount equal to its height + a space value, thus no gaps. Worked out well.
 

Users who are viewing this thread

Top Bottom