on right-click, open in new tab

[QueenKirsty]

I am creating an Access 2003 interface (.adp) for a SQL server 2000 backend and want to have some web browser-style features. I currently have a side panel that has the menu structure that can load various forms into a main panel but would like to have a tabbed pages feature like on web browsers. I.e. on right click have an option to open form in new tab. There are serveral questions surrounding this:
1. How do you alter the list of options shown on right-click?
2. How do you make new tabs on the fly and populate them with particular forms?
3. Can you have more than one (editable) copy of a form open at the same time showing different data?

Any help or advice would be appreciated. As would any other good UI suggestions, as this is a prototype to find out what can be done.

[ADezii]

I am creating an Access 2003 interface (.adp) for a SQL server 2000 backend and want to have some web browser-style features. I currently have a side panel that has the menu structure that can load various forms into a main panel but would like to have a tabbed pages feature like on web browsers. I.e. on right click have an option to open form in new tab. There are serveral questions surrounding this:
1. How do you alter the list of options shown on right-click?
2. How do you make new tabs on the fly and populate them with particular forms?
3. Can you have more than one (editable) copy of a form open at the same time showing different data?

Any help or advice would be appreciated. As would any other good UI suggestions, as this is a prototype to find out what can be done.

1. How do you alter the list of options shown on right-click?

By checking the Value of the Button Argument in the MouseDown() Event, or a Shortcut Menu.

Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = acRightButton Then
  MsgBox "Right Button clicked"
End If
End Sub

2. How do you make new tabs on the fly and populate them with particular forms?

Are we talking about a Tabbed Dialog Control?

3. Can you have more than one (editable) copy of a form open at the same time showing different data?

By creating a New Instance of a Form.