Hi Tom, Thanks for the suggestion - Gnu Cash looks to be very comprehensive, but I would think twice about starting all over again on a new platform.
What I neglected to say was that I started writing the accounting system over 20 years ago as a Paradox application for a large non-profit organisation, (and I've been tinkering with it ever since!). Currently I am porting it from Paradox to the H2 SQL database, (rather than Base). As far as Macros are concerned, it has been a bit like starting all over again because I have never worked in Java before. But I have the app running pretty well now, and my latest project is to add more data entry automation. Hence my query as to how to highlight a field on a Form using Macro code. So if anyone knows how to do that, I'd be glad to hear from them. Thanks, Noel -- Marion & Noel Lodge [email protected] On 1 July 2012 20:31, Tom Davies <[email protected]> wrote: > Hi :) > It might be worth looking into Gnu Cash > http://www.gnucash.org/ > It may just need a plug-in / add-on to make it do what you want if it > doesn't already. > Regards from > Tom :) > > > > --- On Sun, 1/7/12, Marion & Noel Lodge <[email protected]> wrote: > > From: Marion & Noel Lodge <[email protected]> > Subject: [libreoffice-users] Macro code to highlight a field on a Form > To: [email protected] > Date: Sunday, 1 July, 2012, 11:11 > > I'm writing an accounting application and on the data entry Form I use a > macro to automatically fill in fields for regular recurring entries, e.g. a > payment of a Gas or Electricity bill. This speed up the data entry a lot, > as usually the only fields that need changing are the Date and Amount > fields. Then I use the following code to position the cursor in the Amount > field :- > > *Sub SetCursor(ThisComponent as Object, ControlName as String) > Dim oControl AS Object > Dim oController AS Object > Dim oControlView AS Object > > oControl = oFormTransHeader.getByName(ControlName) > oController = oControl.Parent.Parent.Parent.CurrentController > oControlView = oController.GetControl(oControl) > oControlView.SetFocus() > End Sub > > *This works well, but what I haven't been able to work out is how to > highlight the Amount field so that the user can then type in the new amount > over the top of the existing amount. The user could just type Ctrl + A, > but I'm trying to reduce key strokes to as few as possible. > > I've looked for code that would send Ctrl + A to the form, but drew a blank > on that. > I've also xRayed *oControlView*, but there doesn't seem to be any method > there that does highlighting either. > > Can anyone point me to a solution? > > Thanks, > > Noel > -- > Marion & Noel Lodge > [email protected] > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
