Multiple Switchboards - Titles/Headers

[carriey]

I have 2 switchboards which I created using the Switchboard Manager. I would
like to use some text boxes to create headers/titles to group like items
together (ie. Tracking Forms, Management Reports....)

Everytime I try to do this, it creates the titles on both switchboards
instead of the one I have selected. I obviously need the titles to be
different on each one. Can you please tell me how to do this? Thanks a
bunch!

 

[fredg]

I have 2 switchboards which I created using the Switchboard Manager. I would
like to use some text boxes to create headers/titles to group like items
together (ie. Tracking Forms, Management Reports....)

Everytime I try to do this, it creates the titles on both switchboards
instead of the one I have selected. I obviously need the titles to be
different on each one. Can you please tell me how to do this? Thanks a
bunch!

You can change some of the code in the Switchboard's Private Sub
FillOptions() procedure.
Make the change at the If (rs.EOF) Then line.
Watch out for word wrap.

Private Sub FillOptions()
......
......
If (rs.EOF) Then
Me![OptionLabel1].Caption = "There are no items for this
switchboard page"
Else
While (Not (rs.EOF))
Me("Option" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Visible = True
Me("OptionLabel" & rs![ItemNumber]).Caption =
rs![ItemText]
rs.MoveNext
Wend
If Me.SwitchboardID = 1 Then
Label1.Caption = "I'm the Forms Menu."
Label2.Caption = "I'm the forms Menu"
ElseIf
Label1.Caption = "I'm the Reports Menu"
Label2.Caption = "I'm the Reports Menu"
Else
Label1.Caption = "I'm the Queries Menu"
Label2.Caption = "I'm the Queries Menu"
End If
End If
rs.Close
Set rs = Nothing
Set con = Nothing

End Sub

 

[Larry Linson]

I have 2 switchboards which I created using the Switchboard Manager.

Well, that was the beginning of your problems. Swichboard Manager is a
complex solution to a simple problem and always, when you do anything
outside the most simple, ordinary switchboard, causes more problems than it
ever solves. Merging two switchboards created in SM will cost you far, far
more in time and energy than the following.

My advice is different from that you got from fredg, in that it immediately
unhooks you from the Switchboard Manager.

Decide what you have and what you want, copy your "real objects" (nothing
associated with the switchboards from SM) into a clean, empty database, and
create a new switchboard, using unbound forms and command buttons.

In the long run, possibly even in the near-term, you'll be time and energy
ahead, because what you've done will be understandable without having to dig
into tables, template forms, and code to even begin understanding what the
SM is trying to do.

Larry Linson
Microsoft Office Access MVP