> 4. > > We need to be able to create queries and the queries need to be > editable, i.e. we need to be able to add another field instead of > recreating the query from scratch. As far as i can tell, this is > not yet possible.
I suppose I didn't really get you here, since Base actually *is* able to edit existing queries. Can you elaborate? > 5. > > create one or more forms through which we can input the > information, delete it and/or alter it. Here, we pretty much use > one form which we have created to input most of the data. On this > form that other db program has allowed us to place buttons (or > create menu items) which basically run reports or produce a > letters or paper forms to be filled out by the family which > contain the _current_ family's info. This was a very basic click > (create button) and select (Which Query, Form or Report do you > wish to run?) procedure. We are unable to do this in Base yet. In fact that's not possible ATM. > 6. > > and finally, some way of getting the information out. ... So i'm very > happy to see that Base is finally coming along and now has a more > powerful Report Writer. However it still seems to have a long way > to go. We can't change the size of the second GUI column to make > it smaller. We can't change the rulers so that they read in > inches, for example. We don't know what they read in now. centimeters. This issue is known as problem 85303 now: http://www.openoffice.org/issues/show_bug.cgi?id=85303. > It would > be nice if the vertical ruler on the left hand side read all the > way from the top of the form to the bottom, instead of being > divided into sections. Sorry, this wouldn't work out: When you execute the report, it is *not* that all sections, as in the designer, are simply put after each other. That is, if in the designer, you have a report header of 2 inches, a detail band of 1 inches, and a report footer of 2 inches, then with one large ruler, the report footer would start at 3 inches. However, when you execute the report, then the report footer would start at "2 + ( n * 1 )" inches, since the detail section is *repeated* for every record which is printed. So, it doesn't make any sense to have one large ruler, it would prevent you numbers which are completely meaningless. > Printing still seems to be an art; the > printout still doesn't look like what is looks like in the layout > screen. Not sure about this ... well, the basic idea of the designer (if this is what you mean with "layout screen") is to design different sections (report/page/group header/footer, detail section), and repeat those sections, as required by the reported data, multiple times. By concept, the printout cannot look like the design ... ... /me is confused. I suppose you mean something different, so could you please go into detail here? > > 7. > > just before i went to sleep, i remembered this too and began to > dispair that we'd ever find a db that could easily replace MSA. i > remembered that Base is not multiuser. Indeed. Before Base becomes multi-user, we need to solve the file format problem, which was recently discussed in a sub thread initiated by Andreas Saeger. The current file format is simply unusable for multi user access. Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
