Need help with homemade Switchboard

yus786

I do OK
Local time
Today, 20:44
Joined
Jun 25, 2008
Messages
121
I currently have this:

Old_SB.jpg


Where the user would select the required module. This would then bring up the selected form and an exit option within the form to get back to the above.

However i would like to try something like this:

New_SB.jpg


So the user would select the required form and this would appear in the square area. They could then select on ANY form and that would appear in the square area (just one form can be open at one time)

How do i go about doing this?

Thanks
 
Look into SubForms.

Thanks but i thought subforms needs to haver child/parent relationships?

My setup above are not related. I just want to be able to click on any command button and have that form appear in the middle.
 
SubForms need to have this relationship if you want them to remain synchronized but it is not a requirement just to have a SubForm on your form.
 
>>>Thanks but i thought subforms needs to haver child/parent relationships?<<<

No ... no necessary in this situation.
 
Thanks RuralGuy and Uncle Gizmo, i didn't know.

See i always use the subform wizard.

Any tips on how to get started?

Thanks as always
 
just put any subform in the template area,and call it mysubform (say)

after you click whichever option, all you need is

mysubform!sourceobject = "whatever form you actually want to use"

----------
I don't realy like the idea of doing it this way though. Why not just open whichever form you want as a form

docmd.openform "someform"
 
Once you have placed the SubFormControl on your form then all you need to do is change the SourceObgject of the SubFormControl to change the form displayed in that control.
 
just put any subform in the template area,and call it mysubform (say)

after you click whichever option, all you need is

mysubform!sourceobject = "whatever form you actually want to use"

----------
I don't realy like the idea of doing it this way though. Why not just open whichever form you want as a form

docmd.openform "someform"

Thanks

That's what I have at the moment but want to chAnge the look. See all the forms are different sizes and I've tried to replicate the sizes of each but still get some form a few cm's up or down. And this doesn't look very professional.

Hence looking at sunforms so atleast all forms will remain the same size.
 
just put any subform in the template area,and call it mysubform (say)

after you click whichever option, all you need is

mysubform!sourceobject = "whatever form you actually want to use"

----------
I don't realy like the idea of doing it this way though. Why not just open whichever form you want as a form

docmd.openform "someform"

I tried this but get "the expression you entered refers to an object that is closed or doesn't exist"

Any idea's?

EDIT: It does work, needs to be mysubform.sourceobject =

Thanks for your help
 
I tried this but get "the expression you entered refers to an object that is closed or doesn't exist"

Any idea's?

EDIT: It does work, needs to be mysubform.sourceobject =

Thanks for your help


yes, it is dot, not bang isnt it.

Do you like the effect, that way?
 
See all the forms are different sizes and I've tried to replicate the sizes of each but still get some form a few cm's up or down. And this doesn't look very professional.

An option you could use is MoveSize to position forms on the screen.

Put the "Menu" on the side and start the forms to the right. That way, if a form is wider than the next, then it still displays correctly without having to go and resize all your forms.

Have a background form on which the menu and forms sit that has the same colour as the forms. Adjust just this one form width to accomidate your widest form.

Also see http://my.advisor.com/doc/05352 for info on Dot vs Bang
 
Last edited:
Thanks all

Is there a hard and fast rule regarding getting all forms the same size?

I have looked at Form Width, Header and Detail Hight, Grid X and Y, but some are still bigger than others

Thanks again for all your help everyone. I have learnt so much in 2.5 yrs i have been on here.
 
You want to set the width in form properties, but the height in detail properties (remember your headers and footers height contribute to the height). That is the way I do it.

example:
Form Width = 26cm (a nice size to fit a 4:3 screen)
Header Height 1cm (two rows of 0.5cm fields @ Arial 11pt)
Detail Height 10cm (twenty rows of 0.5cm @ Arial 11pt or 25 rows of 0.4cm @ Arial 9pt)
Footer height 1 cm (1 row of buttons of 0.8cm @ Arial 11pt. Fits button pics that comes with Acccess)
Total height = 12cm. I think 15 is max to fit a 4:3 screen.


or

If you are using scroll bars then use the size option in MoveSize (either through a Marco or Event Procedure).

Code:
MoveSize(Right, Down, Width, Height)
example MoveSize(, , 10, 10)
 

Users who are viewing this thread

Back
Top Bottom