Examples of database forms?

[mn1247]

Does anyone have any examples of complex forms/databases that they would be willing to share? Something I might reverse-engineer to learn more about how to do forms?

Or are there good resources I should look at? I've read all the basic stuff.

Thanks

Eric

[voobase]

Hi Eric,

I'll give you some links to some of the example databases I've created over the last half a year. I'll put them in reverse chronological order as they probably get a little better each time. At the end is a link to a (free) commercial app I have been meaning to try but have not looked at yet.

With most of the databases you will need to load in the macro file as well. Go to Tools>Macros>OrganiseMacro>OOrgBasic (or press ALT F11) and then go to Organiser>Libraries>import. You will also need to make sure you register each database in Tools>Options>oOrgBase>Databases. Be a bit careful as I may have reused the same macro "Module Name" in a couple of them so you may find one database may need to overwrite the macro file of another.

Have Fun

Voo

http://www.oooforum.org/forum/viewtopic ... highlight=
http://www.oooforum.org/forum/viewtopic ... highlight=
http://www.oooforum.org/forum/viewtopic ... highlight=
http://www.oooforum.org/forum/viewtopic.phtml?t=71055
http://user.services.openoffice.org/en/ ... =13&t=5234

http://www.sunburnt.com.au/products/ledger/downloads

[Villeroy]

Recordsets (tables, views, queries), indices (keys), relations, SQL are the keywords common to all relational databases on the market. This is the "backend" which can be used in a database tool such as MSAccess, Base, Lotus Approach, or even a command line tool. Then you should see Base (like Access and many other tools) as a frontend to a variety of database backendss. It's not about file formats. It is about access to tabular data of any source, including some file formats such as csv or spreadsheets.
Knowing the basics about recordsets, indices, and relations you will be able to use dozends of database tools in the same manner. Forms are at the end of the chain. Forms are specific to the used frontend. In Base they are Writer documents with a form, bound to a recordset having form controls bound to fields of the recordset. In OOo Base does not support macros very well (they can not be stored in the database). In general macros are a very bad thing unless you really have some deeper knowlege of both, the backend and the frontend. Macros are not the way you should handle your database problems in the first place.