Hi, Many thanks for all the replies.
I'm away for the next few days, so I'll try the suggestions out when I get back and let you know how I go. Noel -- Noel Lodge [email protected] On 2 July 2012 18:32, Tom Davies <[email protected]> wrote: > Hi :) > Lol, that does make a big difference. Continuity is important. I have > just seen too many people start trying to write something new purely > because they didn't realise other companies may have similar issues to deal > with. Even trying to re-write accountancy principles to suit themselves, > making the finance director's and the accountant's life hell for no reason. > Regards from > Tom :) > > > --- On Mon, 2/7/12, Marion & Noel Lodge <[email protected]> wrote: > > From: Marion & Noel Lodge <[email protected]> > Subject: Re: [libreoffice-users] Macro code to highlight a field on a Form > To: [email protected] > Date: Monday, 2 July, 2012, 2:50 > > 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 > > > -- > 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
