Re: [libreoffice-users] Macro code to highlight a field on a Form
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 lodg...@gmail.com On 2 July 2012 18:32, Tom Davies 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 wrote: > > From: Marion & Noel Lodge > Subject: Re: [libreoffice-users] Macro code to highlight a field on a Form > To: users@global.libreoffice.org > 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 > lodg...@gmail.com > > > On 1 July 2012 20:31, Tom Davies 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 wrote: > > > > From: Marion & Noel Lodge > > Subject: [libreoffice-users] Macro code to highlight a field on a Form > > To: users@global.libreoffice.org > > 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 oControlAS Object > > Dim oController AS Object > > Dim oControlViewAS 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 > > lodg...@gmail.com > > > > -- > > For unsubscribe instructions e-mail to: > users+h...@global.libreoffice.org > > 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: > users+h...@global.libreoffice.org > > 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: users+h...@global.libreoffice.org > 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 unsub
Re: [libreoffice-users] Startup positioning problem with LO 3.5.2.2
Thanks. I pulled down 3.5.1 and installed it, and the problem is still there. I could go back to a 3.4 version, but I don't know if it's that important to me. Foo. I'll just live with it. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] How can I edit a database with Calc ?
Thanks Dan, Andreas and Brian for your answers. On 01/07/2012 17:44, Dan wrote: You need to edit your database in Base. I'm not sure how you access your database in Calc unless you used the F4 key to open the database window. Even then, the F4 key opens the database and shows you the data in the tables and queries. Recommendation: "Download the Getting Started with Base" chapter (Ch 8 of the Getting Started Guide). This should help. Or perhaps download chapter 1 of the Base Guide. Both of these are found here: http://wiki.documentfoundation.org/Documentation/Publications --Dan Sylvain Vasseur wrote: Thank you for your detailed answer. Apparently my question wasn't. I created a database with Libreoffice Base, I've been able to access this database through Libreoffice Calc but I can't find a way to edit it with Calc. On 01/07/2012 17:04, Dan wrote: Sylvain Vasseur wrote: Your question does not make any sense. Calc is a spreadsheet. A database is a collection of information (a data source). It might be in the form of one or more spreadsheets. It might be one or more text files with a special format. An address book using the V-card format is an example of a text database. We need a much better explanation of your database that you want to edit. If it is a spreadsheet, what program was used to create it? --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] Macro code to highlight a field on a Form
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 wrote: From: Marion & Noel Lodge Subject: Re: [libreoffice-users] Macro code to highlight a field on a Form To: users@global.libreoffice.org 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 lodg...@gmail.com On 1 July 2012 20:31, Tom Davies 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 wrote: > > From: Marion & Noel Lodge > Subject: [libreoffice-users] Macro code to highlight a field on a Form > To: users@global.libreoffice.org > 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 > lodg...@gmail.com > > -- > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > 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: users+h...@global.libreoffice.org > 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: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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
[libreoffice-users] Re: Macro code to highlight a field on a Form
On 01/07/2012 12:11, Marion & Noel Lodge wrote: Hi, *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. The following is for Calc, but the methods for use in Base forms are similar : http://user.services.openoffice.org/en/forum/viewtopic.php?f=45&t=48984 The following discussion, and possibly others in the same forum if you trawl around a bit, might also help you out : http://user.services.openoffice.org/en/forum/viewtopic.php?f=39&t=31046 Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] Macro code to highlight a field on a Form
Marion & Noel , If you do some googling, you will find many examples how to handle a "com.sun.star.awt.UnoControlNumericFieldModel" or a "com.sun.star.awt.UnoControlEditFieldModel" Hope it helps Fernand 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 lodg...@gmail.com On 1 July 2012 20:31, Tom Davies 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 wrote: From: Marion & Noel Lodge Subject: [libreoffice-users] Macro code to highlight a field on a Form To: users@global.libreoffice.org 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 oControlAS Object Dim oController AS Object Dim oControlViewAS 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 lodg...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] General Error
On 2 July 2012 07:43, Nero wrote: > Could you give me instruction on how to do that on Windows please? I've > tried WinRar and Haozip and both are launching the file normally. > Rename a copy of the file with a .zip extension. You may then be able to open it with Windows' archive tool Nick > On Mon, Jul 2, 2012 at 4:20 AM, webmaster-Kracked_P_P < > webmas...@krackedpress.com> wrote: > >> >> The default Archive Manager for Ubuntu opens the file like it was a >> compressed one. So you should be able to extract the text and images for >> the presentation. From there, it might be recreated from those parts, or >> take the original file and use the extracted test to fill in the slides. >> > > -- > For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org > 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: users+h...@global.libreoffice.org 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
