Base| Is it possible to set default tab index/tab order at 'Tables'?

[lonk]

Now it is always at ‘Forms’.

[Ratslinger]

Hello,

You can do this with a short macro attached to Open Document event of .odb:

sub OpenAtTables
    dim document   as object
    dim dispatcher as object
    document   = ThisComponent.CurrentController.Frame
    dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
    dim args1(0) as new com.sun.star.beans.PropertyValue
    dispatcher.executeDispatch(document, ".uno:DBViewTables", "", 0, args1())
end sub

This can be set to any of the four sections by changing the dispatcher uno command above using any one of the following:

.uno:DBViewTables
.uno:DBViewQueries
.uno:DBViewForms
.uno:DBViewReports

[lonk]

Dear @Ratslinger ,

Thank you so much.

Is this the same as in OpenOffice Base ?

Actually it’s not a big deal, it only scared me to death every time upon opening LO Base for I thought all tables are gone.

Maybe I got stuck with MS Access for decades.

[Ratslinger]

Actually don’t have AOO loaded on current systems but seem to remember it was the same. I am the opposite. Been a long time since Access and don’t even remember how it worked now.