Difference between revisions of "Talk:MSA-Base Faq"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Lookup Columns)
(Lookup Columns)
Line 24: Line 24:
 
Edited to bring it up to it's own main topic and specifically state that it refers to table design.--[[User:Dale|Dale]] 14:05, 2 October 2006 (CEST)
 
Edited to bring it up to it's own main topic and specifically state that it refers to table design.--[[User:Dale|Dale]] 14:05, 2 October 2006 (CEST)
  
Great this is in its own topic, but how do you implement lookups 9even if you have to do it from a form).
+
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? ==
 
== How do I use Domain Aggregate functions in Base? ==

Revision as of 09:31, 10 August 2007


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