openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexandro Colorado <>
Subject Re: Request Advice on Use of OO's Base & MySQL to Accomplish a Task Done Nicely by MS Access
Date Sun, 07 Apr 2013 19:07:34 GMT
On Fri, Apr 5, 2013 at 3:25 PM, Tom Panfil <> wrote:

> Hello All,
> I've used Open Office on my MacBook Pro for about  three years and
> like it, but have not done anything particularly challenging.  I'm using
> Apache OpenOffice 3.4.0 now.
> I need advice as to whether OO's Base with MySQL can be used in a
> practical way to do some tasks, before making a major attempt to
> switch from MS Access to OO & MySQL for this work.  I started to
> make this switch 3 years ago but stopped when I learned that Base
> does not include its own database engine.  Sample tasks are as follows:

you might have misslearned that. Base always included it's own database
engine called HSQLDB

> For many years I used MS Access to facilitate mailing CDs, later DVDs,
> to attendees of ACM SIGAda Conferences, now morphed into HILT
> Conferences.  I'd use the Conference Attendee List in the Access DB
> to perform two jobs to support this work:
>  * Print shipping Labels via a DYMO Printer.  The labels would
>    include a graphic, the shipping address, the return address,
>    and the number of disks to be included in the package.
>  * Print US Customs Forms to mail to attendees from outside the
>    USA.  Initially the US Forms were a single sheet, then later they
>    changed to a triplicate format.  I handled that by separating the
>    forms and printing on three copies in succession, being careful
>    to keep the forms with the same pre-printed number together.
>    The info printed was essentially the same as that used on the
>    Shipping Labels.

OpenOffice Base uses Writer which has a good support for diferent page
sizes, and specifications.

> The critical capability provided by Access, besides driving jobs from its
> database, was the capability to control placement of the text very
> precisely, to match the fields on the pre-printed forms.
> I'd really rather be able to do this job running OO's Base and MySQL
> directly from Mac OS X, rather than starting my Windows XP Virtual
> Machine, mechanized via Parallels, so that I can use MS Access
> from my MS Office XP Professional software.
> Do such tasks seem appropriate for OO's Base & MySQL?  Can Base
> provide very critical control of the positioning of text?

I suggest to have a look at our forums where there are many sample
databases and you can work with the people there to get you up to speed.

> v/r,
> Tom Panfil

Alexandro Colorado
Apache OpenOffice Contributor

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message