Having got Open Office to run and the database connection working (which was non-trivial) I'm quite impressed. Setting up forms to enter data into a database is quite clever.
Essentially you end up using the Open Office word processor as the forms designer which means that layout and so on is very easy and powerful.
However I'm left with one question, you can specify actions for data entry fields as in 'Changed', 'Mouse Button Pressed', 'After Updating', etc. but I cant really see how to program these actions.
When you click the '...' box beside an action an 'Assign Macro' window pops up with a whole load of what I assume are pre-defined actions which are called 'OpenOffice.org BASIC Macros' and there's also 'Untitled1 BASIC Macros' but I cant see how to actually use them. Firstly what do all the pre-defined macros do? Secondly how can I write something to do something useful to put in the Untitled1 position?
Any ideas anyone?
If I can get to understand this the OpenOffice database access looks very powerful indeed.
Chris Green wrote: snip
However I'm left with one question, you can specify actions for data entry fields as in 'Changed', 'Mouse Button Pressed', 'After Updating', etc. but I cant really see how to program these actions.
I assume you have RTFM? & visited their web site & joined their user forum? Sounds like you are a power user to me. I still can't get it to print landscape yet. <rant> I think word procs etc are grossly over featured for most people >/rant>
Ian
Ian
On Sun, Jan 23, 2005 at 10:40:24PM +0000, Ian bell wrote:
Chris Green wrote: snip
However I'm left with one question, you can specify actions for data entry fields as in 'Changed', 'Mouse Button Pressed', 'After Updating', etc. but I cant really see how to program these actions.
I assume you have RTFM? & visited their web site & joined their user forum? Sounds like you are a power user to me. I still can't get it to print landscape yet. <rant> I think word procs etc are grossly over featured for most people >/rant>
To work out how to connect to a Pastgresql database I had to resort to a Google search and then read between the lines somewhat and compare how to connect to other databases before I found the right format for the connection 'URL'. It's not a URL at all really which adds to the confusion!
I am wading through bits of the FM but they really seem to leave off just at the point where I need help (rather like MS Office really!). I haven't really spent much time looking at the Macros thing as I only just got the database connection working fairly late last night.
Oh, and finally, I *HATE* forums, the software is always so diabolical compared with using Usenet News or even a mailing list.
On Monday 24 January 2005 2:18 pm, Ian bell wrote:
Chris Green wrote: snip
Oh, and finally, I *HATE* forums, the software is always so diabolical compared with using Usenet News or even a mailing list.
Fortunately the OO forum is email based just like this one.
IAn
I am of the same feeling as Chris, I like Usenet (apart from all the trolls and usenet spam) and mailing lists are ok. Usenet is a great arena for discussion that is being killed by nasty forums (each of which require a login account and present different variations of the same nasty user interface.)
Usenet has the advantage over forums that the posts are clearly indexed and archived by Google Groups (although that is almost a moot point after the travesty that was the last "upgrade" Google made to groups)
I used to post very frequently to some of the hardware and linux orientated newsgroups, I started doing so after I realised that a quick google group (or previously deja) search would answer 80% of my computing problems. After you discover such a thing you start to feel guilty about not putting anything back.
Wayne Stallwood wrote:
On Monday 24 January 2005 2:18 pm, Ian bell wrote:
Chris Green wrote: snip
Oh, and finally, I *HATE* forums, the software is always so diabolical compared with using Usenet News or even a mailing list.
Fortunately the OO forum is email based just like this one.
IAn
I am of the same feeling as Chris, I like Usenet (apart from all the trolls and usenet spam) and mailing lists are ok. Usenet is a great arena for discussion that is being killed by nasty forums (each of which require a login account and present different variations of the same nasty user interface.)
Usenet has the advantage over forums that the posts are clearly indexed and archived by Google Groups (although that is almost a moot point after the travesty that was the last "upgrade" Google made to groups)
I used to post very frequently to some of the hardware and linux orientated newsgroups, I started doing so after I realised that a quick google group (or previously deja) search would answer 80% of my computing problems. After you discover such a thing you start to feel guilty about not putting anything back.
We are in serious danger of talking at cross purposes here. What I called the OO forum is a mail list *exactly* like this one. I used the term forum to mean aplace where people with similar interests can converse. I suspect you both thought I meany forum in the sense of a web based forum. Apologies for misleading folks.
Ian
On Tue, Jan 25, 2005 at 04:57:10PM +0000, Ian bell wrote:
Wayne Stallwood wrote:
On Monday 24 January 2005 2:18 pm, Ian bell wrote:
Chris Green wrote: snip
Oh, and finally, I *HATE* forums, the software is always so diabolical compared with using Usenet News or even a mailing list.
Fortunately the OO forum is email based just like this one.
IAn
I am of the same feeling as Chris, I like Usenet (apart from all the trolls and usenet spam) and mailing lists are ok. Usenet is a great arena for discussion that is being killed by nasty forums (each of which require a login account and present different variations of the same nasty user interface.)
Usenet has the advantage over forums that the posts are clearly indexed and archived by Google Groups (although that is almost a moot point after the travesty that was the last "upgrade" Google made to groups)
I used to post very frequently to some of the hardware and linux orientated newsgroups, I started doing so after I realised that a quick google group (or previously deja) search would answer 80% of my computing problems. After you discover such a thing you start to feel guilty about not putting anything back.
We are in serious danger of talking at cross purposes here. What I called the OO forum is a mail list *exactly* like this one. I used the term forum to mean aplace where people with similar interests can converse. I suspect you both thought I meany forum in the sense of a web based forum. Apologies for misleading folks.
I think I understood that you'd pointed that out earlier, however how does one join the "OO forum". If you mean the mailing lists at Open Office then I think I'm joined already, I've joined dev@dba.openoffice.org and users@dba.openoffice.org.
Chris Green wrote: snip
I think I understood that you'd pointed that out earlier, however how does one join the "OO forum". If you mean the mailing lists at Open Office then I think I'm joined already, I've joined dev@dba.openoffice.org and users@dba.openoffice.org.
users was the one I was thinking of.
Ian
-
Chris Green -
Ian bell -
Wayne Stallwood