esu4236
asked on
Different headings on sub-switchboards
In Access 97, is there any way to have a different heading at the top of a switchboard if you have a button that takes you to a sub-switchboard? So for instance, if my main switchboard says "Contracts" and I have a button on this switchboard labeled REPORTS, so when I click on this button it takes me to a sub-switchboard. And at the top, now I want it to say "Contract Reports" instead of just "Contracts". Any way to do this??????
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Lianne,
I tried your idea, and that may work better.
nico5038,
I don't understand your message. I'm talking about the text box title that appears at the top of the main switchboard - not the actual selections on the switchboard.
I tried your idea, and that may work better.
nico5038,
I don't understand your message. I'm talking about the text box title that appears at the top of the main switchboard - not the actual selections on the switchboard.
I thought you were referring to the name of the form in the blue bar.
The textbox can be changed by adding a text column named "titletext" to the table "Switchboard Items"
and using this code in Private Function HandleButtonClick(intBtn As Integer):
' Go to another switchboard.
Case conCmdGotoSwitchboard
Me.Filter = "[ItemNumber] = 0 AND [SwitchboardID]=" & rs![Argument]
If IsNull(rs!titletext) Then
Me.Label1.Caption = "Your database name"
Else
Me.Label1.Caption = rs!titletext
End If
You'll need to replace the "Your database name" with the application name you want on the first form and all sub-switchboards require the wanted text.
Clear ?
Nic;o)
The textbox can be changed by adding a text column named "titletext" to the table "Switchboard Items"
and using this code in Private Function HandleButtonClick(intBtn As Integer):
' Go to another switchboard.
Case conCmdGotoSwitchboard
Me.Filter = "[ItemNumber] = 0 AND [SwitchboardID]=" & rs![Argument]
If IsNull(rs!titletext) Then
Me.Label1.Caption = "Your database name"
Else
Me.Label1.Caption = rs!titletext
End If
You'll need to replace the "Your database name" with the application name you want on the first form and all sub-switchboards require the wanted text.
Clear ?
Nic;o)
ASKER
That may be the way we go -- set up a separate form with all the buttons on it to access the other forms. I like that idea.
Thanks for the tip.
Thanks for the tip.
Glad to be of assistance.
Lianne
Lianne
The switchboardnames that are displayed will be the name of the form, when you add a switchboard as a sub, you're able to specify the text on the MainSwitchboard, that can ofcourse differ from the switchboardname.
Need more info ?
Nic;o)