Open table automatically after launching Base

[cyberhape]

Hello,
I'm a newbie here in the OpenOffice community

I'm working with Ubuntu 8.10.
I migrated my data from MS Office to OpenOffice 3.0.1.
Now I'm missing a little feature from MS-Access. When I start MS-Access I could run a script/macro called "autoexec" which automatically opens a form or table.

So my questions is : Is there any possibility to do this also in OpenOffice Base ? At the moment I have to start Base and then double click on the table to open it.

Any help would be nice.
Thanks a lot

Peter

[QuazzieEvil]

hmm, thought I had answered this question already. Try the BaseTools extension. May not work out of the box (still working on it). But, there is some basic code that may help you. Look at the BaseLoader sub in the Utils Module. Bind this sub to the Open Document event of OOo. You can remove/comment lines that set event listeners. add line to open table--use RunCmd.OpenTable (i think that is what it is called).

[Villeroy]

Alternatively you can create a form, which is a Writer document with an abstract container of forms and form controls.
Save the Writer document somewhere in your file hierarchy.
Open the document, get toolbar "Form Design", turn on design mode (button #2), get the form properties (button #4), tab "Data".
Reconnect the form with the database document (push the tiny [...] button near "Data source" or select it by registered name).
Turn off design mode. If the form works OK, store and close the form and withdraw write access from the form document ( chmod -w ~/myForm.odt ).
Now this form will load in working mode rather than edit mode. Add a desktop link if you like.

[johhanus]

Dear,

some time go away, so may be, that thing is possible now?
(I mean possibility to simply-make some simple-autoexecmacro, as simple as openning one table on startup of the .odb file)

thank you very much in advance...
john

[DACM]

As Villeroy mentions here and in your previous post on this subject, it's possible to view and optionally interact with a table or SQL query using a Table Control added to a standalone Writer or Calc Form document, which can be opened directly from the desktop using a mouse click.