Form Tabs (1 Viewer)

[tjnichols]

I have several databases that I have inserted tabs with sub forms. When I open the form, I can't see the tabs. I have to use the scroll bar to move the window to where I can see the tabs. Can someone tell me how to make the form so I can see them?

Can you also tell me how to add a control key to be able to navigate to a tab without using the mouse? This last one is an extra but I thought it would be cool.

I have attached one so you can see what I am talking about.

 

[Taruz]

Hi..

Put onopen part of the form..:

Sendkeys "{pgup}"

.

 

[tjnichols]

"Put onopen part of the form..:

Sendkeys "{pgup}" "

I am sorry but this is greek to me. Where do I put this?

 

[Taruz]

Hi again..

See the image ..:

 

[tjnichols]

How do I make the Form_Asset Details show?

 

[tjnichols]

Please excuse my ignorance. I don't know how to get the detail part (subform of Consumers) to show up in the Visual Basic editor. Can someone please help me here? I have clicked on everything that makes sense to me.

Thanks.

Tonya

 

[boblarson]

Bad choice to use SendKeys. You should avoid that at ALL COSTS as it is not reliable and will not work on some Windows versions.

You should be able to set focus to the top most control on the tab page when it is selected. You can use the On Change event of the main tab control to set it:

As an EXAMPLE:

Private Sub tabCtl2_Change()
    If Me.tabCtl2 = Me.tabCtl2.Pages("PageNameHere") Then
        Me.ControlNameHere.SetFocus
   End If
 
End Sub

And it should force it up.

 

[Simon_MT]

There is too much space used on the Main Form. To alleviate this, I'm looking at Consumers, put some of the Consumers info on a new Tab (the first) along with Notes and Attachment.

Simon

 

[tjnichols]

Simon - the information that appears on the Consumers form needs to be there.

Bob - I don't see a choice of OnChange. Can you tell me where I can find this?

Thanks!

 

[Pat Hartman]

The scrolling is seriously annoying. You need to decrese the vertical height of the forms so that they fit in the current standard "wide" screen.

There is no code that will eliminate the scrolling even if you can get the form to open with the tabs showing. Plus, the tabs will keep disappearing as you move through the subforms. Squish the vertical height. Remove all unused space and then make the forms wider or add more tabs if there just isn't enough room.