Talk:MSA-Base Faq

From Apache OpenOffice Wiki
Revision as of 09:31, 10 August 2007 by Ian hulin (Talk | contribs)

Jump to: navigation, search


How do I import/convert my Access database to Base

We seem to be missing a couple of obvious FAQs. Probably because the page has just started and no one has got around to them yet.

How do I import/convert my Access database to Base?

As of ver 2.0 there is no direct method for this. Tables can be read from the mdb or converted to a more Base-friendly format (native Base tables, Calc spreadsheet, csv). <<Probably need some indication of method here. Or maybe reference to a separate (yet to be written) HowTo>>

Forms and reports cannot be imported and have to be re created from scratch.

There is no direct equivalent to Access macros. These have to be re created from scratch in a language supported by OOo (StarBasic, ...)

Code modules: OOo and Base do not support VBA. The code used in you Access database will have to be rewritten in a language supported by OOo.

+ + + + + Dale

Lookup Columns

Edited to bring it up to it's own main topic and specifically state that it refers to table design.--Dale 14:05, 2 October 2006 (CEST)

Great this is in its own topic, but how do you implement lookups (even if you have to do it from a form)?

How do I use Domain Aggregate functions in Base?

Added entry. Pls review for correctness, and clarity. Add any further explanation that seems appropriate.--Dale 14:07, 2 October 2006 (CEST)

How do I add Calculated Controls to my forms and reports?

Added entry. This is almost a direct copy of DrewJensen's contributions in oooforum.org. Pls review to make sure I haven't trashed Drew's good words.--Dale 14:08, 2 October 2006 (CEST)

Personal tools