David Barr wrote:
Do any tutorials for Base exist? Specifically:
1) How do I commit the entries in a form to the relevant table? Do I
have the ability to introduce a button that will do the commit and
clear the form for the next entry? I have OO for Mac (with many other
problems) and PC.
2) How do I modify the tab order of fields in the form? The appearance
of the form is somewhat different from the order of the associated table.
3) Can I create a drop down list in a form that incorporates entries
from a separate table specifically set up to contain accepted entries
for the given field. For example:
The field "Sex" in the TableMain may contain only one of three values:
1, 2, or 3. A separate table, called ListSex, associates 1, 2, and 3
with the values "Male," "Female," and "Elbonian."
So, I create a form for TableMain. This form includes the "Sex" field.
Can I get this form to go look at ListSex, and give me a drop down
list for "Male," "Female," and "Elbonian," and then place 1, 2, or 3,
as appropriate, in TableMain?
4) Can I create sanity checks in a form. For example:
Say I have a boolean called CaseCreated. If this boolean is Yes, then
the field CaseNumber must have a value. If CaseNumber doesn't contain
a value, throw an error message and refuse to commit the entry.
For bonus points, can I create a sanity check that ensures CaseNumber
is in the proper format? (Say y-z-xxxx, from php's date() function
http://us2.php.net/date, and xxxx is an incremental from a different
database.)
Thanks!
David
There is a website dedicated to the Base project :
http://dba.openoffice.org/ There you will find details of a mailing
list relating specifically to Base and you may also find tutorials and
the like.
Documentation is generally hidden at a different location:
http://documentation.openoffice.org./
I have these bookmarks relating to teaching materials:
http://www.openoffice.blogs.com/
http://www.desktoplinux.com/news/NS5712069598.html
http://www.packtpub.com/openoffice-ooobasic-calc-automation/book
http://www.kaaredyret.dk/openoffice.html
http://www.getopenoffice.org/
http://openoffice.screencast-tutorials.com/index
http://openoffice.resolvo.com/
http://blogs.sun.com/oootnt/
http://www.taming-openoffice-org.com/
http://www.openofficetips.com/
http://www.tutorialsforopenoffice.org/
openofficetips.com relates mainly, if not exclusively, to Calc. The
desktoplinux reference is an article about a published book on
OpenOffice. packtpub.com specifically relates to basic and calc. I
cannot comment on the other locations.
There is also a forum for Base at www.oooforum.org
I don't use Base myself, so I cannot answer your specific questions.
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail.
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
