I've just installed the postgresql SDBC drivers (version 0.5 at the
moment) and, as a new user of Open Office as well, I'm just groping my
way around trying to find what I can do.
My aim is to migrate an MSAccess database application (a simple
accounts system for my small business) to Linux. I wrote the MSAccess
system myself so I know (fairly well) how it works. It's not very
complex, it has three tables only, transactions, accounts and types.
The forms are the most complex part of it because I do things like tax
calculation automatically to prefill some fields which the user can
also modify manually.
I have been looking for a good database and database front-end to use
on Linux, I started with mySql but moved to postgresql because it has
more things like VIEWs etc. which are useful for my application.
As regards front-ends (e.g. report and form designers) I've looked
at:-
pgaccess - looks good but it's not really complete yet.
rekall - good but is a bit quirky in places, I actually
implemented som of my system before deciding it wasn't quite what
I wanted.
knoda - this is the front-end I have got furthest with so far but
I've hit a major snag so I'm trying OpenOffice
OpenOffice - Only started playing yesterday and actually got a
presentable looking form quite quickly.
It took me a while to beat through the details of getting OpenOffice
installed - the major (silly!) problem was that, once installed, I
couldn't find how to run it! It then took me a while to get the
postgresql driver installed and running but a bit of searching around
got that working.
Creating forms etc. in OpenOffice is much nicer in many ways than any
of the other front-ends I've used, using the Word Processor to do it
is an excellent approach. (I haven't looked at the Spreadsheet way
yet).
Now my first question, I need to add actions to some of the fields, I
can see how to do that from the control window but I need more help
with the actual 'programming' of the macros. So where can I find
documentation on the Macros?
If this should really be on the user list rather than the dev list
then apologies but as I'm using the very new postgresql drivers and
want to know about programming macros dev seemed more likely to be
right.
--
Chris Green ([EMAIL PROTECTED])
"Never ascribe to malice that which can be explained by incompetence."
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
