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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Lookup Columns)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
 
 
 
== How do I import/convert my Access database to Base ==
 
== How do I import/convert my Access database to Base ==
  
Line 22: Line 19:
 
== Lookup Columns ==
 
== Lookup Columns ==
  
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 its 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 (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? ==
Line 33: Line 28:
  
 
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.--[[User:Dale|Dale]] 14:08, 2 October 2006 (CEST)
 
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.--[[User:Dale|Dale]] 14:08, 2 October 2006 (CEST)
 +
 +
== Workarounds for limitations ==
 +
 +
Is this the appropiate place to collect limitations and possible workarounds? Searching the forums etc. is sometimes hard due problem description etc.
 +
When question is yes, how do we do it? Short description with link to topic on form or adding solution as well?
 +
Any thoughts?
 +
Erik
 +
 +
== Change the title of this page ==
 +
 +
As a newbie I had some problems migrating from Access. The title of the page is *not* helpful. You have to know that MSA means "Microsoft Access". You can't find it when searching by title. The title should be something like "Migrating from Microsoft Access". Can someone change it for me. I'm scared I might mess it up. [[User:Tenbob|Tenbob]] 01:58, 22 December 2009 (UTC)

Latest revision as of 01:58, 22 December 2009

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 its own main topic and specifically state that it refers to table design.--Dale 14:05, 2 October 2006 (CEST)

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)

Workarounds for limitations

Is this the appropiate place to collect limitations and possible workarounds? Searching the forums etc. is sometimes hard due problem description etc. When question is yes, how do we do it? Short description with link to topic on form or adding solution as well? Any thoughts? Erik

Change the title of this page

As a newbie I had some problems migrating from Access. The title of the page is *not* helpful. You have to know that MSA means "Microsoft Access". You can't find it when searching by title. The title should be something like "Migrating from Microsoft Access". Can someone change it for me. I'm scared I might mess it up. Tenbob 01:58, 22 December 2009 (UTC)

Personal tools